Zeoslib Portal

PS: Here the SQL code for the created table. The blobfield is from type "bytea" an there are PNG or JPG images saved with maximum size from 64KB. CREATE TABLE foto ( id serial NOT NULL, id_id integer, bezeichnung character varying(100), tabelle character varying(30), bildtyp character vary...

Hello Michael, I have install your "testing-egonhugeist" and there comes this message: 16:58:14 Error: Cannot open database! Out of memory (DB-Connect) And I cannot open a table. Yes, all is OK. I have think, I test the new V7 with my EXE and Lazarus. I need the SQLite, MySQL and PostgreSQ...

Hello, I have no Install the newest PostgreSQL Server "postgresql-9.1.3-1-windows.exe" and install Lazarus "Lazarus-1.1-36568-fpc-2.6.0-20120405-win32.exe" and the Zeos Trunc from today. I can create a new Database, the tables and import the data into the new database. All rows w...

Hello Egon, I have look into the databytes and analyse the difference betreen the versions 6.6.6 and 7. In 6.6.6 was a $00 a '%0' and a '%' a '%%'. It is looking simple. With this routine can I correct my table and do an update: q.SQL.Text := 'SELECT * FROM foto'; // TZQuery q.Open; st := TMemoryStr...

No, I want not use Parameter Queries. I want use a Query with DataSource and a Grid. Then edit / write my texts into the grid and post the changes. (One code line TZQuery.Post;) I have set the Properties "codepage=UTF8" in TZConnection and TZQuery, but it do not work, have no result. Yes, ...

I have store in a Blob Field photos as PNG and JPG format and they are showing in my EXE, it works fine. (Lazarus, Zeos 6.6.6, Win & Linux) Now, I want update the Component to Zeos V7.0 and this data are stored now in a other format, this make the Zeos component. How can I use the old Data? Or W...

Ja, ich bin ein deutscher und mein englisch ist eher denglisch. Yes, sorry. No extra parameter for MySQL. Use a new TZConnection and set this parameters. Then a TZQuery with "SELECT * FROM <your_table>". No extra Execute, no extra parameters and properties in TZConnection and TZQuery. The ...

With phpMyAdmin, create an new database with kollation "utf8_unicode_ci" and then make your tables.

In Delphi:
Use my demo, last posting, and set User, Passwort, Port=3306, Database, Host.
Set the protocol to"mysql-5".

Finish.

Hello, I have load the last SVN 966 and I want use SQLite. But the problem, the database store the chinese characters not. I use Delphi XE, in the Label can I see a text whith chinese characters. When I edit a table and insert a chinese text and post it, then I see the chinese text, too. But when I ...

I use the same FPC Version and it works good.

In attachmet is my complete src folder, then you can see my changes from the file timestamp.

Best regards, Markus.

Thanks Markus.

Yes, I have include ist in V6.6.6. It works now fine. No incompatibilities.

Best Regards Markus.

Thank you very much!

I have add the same for VER2_6, too.

Hello,

I cannot compile ZEOS with FPC V2.7.1.

The Error:
...\ZeosDBO\src\component\ZAbstractRODataset.pas(3116,118) Error: Expected another 2 array elements

The Line:
{$IFDEF FPC2_1UP}, ftString, ftBlob{$ENDIF});

But I have count and I think it must work. Have anoter a idea?

regards Markus

Hello,

I want test V6.6.7, but I never found your "Snapshot-Server".
Can you post the Link, please?

Regards Markus.