[ic] return value of autonumber or code at time of INSERT

[maillists]

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.
> 
> Paul

I agree,

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.
Chris