Board index » delphi » Help, MaxRecords?? and insert from another database (mdb)

2004-11-11 12:32:52 PM
delphi86
please anyone help me.
i have trouble with MaxRecords.
if i set
ADODataSet1.MaxRecords:= 100;
i get only 100 records, how can i get next 100 records?
and one more thing, can i insert some data from another database (mdb) using
sql command?
i want to copy like BatchMove do, can i have some code that is simple?
thanks for attention and helpfull.
sorry for english.
 

MaxRecords is max records - to select part, the best way is to use primary
key and SELECT * FROM XXX WHERE ID BETWEEN ...
Copy from one mdb into another:
SELECT * INTO DestTable FROM SrcTable IN "C:\Temp\Test.mdb"
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Iwan Haryadi" <XXXX@XXXXX.COM>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅ? news:XXXX@XXXXX.COM...

How about the password??
Can i supply it in the SQL?
Thanks a lot.
"Viatcheslav V. Vassiliev" <XXXX@XXXXX.COM>writes

SELECT * INTO Test2 FROM Test IN
"" [;DATABASE=c:\temp\test2.mdb;PWD=ThePassword]
//------------------------------------------
Regards,
Vassiliev V. V.
www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)
"Iwan Haryadi" <XXXX@XXXXX.COM>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅ? news:XXXX@XXXXX.COM...