Zeoslib Portal

thanks mdaems,

i solved it in other way.. with alias. "city_name" for the second "tb_city" query.

Hi, I'm working on a small project but i have problems querying multiple tables. Here are my tables: Tb_clients - client_id - client_name - client_phone - id_city_born(tb_city) - id_city_died(tb_city) tb_city - city_id - city_name - id_country(tb_country) tb_country - country_id - country_name Now i...

Hi, How can i insert pictures in database (Firebird 2.1.3) blob fields? The field in my db are: id_test(Bigint) name_test(Varchar) img_test(Blob, 80, Binary) I can insert the picture but i want to do at once:(id_test is a autoincrement field) 'name_test' and the 'img_test'. For the picture: with ZQu...

thanks to both of you

Hi, I wan to make a select query with more than 255 characters but i get error. Error: Constant strings can't be longer than 255 chars How can solve this? I'm running Windows 7 Ultimate 32-bit, Lazarus 0.9.30, FPC 2.4.4, Zeoslib 6.6.6, Firebird 2.1.3. Here is a part from my code: frmsetting.qryList....

Hi I use Lazarus 0.9.28.2 beta, Zeos lib 6.6.6 and Firebird 2.1 but unfortunately I have a big problem adding fields to TZquery. Open the field editor > Add Field > Select the fields (parts_name, parts_quant and parts_description) but unfortunately I can add only 2 fields (parts_name and parts_descr...

Hi guys, I have problem installing Zeoslib-6.6.6 on lazarus 0.9.28.2 (in the past i had installed on XP but now on Windows 7 ultimate 32bits cannot). I had compiled the package in order: core, parsesql but the zplain doesn't compile. This are the errors: C:\lazarus\src\plain\ZPlainLoader.pas(174,46)...

I do not understand you, I was shown this early in the thread: silvioprog Posted: 18.05.2010, 16:48 (No subject) Double quote ("1") mark in integer field, this works? I uses ('1'). But no problems, serves as a lesson for me. 8) For integer i haven't use any quotes only for varchar, like t...

guidoaerts, thank you very much!
That was the problem!
I use double quotes instead two single quotes!

Now all are working!

Copy fbclient.dll to your .exe dir, or system32 dir. To more samples: http://www.silvioprog.com.br/downloads/ZEOS_Demos_en.zip (to Lazarus, here in forum has to Delphi) I have this file in System32 directory and i've copy near the exe, but still the same still need fdclientd21.dll, fdclientd.dll fi...

Thanks for the answer!
i've change the field name but the same problem.

other thing what i do is to change the protocol 'firebirdd-21 Protocol' but doesn't work at all, the fdclientd21.dll and fdclientd.dll are missing.

why is working the select and other no?!

Hi guys, Today I’ve installed Zeos 6.6.6 component on Lazarus 0.9.28.2beta till this moment I’ve use SQLbd for Mysql but I want to learn Firebird. I have problems with queries: The select is working well: ZQuery1.Close; ZQuery1.SQL.Clear; ZQuery1.SQL.Add('Select NAME from test'); ZQuery1.Open; The i...