Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Auto increment - a little differently
Message
 
 
To
15/05/2004 07:39:48
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00903639
Message ID:
00904445
Views:
24
This message has been marked as the solution to the initial question of the thread.
Insert 0, anyway it'll be assigned by SQL Server.
Insert into Invoices (INVOICENO, Amount) Values (0, Amount)
IF NOT TABLEUPDATE()
  * Error
ENDIF
* Get new record with Identity value from backend
IF REQUERY() = 0
  * Error
ENDIF
>Sergey,
>
>Example: Insert into Invoices (Amount) Values (Amount)
>
>Error: Field INVOICENO does not accept null values.
>
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform