![]() |
|||||||||||||||||
|
|
|||||||||||||||||
|
|
|||||||||
|
Company
|
SQL LINKS DEVELOPER SUPPORT
SEARCH Borland Online/Developer Support
Subject: RecordCount problem The 16-bit and 32-bit BDE Engine may generate a "Table operation not supported" when executing the DBIGetRecordCount() function or when accessing the Query1.RecordCount property in Delphi. This problem will occur when accessing InterBase tables (and possibly the tables in other SQL databases and tables accessed via ODBC drivers) when the table contains a CHAR and VARCHAR column longer than 255 characters. The workaround is to use a TTable or add another TQuery object that executes the following SELECT statement; SELECT COUNT(*) FROM <MYTABLE> ... If the dataset result is a "reasonable" size the the recordcount property will be accurate if myTQuery.last is issued first. PUB IB LINK ERROR PP
|
|
|
|
|||||
| Made in Borland® Copyright© 1994-2003 Borland Software Corporation. All rights reserved. Report Piracy, Legal Notices, Privacy Policy Last Modified Monday, 26-Mar-2001 16:27:06 PST |
|||||