BorlandTalk.com

Ross Wise · Guest

I am working on a D7 application connected to a IB6.5 Server.

My connection is establishing OK.

This Code:

sds_ClientHeaders.Params.ParamByName('ClientID').AsInteger := StrToInt(eFetchClientID.Text)

is creating the error:

"Project VESTA.exe raised exception class EDatabaseError with message "sds_ClientHeaders : Parameter 'ClientID' not found."

sds_ClientHeaders is a SimpleDataSet

with: InternalDataSet.CommandType = ctQuery
InternalDataSet.CommandText = SELECT * FROM D_CLIENT_HEADERS
WHERE "ClientID" = :ClientID ;

The InternalDataSet.Params edit window lists one entry:

0 - ClientID

FYI: eFetchClientID is TEdit field containing "20000" at the time of the error, a valid client ID for the database.

Any thoughts?

I'm new to Simple Data Sets; I though they were supposed to be easier :)

Ross Wise
WEAVE, Inc.
Sacramento, CA

PS: What would the syntax be to refer to the 'ClientID' parameter by it's index (0)? Is that possible? Would it help?

Bill Todd (TeamB) · Guest

My advice is do not use TSimpleDataSet. Use separate CDS, DSP and
SQLDataSet components.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)

Ross Wise · Guest

Bill,

That's the answer I expected. Smile

)

Thanks.

Bill Todd (TeamB) wrote: