I'm inserting a record, which puts data in fields 2,3,4...
Field 1 is the UID, which the database auto-increments. That's the value I want. All I can think of is creating that record with some uniquish temp value and then querying for that temp value to find the UID value. Kinda messy.
On Sunday, August 24, 2003, at 03:25 PM, Wayne Irvine wrote:
Another case of brain freeze....
I create a new record. The database auto-increments the unique id field.
How do I get that field value for the next action of my application?
It's in the resultSet. Just refer to resultSet[1,1] or assign the result set
to a Var and use it anywhere in your app.
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
