Using TADODataset

Brian Hollister

Delphi Developer

Using TADODataset

2005-01-06 08:45:34 PM
delphi36
Hi,
D7, MDAC 2.8, SS 2000
Are there any advantages to using the IndexFieldNames and IndexName property
of the TADODataset versus just writing the SQL the way you want your result
set returned?
thx,
brian

Viatcheslav V. Vassiliev

Delphi Developer

2005-01-07 04:43:23 AM

Re:Using TADODataset

MS SQL Server OLEDB provider does not support indexes. SQL with WHERE/ORDER
BY clause is the best way for TADODataSet to restrict returned rows or order
them.
//------------------------------------------
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)
"Brian Hollister" <bhollisterATfuturaintlDOTcom>ÓÏÏÂÝÉ?ÓÏÏÂÝÉÌÁ ?ÎÏ×ÏÓÔÑÈ
ÓÌÅÄÕÀÝÅ? news:XXXX@XXXXX.COM...

Quote

Hi,

D7, MDAC 2.8, SS 2000

Are there any advantages to using the IndexFieldNames and IndexName
property
of the TADODataset versus just writing the SQL the way you want your
result
set returned?

thx,

brian