|
ronin2307
Posting Yak Master
126 Posts |
Posted - 07/18/2006 : 15:48:34
|
I'm sure my problem is not unique, but I am having a hard time thinking of a way to solve it so here it is: I have a VB form with some fields on it, which are used to create a new entry in one of my SQL tables. The design kinda goes like this: all fields are mandatory and in addition to that the primary field (fid) in the table is the identity field which self increments. So the question is: how do I retrieve the id value from the fid field for my newly created entry? To make things harder, it is possible that two entries can have ALL fields identical.
thanx |
|