Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary key (cdx), insert into and error messages
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00270021
Message ID:
00270093
Views:
30
SELECT remote_sys
IF RLOCK()
   ln_invoice_numb = remote_sys.invoice_numb
   REPLACE remote_sys.invoice_numb WITH remote_sys.invoice_numb+1
   UNLOCK
ELSE
   * And what if the RLOCK() fails?
ENDIF
* AS failed RLOCK() would continue with this code and cause all kinds of 
*  problems
INSERT INTO invoice_head (invoice_numb, location_id, customer_id, issue_date, ;
   shipping, login_id, req_numb) VALUES (ln_invoice_numb,ln_location_id, ;
   ln_customer_id, DATE(), ' ', 'SMcLaughlin', 0)
INSERT INTO invoice_lin (invoice_numb) VALUE (ln_invoice_numb)
SELECT invoice_head
SET ORDER TO TAG invoice_numb ********
SEEK ln_invoice_numb
pn_recno = RECNO()
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform