Select * returns Unspecified Error, but Select ID WORKS ... HELP

From: Chad (cwortham_at_flwoutdoors.com)
Date: 01/11/04


Date: 11 Jan 2004 10:21:43 -0800

I am trying to figure out why Delphi and ADO are having a problem
selecting data from Sybase database.

I am trying to run a query like this "Select * from Orders" but I get
Unspecified Error. But if I identify the columns like "Select ID,
OrderDetail, OrderQty from Orders" it works just fine.

Does anybody know why and how to solve without the column names? I
would like to use Select *.

Delphi 7 / Sybase SQL Anywhere 8.01.

Thanks,

Chad