Re: Identity columns and RLA

[Peter Dow <petercdow@xxxxxxxxx>]

Thanks Vern. I'm thinking I'll change the program to just use SQL for 
everything, since it's simpler.  But I was curious about mixing RLA and SQL.


On 8/31/2016 1:16 PM, Vernon Hamberg wrote:
> There's an IDENTITY_VAL_LOCAL function you can use to get the last 
> assigned - it'd be an SQL statement, like SET or VALUES
>
> HTH
> Vern
>
> On 8/31/2016 3:05 PM, Peter Dow wrote:
> > What happens when writing a record with RLA to a table that has an 
> > identity column?
> >
> > Assuming it actually works, i.e. ignores the value in the identity 
> > column on the WRITE, is there a way to get the value assigned to the 
> > identity column?
> >
> > --
> > *Peter Dow* /
> > Dow Software Services, Inc.
> > 909 793-9050
> > petercdow@xxxxxxxxx <mailto:petercdow@xxxxxxxxx>
> > pdow@xxxxxxxxxxxxxx <mailto:pdow@xxxxxxxxxxxxxx> /