Zeoslib Portal

Excuse my forgetfulness: in fact 'status' is an index field.

Thank you so much EgonHugeist. Thanks for the explanation. In fact, I was given the same answer, although I was surprised me. Why not leave the 'where' clause as built ?. However, so is the implementation of Zeos and we have to accept it. As always, give me a clear answer! :D . Thank you once again....

Thank you very much for response Miab3, but I do not understand. Is correct that this query: 'select status from orders where no_orden = '2' '; that specifies a field n_orden into the where , when I run the post the update-query created by Zeos uses a WHERE changed? For me this is not correct! It sh...

Hi,
no one can assume something about this topic?

Hi, I have a TzQuery like this: Qry.Sql.Text: = ' select status from orders where no_orden ='' xxx'' '; By performing these steps: Qry.Edit; Qry.FieldByName ('status'). AsString: = '5'; Qry.Post; the query is executed on the MySQL database (activating the log) in this way: UPDATE orders SET STATUS =...

First of all, sorry for the delay but I had big problems to my work. The change is perfect and works perfectly. I've tried both to insert the parameter to the component in designing mode, both in the program as a code: ZConnName.Properties.Values['identifier_quotes'] := ''; All ok! Thanks for the us...

Ok good moving house.

Thanks

Thank you, it would be a wonderful change!

Mario

Probably was not provided the opportunity to indicate which string to use for the Quote. The only possibility that remains is to change the routine GetIdentifierQuoteString so: TZAdoDatabaseInfo.GetIdentifierQuoteString function: string; begin Result: = ''; end; Other databases accept a syntax witho...

Ciao, I'm writing a program that connects to a database Gupta SQLBase (Unify). I connect with Ado. When I use a TZtable, if I do a delete (tb1.delete) I get an error message: "[Unify] [ODBC Driver] [SQLBase] 00909 PRS INC Invalid character" Running the program in debug I found that the del...

Egon,
from Saturday to Sunday I tried the changes you made and is.... perfect!.
Thank you for your availability, really great!

I'm downloading now the sources from SVN/testing.
As soon as I can, do the tests.

See you soon.

Oh, thanks for the idea!.
It would be much better.
How should I do?

Thanks very much.
Mario.

Very well, it works. However, I think that I will continue to modify the source of the unit ZdbcGenericResolver because it is more easier for me. My projects have dozens of tables into "Data Modules" and forms and I should specify this properties for each dataset. Anyway, thanks for your a...

Hi EgonHugeist, thanks for the reply.
Unfortunately, I can not apply your advice.
As I enter the property ?
For example, if I have a TZtable tbOrders, how set the required property?:
I do not understand how to set it.
(tbOrders.properties....... )

Tnks in advance.