Subject Re: TIB_Query Programatically Defined SQL with Strings
Author jrodenhi
Marco,
Thanks for your reply. I am actually encouraged that this seems like
strange behavior to you too. I was afraid that I would not be able
to work in Delphi/Firebird in a similar manner to how I work in
VB/SQL Server here in my day job. But, it sounds like you also
think I should be able to use the same paradigm.

I will either get it to work tonight or I will present the actual
code so you can duplicate the problem tomorrow.

Thanks for your help.
-Jack

--- In IBObjects@yahoogroups.com, "Marco Menardi" <mmenaz@l...> wrote:
> No ideas :(
> - Are you using a (very) recent IBO version?
> - Do you have the correct gds32.dll or the firebird correct dll?
> - what happens if you use: SET MyField = ''ABC'' (no coma or other
> punctuation in the string)?
> - what about stripping spaces around "="?
> - what happens if you use IB_SQL program to execute the SQL
statement?
> Seems strange that the IBO parser gets confused by a so simple
> statement...
> regards
> Marco Menardi