Page 1 of 1

Automatic increase aphanumeric in a field

Posted: 2017-12-14 04:53
by lectura
How are you Appgini family.
I need help here. I have this fields in my table named Reception: 'ID' 'CwNo' 'Name' i want values for 'CwNo' to have autoincrease with BMK000001, BMK000002 etc. As am not allowed to have two primary key in one table. Am using the current appgibi 5.6
Thank you as you guide me.

Re: Automatic increase aphanumeric in a field

Posted: 2017-12-15 01:20
by AhmedBR
Take a look at this very old post, might do what you need:
viewtopic.php?f=4&t=786&p=3875&hilit=au ... ment#p3875

Re: Automatic increase aphanumeric in a field

Posted: 2017-12-18 16:23
by lectura
Thank you i was able to follow the thread. Am greatful.