Dear all

If you execute this command in SQL2000 Enterprise Manager then you will get
a result set of all columns of 'MYTABLE'

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME='MYTABLE'

However if you use a Dephi5 TQuery with its SQL as above, you can 'Open' the
TQuery, but you will get no results.

Anyone can teach us why?

Thanks
John

Dear all

If you execute this command in SQL2000 Enterprise Manager then you will get
a result set of all columns of 'MYTABLE'

SELECT COLUMN_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE
TABLE_NAME='MYTABLE'

However if you use a Dephi5 TQuery with its SQL as above, you can 'Open' the
TQuery, but you will get no results.

Anyone can teach us why?

Thanks
John

1. cast is as varchar:
SELECT CAST(COLUMN_NAME as VARCHAR(254)) FROM .....
2. switch to ADO. BDE works via DBLib, which Microsoft didn't update since
MSSQL 6.5

--
Robert