Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to check backend sql server connection before sync d
Message
 
To
24/12/2009 19:49:03
Hee Lim Wang
Fantasy Software Enterprise
Malaysia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01440599
Message ID:
01440611
Views:
44
>Hi
>I want to use a timer control to sync client data back to backend MySQL server every 5 minutes
>before update i want to check the connection of my back end MySQL server is ready first
>how to write the coding using SQLEXEC( ) ???

Hi,
IF SQLEXEC(handle,"SELECT CURRENT_DATE() ")=1
   ?"OK"
ENDIF 
MartinaJ
"Navision is evil that needs to be erazed... to the ground"

Jabber: gorila@dione.zcu.cz
Jabber? Jabbim
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform