[SOLVED] Zeos SQL querry problem

[samto]

Hi all,

I am a newbie in using Zeos components.  I need to make a simple database filtering, using sql querries.

Here is a sample syntax:

ZQuery1.SQL.Clear;
ZQuery1.SQL.Text := Edit1.text;
ZQuery1.Open;

I tried also ZQuery1.ExecSQL procedure but without success ... and without error message. Simply - it does nothing.  There is probably some variable not corectly setted, but I dont know which one ... I tried many combinations.

Can you help me, or better, can you provide me some simple example?

Thanks for a help and have a nice day.

[IndianaJones]

Here is a simple filtering mechanism, change <database field> to your database field that you want to be filtered.
Regards.

Code: [Select]

      filter_title:=Edit1.Text;
      ZTable1.DisableControls;
      ZTable1.Filtered:=False;
      ZTable1.Filter:='<database field> LIKE '+QuotedStr('*'+filter_title+'*');
      ZTable1.Filtered:=True;
      ZTable1.EnableControls;


[goodname]

Be careful about using QuotedStr to escape SQL strings. If the string contains \' and the database engine uses backslash escape the string passed will be \'' and will fail.

'a single quote \' in a string' ---> 'a single quote \'' in a string'
DB engine will escape to  'a single quote ' in a string'   which is a parsing error.

MSSQL does not recognize backslash quoting and it can be turned off in PostgreSQL. AFAIK all other DB engines use backslash escaping.

[IndianaJones]

Single punctuation or double matter, as @godname says, but mostly you can try it yourself.
@Thanks goodname for additional information.
Regards.

[samto]

Thank you for your help, it works well (unfortunatelly very slow, but it is another problem)

[taazz]

AFAIK all other DB engines use backslash escaping.

Does a double backslash cancel the escaping procedure on those that do?

[goodname]

AFAIK all other DB engines use backslash escaping.

Does a double backslash cancel the escaping procedure on those that do?

I don't know. The best option here is to just try various string escape combinations to see what works and what throws errors.

[BigChimp]

Be careful about using QuotedStr to escape SQL strings. If the string contains \' and the database engine uses backslash escape the string passed will be \'' and will fail.

'a single quote \' in a string' ---> 'a single quote \'' in a string'
DB engine will escape to  'a single quote ' in a string'   which is a parsing error.

MSSQL does not recognize backslash quoting and it can be turned off in PostgreSQL. AFAIK all other DB engines use backslash escaping.

Trying to insert quotes by escaping with backslash fails on Firebird 2.5