Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is it or isn't is ASyncronous?
Message
From
06/09/2012 11:46:09
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Is it or isn't is ASyncronous?
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Miscellaneous
Thread ID:
01552494
Message ID:
01552494
Views:
76
Correct me if I'm wrong, but I shouldn't have to reset the ASyncronous setting (SQLSETPROP) between SQLEXEC calls, should I?

Thanks to Tore and Sergey, I've got the first one SQL call working. I've got another SQL call to fetch the UID of the Master record just inserted, then I build the child record.

So, the order should be:

Insert Master Record
Get MasterID of new Master Record
Insert Child Record with ChildID = MasterID

But what it seems like I have to do is

Insert Master Record
SQLSETPROP(mconn, 'Asyncronous', 'T')
Get MasterID
Insert Child

What am I missing?

btw, SQLGETPROP tells me that Async is set to true anyway.
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Reply
Map
View

Click here to load this message in the networking platform