request data by CommandText with Param

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Emmanuel Sun, 11 Mar 2001 17:05

#571

Author: Emmanuel
Date: Sun, 11 Mar 2001 17:05

24 lines
1427 bytes

I have try to request data by CommandText
"Select * from table1 where field1=:field1"
If there are some param
ClientDataSet->Close();
ClientDataSet->CommandText="Select * from table1 where field1=:field1"
ClientDataSet->Params->ParamByName("field1")->AsString="123";
ClientDataSet->Open();
there should be some data, but I find that the result is empty
If I write param directly to CommandText
"Select * from table1 where field1='ABC' "
there will be no problem

Please Help.

--
Emmanuel Li


---------------------------
ERP System Consultant
URL: http://www.erphk.com
E-mail: emmanuel@erphk.com
Tel: 2191 6116
Fax: 2191 6774

Re: request data by CommandText with Param

#573

Author: Emmanuel
Date: Tue, 13 Mar 2001 09:17

3 lines
930 bytes

Help me
please tell me any setting which I possible forget to set
Thank you

Re: request data by CommandText with Param

#581

Author: Emmanuel
Date: Sun, 18 Mar 2001 15:58

1 lines
847 bytes

Can any body help me?

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads