I try to create SQL from my table but after I run it .. it's very very wasting time to wait for load .. any body know how to solve
my problem for make faster while loading the records by using SQL ?
the statement is :
Dim DBDS as Database
Dim RDS as Recordset
Set DBDS = OpenDatabase(DS.DatabaseName, False, True, DS.Connect)
sqltrap = "Select * from DS where tgl = " & "#" & txtDate.Text & "#" & "Order by pl_no, line, cproc, worker"
Set RDS = DBDS.OpenRecordset(sqltrap)
thanks for any advice
Regards
Winan
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