Zeoslib Portal

Ok,

I've done some more investigation it turns out that setting the .asstring is quoting correctly, my errors where being caused by an un-quoted quote in a select statement.

So I've added a call to EncodeCString() around the passed in string.

Cheers.

Phill.

Hi, In my app I have found that if I have a TDBEdit, that is linked to a field in a mysql table (via a TZQuery, and TZconnection). If I type a string with a single quote in it such as "test'test" the field is correctly posted to the database (and the quote is escaped on the way, checked wi...

Ok, I have got it working using the second version, the exception was being caused by my logging code which was being called from an TZSQLMonitor.

Cheers.

Phill.

Trying another way of doing the update : PROCEDURE TChemDataModule.SaveDatasheet(InChemicalIDNo : Cardinal; Datasheet : TStream; FileName : STRING); VAR Blob : TStream; BEGIN; WITH ZDatasheetQuery DO BEGIN; Active:=FALSE; SQL.Text:=Format('replace into %s values(:%s,:%s,:%s)', [DbTableChemDatasheet....

Hi, I'm trying to update a Blob field in one of my tables from a small word doc file that is stored in a TStream. I'm using Delphi 7, Zeos 6.6.5, and MySQL 5.0.x My update code is as follows : PROCEDURE TChemDataModule.SaveDatasheet(InChemicalIDNo : Cardinal; Datasheet : TStream; FileName : STRING);...

Ok, so I'm trying to write a simple game launcher and using sqllite as the backend. I have a form where I can edit the game configurations that has the following components all linked to the same DataSource, which is liked to a ZQuery and then to a ZConnection to the database. The components I have ...

Hi, Using Delphi 7, Zeos 6.6.0. I have a database table in MySQL 5.0.26 (linux) that has the following fields defined : iselectrical enum('Y','N') Interest enum('Y','N','U') When I try and uses FieldByName('iselectrical').AsString it always returns 'true' or 'false', whereas if i use FieldByName('In...

mdaems wrote:select column_comment from information_schema.columns where ...;

Cheers that seems to do what I need

Phill.

Is there a way of retrieving the column comments from a MySQL 5 database ?

Cheers.

Phill.

In the first posting you said "The code crashes when executing the Open statement." But now it's OK, after you put the cange code that I told? I have indeed put in your changes, but am not sure if this fixed it, cirtainly I was still getting the crash after the patches where applied, whic...

Tried that, which alas did not seem to work :( Further investigation has revealed that the open is infact working, however it was triggering the onclick event of a TDBCheck box, which was attempting to modify one of the other fields and failing. The things is the Database *SHOULD* be open in read/wr...

Hi, Using Zeos 6.6.1beta under Delphi 7, my database is a MySQL 5.x on a SuSE Linux server. The problem is the following code crashes with a EDatabaseError : "ZEditQuery: dataset is not in edit or insert mode". This only happens about 50% of the time, the other 50% it seems to be fine. WIT...