Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Best Practice - Should the Connection Handle be stored
Message
 
To
21/11/2005 17:27:03
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 6 SP5
Miscellaneous
Thread ID:
01070716
Message ID:
01071064
Views:
19
Hi Carlos

>I do exactly as you ask...
>
>
>
>* Open:
>goApp.ConnectionHandle = SQLConnect(.....
>
>* Close:
> If goApp.ConnectionHandle > 0 Then
>    SQLDisconnect(goApp.ConnectionHandle)
> Endif
>
>
Aah, this is interesting to me, I was getting the handle from the open remote view. I guess I will have to study SQLConnect and SQLDisconnect to get the connection the real way. My concern had come from the way I was obtaining the handle, from the View, so my concern was what when the DBC was closed and reopened would the handle be still valid, but your way I do not think that will ever be a problem, as the handle was obtained independently.

Thanks a lot.
Regards
Bhavbhuti
___________________________________________
Softwares for Indian Businesses at:
http://venussoftop.tripod.com
___________________________________________
venussoftop@gmail.com
___________________________________________
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform