Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 4 of 4 total |
Next 'autoinc' value?? |
Fri, Jul 16 2021 10:43 PM | Permanent Link |
Ian Branch | Hi Team,
Is there a way to determine the next autoinc value before actually posying the new record? Regards & TIA, Ian |
Fri, Jul 16 2021 11:16 PM | Permanent Link |
Ian Branch | I should have said programmatically. Not via SQL.
I can't see anything that looks like edbTable1.LastAutoInc or edbtable1.Nextautoinc. Ian |
Sat, Jul 17 2021 2:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Ian
No, and I can't see how there could be. Consider two users (or two threads or whatever). A checks the next autoinc, but whilst this is happening B posts - woops. The only way to do it is maintain the values yourself. Roy Lambert |
Sun, Jul 18 2021 5:25 AM | Permanent Link |
Ian Branch | Hi Roy,
Actually I meant the last autoinc value. I cheated and simply open the table, goto last, read the value, close the table, use the value. All in 4 lines. Seems to be working fine. Fortunately, this isn't a multi-user application. Regards, Ian |
This web page was last updated on Tuesday, April 30, 2024 at 03:55 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |