Versions des environnements
Hi Dragan & Doug,
Thanks for all the advices.
And Sorry for late response. I was on holiday leave.
Yep. I got the concept. Actually, I already have one public variable which is holding the connection handle. In the initial start up of my application, i build up the connection string and assign the handle number to one Public Variable. Afterward, I use only that variable to connect to SQL Server for wherever in the system regardless of RVs or SPTs. So now should I use the same in CAs? Is this a correct logic?
Here's my CA coding concept. I've a general CA class. And everytime when new object CA is build up, in the "Init" method of CA class :
LPARAMETERS lpDriver, lpServer, lpDatabase, lpUid, lpPwd
LOCAL lnHandle, lcConnString
SQLSETPROP(0, "DispWarning", .F.)
SQLSETPROP(0, "DispLogin", 3)
lcConnString = [driver=]+lpDriver+;
[;server=]+lpServer+;
[;database=]+lpDatabase+;
[;uid=]+lpUid+;
[;pwd=]+lpPwd+;
[;trusted_connection=No]
THIS.NConnHandle = SQLSTRINGCONNECT(lcConnString,.T.)
This.DataSource = THIS.NConnHandle
This.DataSourceType = [ODBC]
THIS.InsertCmdDataSourceType = [ODBC]
THIS.InsertCmdDataSource = THIS.nConnHandle
THIS.UpdateCmdDataSourceType =[ODBC]
THIS.UpdateCmdDataSource = THIS.nConnHandle
THIS.DeleteCmdDataSourceType =[ODBC]
THIS.DeleteCmdDataSource = THIS.nConnHandle
Regards,
Mya
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement