Sybase (CTLIB SYBSSC32.DLL) SQL Links Driver, BDE 4.x

Solution: Use a tquery to "open" the stored procedure.

(For additional info please see the topic on Sybase in the BDE32.HLP file by using the help file Index tab to search for SYBASE) Delphi Example: Add "BDE" to your unit's uses clause

Button Click procedure to open results from a Tquery ("exec storedproc"):

procedure TForm .Button2Click(Sender: TObject); begin

query .prepare; dbisetprop(hdbiobj(query .StmtHandle),stmtEXECASCURSOR, ); query .open;

In this example: the StoredProc name is LINEITEM_RSLT:

CREATE PROCEDURE LINEITEM_RSLT AS ( SELECT * FROM lineitem ) Tquery sql strings for this example would be:

exec LINEITEM_RSLT

3/26/99