[ic] return value of autonumber or code at time of INSERT
lists at gmnet.net
Tue Aug 23 11:34:18 EDT 2005
On Tue, 2005-08-23 at 07:49 -0700, Paul Jordan wrote:
> interchange-users-bounces at icdevgroup.org wrote:
> > On Mon, Aug 22, 2005 at 03:56:43PM -0500, Mike Heins wrote:
> >> If you are using [query ...], which was not intended by me to do
> >> database updates, then all bets are off. I don't know how to get the
> >> key off the top of my head and I ain't looking.
> > Ut oh - I use the heck out of the query tag to do updates via
> > SQL. What would be the more appropriate way to do it?
> Yeah :) So did I, but eventually went to embedded perl because returning the
> newly inserted "code" is highly desirable in my applications and when you
> are doing inserts you do have to scrub the data a bit yeah? So, embedded
> perl is cleaner all around.
> It works great both ways.
I will change my ways!
I'm still having trouble understanding how the database should be set
up. I started a new thread for that.
Thanks everybody for your help.
More information about the interchange-users