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