Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Pass a web variable to a stored procedure
Message
From
29/01/2008 14:58:15
Don Freeman
Pag
Tucson, Arizona, United States
 
 
To
29/01/2008 14:54:00
Viv Phillips
Hay-On-Wye, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Internet applications
Title:
Re: Pass a web variable to a stored procedure
Miscellaneous
Thread ID:
01257541
Message ID:
01286882
Views:
28
<>

>>Thanks Viv -
>>user_id is an autoinc integer field in the table.
>>The command refuses to execute and the error says "Unrecognized command verb"
>
>Hi,
>Try:
>oConn.Execute("Insert into Users (Name) Value ([Fred])")
>o= oConn.Execute("Select MAX(User_id) from Users")
>? o.Fields(0).Value
>But it could of course fail to return the correct User_id if another session snuck in another insertion between the two calls :={

Yes. Thanks Viv, that was my workaround and it works OK but with the problem you outlined. I was trying to explore the other approach for both this and future situations.
- DF
Previous
Reply
Map
View

Click here to load this message in the networking platform