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

Paul Jordan paul at gishnetwork.com
Tue Aug 23 10:49:58 EDT 2005

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.


More information about the interchange-users mailing list