Zeoslib Portal

If I understand you correctly it means using something like SELECT CAST(DateColumn AS CHAR) FROM Table and than TZUpdate to save data to DB? This also means write conversion utilities to display date correctly with locale setting. So am currently thinking it is not better to save date as Int(8), bec...

I know about this SQL command. It is required for MySQL 5.7 and higher. SET sql_mode = ''; or SET GLOBAL sql_mode = ''; But the problem, I think, is in the conversion. It seems to me it does not know what to do with such dates, so it returns emty string when reading them from DB a produces conversio...

Hi, is there a way how to handle '0000-00-00' date in Zeos? I can not access is as string (empty '' string is shown). E convert error is raised when trying to save value. I understand that it is not proper date, but this allows for storing uncomplete dates 1920-10-00, 0000-05-18, etc. Thanks for help.

Finally got back to this. Thank you for help.
I used LAST_INSERT_ID directly in the script as variable.

Hi, I am trying to get last inserted ID. Is something like below supossed to work? const LastStatusID: string = 'last_status_id' begin ZSQLProcessor.Connection := Connection1; ZSQLProcessor.ParamChar := '@'; ZSQLProcessor.Script.Clear; ZSQLProcessor.Script.Add('START TRANSACTION;'); ZSQLProcessor.Sc...

Thank you for help.

Well, I have 3 tables: "Status", "Status_Subject" and "Subject". "Status_Subject" is just linking table betwean the other two. There is a grid, that shows Status + all Subjects assigned to status. So when I add subject, list needs to be refreshed, but because ...

Is there a way to force Query to keep selected record after refresh (based on primary key)?
Now it seems, that when any avalue is changed, first record is selected (I understand this must be the case when current record is deleted).

Thank You very much. I studied FPTest/DUnit2, writing my first test now :-)

Hi, I wrote SQL scripts to create and fill database and small Delphi application to show the problem. DB connection parametres must be filled in code before connecting. I found in the test cases that database "people" is used, but haven't found exact structure - I tried to ques as much as ...

Is there anything I can add to help solving this issue?

Thanks for help, problem solved now. Will watch the ticket to see, how it develops.

Dataset is set to:
UpdateMode=umUpdateChanged
I am also adding image, to be sure.

Hi, I am using MySQL 5.1.73 TZConnection.Protokol=mysql5 SVN: http://svn.code.sf.net/p/zeoslib/code-0/branches/7.2-patches Of couse that setting the same value is specific, but this means it also happens when using LookupComboBox (when user wants to see what values are available: he clicks the Combo...

Hi, I have quite complicated query that join multiple tables so for updating TZUpdateSQL is used. ModifySQL code: UPDATE Job SET ID = :ID, Owner = :Owner, ... WHERE ID = :Old_ID This works OK, but ONLY if the record really changes. When I modify some field but the value at the end remains the same e...