Gunther,
You re absolutely right. Done!
Thanks.
CASE aWAData[ WA_ENGINE ] == "MSSQL"
aWAData[ WA_CONNECTION ]:Open( "Provider=SQLOLEDB;" + ;
"server=" + aWAData[ WA_SERVER ] + ;
";database=" + t_cDataSource + ;
iif(empty(aWAData[ WA_USERNAME ]),";Trusted_Connection=yes",;
";uid=" + aWAData[ WA_USERNAME ] + ;
";pwd=" + aWAData[ WA_PASSWORD ] ))
Antonio, for MSSQL should on line ~464 the [WA_ENGINE] "MSSQL" to be and not "SQL"!! And if the authentification to the DB without a password but with windows-authentification the text "Trusted_Connection=yes" should be used.
CASE aWAData[ WA_ENGINE ] == "SQL"
CASE aWAData[ WA_ENGINE ] == "MSSQL"
CASE cEngine == "MSSQL"
oCn:Open( "Provider=SQLOLEDB;" + ;
"server=" + cServer + ;
";database=" + cDB + ;
iif(empty(cUser),";Trusted_Connection=yes",;
";uid=" + cUser + ;
";pwd=" + cPass ))
.....
SET ADODBF TABLES INDEX LIST TO { {"CCRTBL",{"CCRTBL1","TBL_RMNO"},;
{"CCRTBL2","UPPER(TBL_LAST)"}}, ;
{"CCRGST",{"CCRGST1","GST_INTNO"}} ;
}
SET ADO TABLES INDEX LIST TO { {"CCRTBL",{"CCRTBL1","TBL_RMNO"}, ;
{"CCRTBL2","TBL_LAST"}}, ;
{"CCRGST",{"CCRGST1","GST_INTNO"}} ;
}
cSTime := time()
USE ccrgst ALIAS 'gst' NEW SHARED
cETime := time()
MsgInfo('Open Time : '+cSTime+' - '+cETime+' Reccount() : '+Str(gst->(Reccount())) )
2) open record with relation is quite slow. I think the point is JOIN table is the key. Because 'CCRGST' table (guest details) no need to open all records but only the records which related with main table 'CCRTBL' (reservation details).
Is it correct?
How do I join 2 table with ADORDD?
lucasdebeltran wrote:Hello,
Set relation works the same way as in DBFCDX.
Try at adordd.prg to comment out all cache settings. I am using ADORDD in a WAN scenario via Internet and speed is very good.
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: nageswaragunupudi and 30 guests