Zeoslib Portal

Why does "LIMIT 1" at the end of the upper statement (with corrected table name part) cause the same error? The statement you have listed is an UPDATE SQL statement and executed with .EXECSQL (which does not return a result set). "Limit" is only relevant for SELECT statements, t...

One more question:

Why does "LIMIT 1" at the end of the upper statement (with corrected table name part) cause the same error?

Oooooouuuuuuhhh. Now it works. Thank you.

But why is tablename not allowed to set by a parameter?

Hello I use Zeos 7.1.2 with Delphi XE2 for reach my SQLite 3 database. I attach the database. I use the following code on a ZQuery to update an exist table: ZQexec.SQL.Text:='UPDATE :tabla SET zarol=:zarolset WHERE zarol=:zarolwhere AND id=:id'; ZQexec.ParamByName('tabla') .AsString := tabla; ZQexec...

BPL? Why? You should do this: 1. Tools -> Options -> Environment Options -> Delphi Options - Library -> Library Path: to the end: ;D:\Windows\Delphi\ZeosDBO This is where you unzipped Zeos 2. File -> Open ZeosDbo.groupproj 3. Right click -> Compile, in this order: ZCore.dpk ZParseSQL.dpk ZPlain.dpk ...

Hello Jan

I followed this: http://dev.mysql.com/doc/refman/5.6/en/ ... tions.html and now it WOOOOOOOOOORKS!



Robi

Yes, that was the solution, but... You understand

Thanks, i have found them. How/Where can i get these datas?

Hi

I would like to have SSL connection with MySQL 5.6. I use Zeos 7.1.2-stable in Delphi XE2 U3.

I put "MYSQL_SSL=TRUE" in the properties of the connection, but it still connect without SSL.

How can i do SSL?

Hi Is it possible to ease the restriction of the search function here? I tried to search for SSL and MYSQL_SSL words, but it replaced _ to space, then said they are too common words, and at least 5 characters are expected. Some days age i run into the same problem, and i was not be able to find what...

OK, the $(BDSCOMMONDIR)\Dcp directory was not in the Library. I do not know why.

Hi I tried to install ZeosDBO 7.1.2-stable in Delphi XE2, and at ZParseSQL160's compile i get this: [DCC Fatal Error] ZCore.dpk(1): E2225 Never-build package 'ZCore' must be recompiled [DCC Fatal Error] ZPlain.dpk(33): E2202 Required package 'ZCore' not found Of course i compiled ZCore before ZParse...

Thank you, i will look for it in the Delphi's code.

I did not try it. I find what was the problem. In the old version, i just assign the picture data to the param, and it automaticly add escape chacters where it need. Now, it works if i convert the whole picture to hexadecimal character-pairs, and then assign it to the param or just simple set its va...

Or anyway, how could i save a picture to db?