Announcement

Collapse
No announcement yet.

2 text in one !

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 2 text in one !

    hy, sorry by my english !

    i have 1 table with ID in autonumeric, and CODE in text, CODE has a mask "CRI - ", so what i need to do is concatenate "CRI - " & ID, so it will return "CRI - 1" and it increase in every new record!

    please sombody can help me !

  • #2
    Yo creo que tiene que hacer en el evento afterinsert un update a ese campo mediante la funcion lastid generado por el autonumerico.

    Comment

    Working...
    X