Borland®
Shop
Products Downloads Services Support Partners News & Events Company Community
Company

 SQL LINKS DEVELOPER SUPPORT

SEARCH Borland Online/Developer Support

Tech Notes Index


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


 
Site Map Search Contact