General information
Forum:
Microsoft SQL Server
Hi,
I have this problem (using SQL2000):
I have 3 fields in a table
cCode_id CHAR(10) -- primary key
cAccount_id CHAR(2)
nAccount_num INT (set as an identity key)
when I save the record (I'm using a VFOX 8 app) I need to update the cCode_id WITH the values of the cAccount_id and the nAccount_num, so basically cCode_id+"-"+C0NVERT(nAccount_num AS char(8)).
It seems the insert trigger would be a good choice but have to take into account that there's an identity key, anybody know of a good technique to do this?
basically when I save if I have:
cAccount_id
RH
nAccount_num
8 - (note that this is an identity key)
Then the value for cCode_id:
RH-8
Thanks.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only