Activity for Ralph Staudte
-
Ralph Staudte modified a comment on ticket #510
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...
-
Hi Jan, similar problem here: I am one of the forums "old" users and I can't log in with my "old" credentials... Is there any way to reenable my login? My username was/is "ralph". Best regards Ralph
-
Rev 7490: Error on editing database entry (PostgreSQL)
-
Rev 7490: Error on editing database entry (PostgreSQL)
1
