sql problem

[s_s_s]

Hi
Please help me implement the equivalent of the following command in Delphi

'select * from bimar WHERE bimar.fname LIKE '+ QuotedStr ('*') +'&'+ QuotedStr (Edit1.Text) +'&'+ QuotedStr ('*')

 

[mirtheil]

What have you tried?
What problem are you having?
What database are you using?

Your statement seems wrong. It generates something like:

select * from bimar WHERE bimar.fname LIKE ''*''&''VALUE''&''*''

where VALUE is the value in Edit1.Text.
Your SQL would probably be better like:

'select * from bimar WHERE bimar.fname LIKE ' + QuotedStr ('*' + Edit1.Text +'*');

which gives a statement like:

select * from bimar WHERE bimar.fname LIKE '*VALUE*'

That being said, your should probably use parameters. It protects better from SQL injection.


Mirtheil

http://www.mirtheil.com

 

[DjangMan]

I recommend using this IIADOQuery object from whosrdaddy. It was a game-changer for me with regards to working with ADO queries in my code.

http://www.tek-tips.com/viewthread.cfm?qid=1647984