James,

You can use the parameter as you'd use it in any situation. Based on your statement, it would be something like this:

'... WHERE CUSTOMER LIKE :NAME'

After that, pass the parameter value like below (for Delphi):

IB_Query1.ParamByName('Name').AsString:= '%James%';

I hope I have helped you.

Hugo Bereta - Brazil

----- Original Message -----
From: James
To: IBObjects@yahoogroups.com
Sent: Friday, February 27, 2004 11:20 PM
Subject: [IBO] PARAMETER WITH '%*%'


Good day

Iam trying to contruct a sql statement in IB_query with a parameter
named "name" like this

... where customer like '%:name%'

unfortunately this doesn't work. Anybody has an idea about this one?

Thanks.



Regards,

James


___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !


Yahoo! Groups Sponsor
ADVERTISEMENT





------------------------------------------------------------------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/IBObjects/

b.. To unsubscribe from this group, send an email to:
IBObjects-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.




[Non-text portions of this message have been removed]