Search found 3 matches
Friends, let me explain the situation: I have a zquery2 (users) where I search the user name typed in the edit. Finding the name, the value of usuario_id have to be the parameter for searching the zquery1 (budgets). In BDE and other database engines this strategy works perfectly but with Mysql and Z...
Yes, I've done that but the query returns empty, does not filter properly. The problem is that SQL interprets as a string field in the table and asks to turn the variable into string but returns an empty result. I've used the TrimRight to eliminate empty spaces but still resulting empty. With BDE do...
Sql error
Good afternoon, I am using Delphi 7 with zquery and I have a problem when I build a SQL statement to filter the data. usuario_id the field is integer but when I compare with the field in another table with the same structure, sql says that the types are incompatible: string and integer. See figure. ...