Ralph Staudte

Hi Michael, things are getting strange: I just found another UpdateSQL outside my DataModule. ****And this one works! Things that are different - the ones I found - are: - TDataSource, TZQuery and TZUpdateSQL are placed on a form (not a DataModule) - The TZQuery's Connection is in the DataModule - This Query does not have a "BeforePost" - There is no CURRENT_TIMESTAMP in the InsertSQL- or ModifySQL-lines Here is the part of the dfm: object dsBasiszins: TDataSource DataSet = qyBasiszins OnStateChange...

Hi Michael, things are getting strange: I just found another UpdateSQL outside my DataModule. ****And this one works! Things that are different - the ones I found - are: - TDataSource, TZQuery and TZUpdateSQL are placed on a form (not a DataModule) - The TZQuery's Connection is in the DataModule - This Query does not have a "BeforePost" Here is the part of the dfm: object dsBasiszins: TDataSource DataSet = qyBasiszins OnStateChange = dsBasiszinsStateChange Left = 192 Top = 8 end object qyBasiszins:...

Hi Michael, I left one UpdateSQL in the sources just for you ;-) You've checked the combination of TZTable and TZUpdateSQL - but in my case it's TZQuery with TZUpdateSQL. Just in case it matters... Here is the needed part of the dfm, I hope it helps: object dsKredite: TDataSource DataSet = qyKredite OnStateChange = dsKrediteStateChange Left = 672 Top = 59 end object qyKredite: TZQuery Connection = dbDataBase BeforePost = qyKrediteBeforePost UpdateObject = upKredite SQL.Strings = ( 'SELECT * FROM...

Please don't waste too much time with this bug. I am getting rid of all the UpdateSQLs since all I am doing with it can be done within QueryBeforePost - for example. And I am pretty sure that they will be gone completely by the end of this week. I was using UpdateSQLs since when I was starting to code my main-application back in 1999 / 2000. I probably didn't know better back then but now I actually think I don't need them anymore. Thanks so much for the work on Zeos!! Ralph

@egonhugeist: I just tried r7528 and the problem seems to be solved - at least according to 2 quick checks. Thank you very much for the very fast help!! Ralph

r7527: TZBooleanField returns 'True' all the time (PostgreSQL)

Hello Michael, yes of course... these crystal balls are hard to get! The user can edit data and eventually hits "Save". The new data is written to the database: dmDatabase.qyKunden.ApplyUpdates; dmDatabase.qyKunden.CommitUpdates; dmDatabase is a DataModule that holds pretty much all the DataSets, Queries and UpdateSQLs. For (almost) every Query there is an UpdateSQL with the SQL-Lines for "Delete", "Insert" and "Modify". An example for modifying would be: UPDATE kunden SET Suchname = :Suchname, Anrede...

Hello Michael, yes of course... these crystal balls are hard to get! The user can edit data and eventually hits "Save". The new data is written to the database: dmDatabase.qyKunden.ApplyUpdates; dmDatabase.qyKunden.CommitUpdates; dmDatabase is a DataModule that holds pretty much all the DataSets, Queries and UpdateSQLs. For (almost) every Query there is an UpdateSQL with the SQL-Lines for "Delete", "Insert" and "Modify". An example for inserting would be: UPDATE kunden SET Suchname = :Suchname, Anrede...