Select * returns Unspecified error, but Select ID WORKS --- Help !!!!

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


Date: 11 Jan 2004 10:18:02 -0800

I am trying to track down why Delphi and ADO is having a problem
trying to select records.

I am connecting to Sybase database, when I try to perform the
following query "Select * from Orders" I get Unspecified error. But if
I spell out the columns it works "Select OrderID, OrderDesc, OrderQty
from Orders".

Can anybody tell me why and what to do fix the problem.

Also Select * worked at first, but now it craps out.

Thanks,

Chad



Relevant Pages

  • Re: Delphi 8 and ado.net
    ... > different to using say ADO in Delphi? ... The Delphi ADO implementation is basically a wrapper around the Recordset ... have cursors into the database, there are no cursors in ADO.NET. ...
    (borland.public.delphi.non-technical)
  • Re: Sub Selects?
    ... > some nice Delphi DB technique to do this, or should I just build up the ... Due to the way that the ado ... lets assume that you have a list called SelectedIds ... I'd recommend against using the filtering method. ...
    (borland.public.delphi.database.ado)
  • Re: recursive sp, fmtonly, ado,
    ... This was the first thing I've checked, because I suspect Delphi. ... It's in somewhere inside ADO or OLEDB. ... >> create procedure fmttest ...
    (microsoft.public.sqlserver.programming)
  • Re: Field position in a record, how to change?
    ... If you know how to move fields with DAO you can use Ole to access the ... I have found how to obtain the (ADO) FieldDefs for the ... (I am searching documentations for this option but your answer might ... I may just have found the answer in my saved Delphi 5 help files ...
    (borland.public.delphi.database.ado)
  • Re: BDE alternatives?
    ... Remember that Hannes is a developer for NexusDB, ... Anyway, I think every Delphi DB solution will, after the next Delphi.NET ... In either case, in practice, you put down an ADO connection ...
    (borland.public.delphi.non-technical)