Best Practice - Should the Connection Handle be stored
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01070716
Message ID:
01070716
Views:
64
Hi all
Whenever I do a SQL Pass-Thru using SQLEXEC() I get the connection handle at the time just before the call to SQLEXEC() with a line as below:
lnConnHnd = CURSORGETPROP("ConnectHandle")
My question is this can I pre-store this handle in the application object goApp as a property? ie. are there any pitfalls if it is not GetProp()ed just before the SQLEXEC() call?
Please advise.
Regards Bhavbhuti ___________________________________________ Softwares for Indian Businesses at: http://venussoftop.tripod.com ___________________________________________ venussoftop@gmail.com ___________________________________________