Zeoslib Portal

Gentlefolk,

Yes, the svn version of zeos now installs correctly into the lazarus ide.

Old version of zeos removed from C:.

Ian.

Gentlefolk, Uninstalled lazarus, removed any directory or file with 'laz' in its name from the entire C: drive. Installed laz 0.9.30.4, installed the zeos package from 'egonhugeist'. The zeos package install concluded with NO error, new version of laz built and reloaded. Compiled a sample one form p...

Gentlefolk, There is a problem somewhere in the environment, the IDE or package processing. I had two copies of ZEOS, one in C:\SW\ZEOS (the download version) and the other in C:\SW\ZEOSSVN (the egonhugeist version). In the package install process I would select C:\SW\ZEOSSVN\.......lpk The zclass f...

Thanks for the response. I should have stated earlier the environment is WinXP SP-3. However: I could find nothing like C:\Users\S\AppData\Local\lazarus folder, I presume it is really something like %localappdata%\lazarus/ I have "uninstalled" lazarus and deleted all other "lazarus&qu...

Gentlefolk, Attempted to add the Zeos package to Lazarus 9.30.4. The add zcomponent.lpk>install crashes in module ZClass at line 84 as follows: Line 84: TContainedObject = class(TAggregatedObject, IInterface) protected function QueryInterface(const IID: TGUID; out Obj): HResult; virtual; stdcall; en...

Things are looking better.... I have the following code: LocalQuery.UpdateObject.DeleteSQL.Clear; LocalQuery.UpdateObject.DeleteSQL.Add(HeatSQL); LocalQuery.Delete; LocalQuery.Edit; LocalQuery.Post; LocalQuery.ApplyUpdates; The .Delete, .Edit and .Post update the ZQuery Dataset. The .Delete deletes ...

I have changed TIntegerField to TStringField in Unit1.dfm.

Can now see the form in the ide. Will not compile.

I think I have enough info from looking at the .pas and .dfm files.

Will update my code and see what happens.

Thanks once again, Ian.

Thanks once again,

I have had a look at the .pas and .lfm and can see what you have done.
Most helpful.

Can not compile because of an error in the ide on the TIntegerField.

Known problem in Bugtrack but it looks like I will have to move to a later version of laz 0.9.30.

Groan........

Thanks, Ian.

Thank you for the respones, As far as I can determine the DeleteSQL SQL is not executed. I am trying to find where it is processed in ZEOS but I am not having much luck with that. The "HEATSQL"/DeleteSQL is certainly different from the ModifySQL(UpdateSQL). The data structure id DBGrid-Dat...

Gentlefolk, Struggling with this. In the example given in the earlier sections of this discussion I can understand Setting the UpdateSQL := 'Update Table Set......' Setting some fields to Fields[0].Value := Null; And then performing a Post and a Close. The Post-Close code can look at the data in the...

Thank you for the response. Yes, that is correct, with a bad/corrupt SQL statement no error messages/exceptions occur. Code is as follows (SQL is good): try HeatSQL := 'Delete from VENUE_RESULTS where ' + '((SeasonYear = ' + UnitData.UD.GetCurrent.CurrentSeason + ') and ' + '(ROUND = ' + UnitData.UD...

Gentlefolk, Using Lazarus 0.9.30, ZEOS 7.0, FB 2.15, WinXP-SP-2. I am having a problem using the DeleteSQL in a TZQuery-TZUpdateSQL structure. My code follows the code illustrated at the start of this discussion but nothing is deleted from the database. Using the SQL monitor I can see a StartTransac...

Gentlefolk, I have done some work looking at he data loaded/modified on one copy of the program, checked the database, checked what I see in a second copy of the program. Looks good, cannot see changes while a TX is open in the first copy of the program accessible in the second copy of the program. ...

Gentlefolk, Put some log code in Zonnection.StartTransaction/Commit. Executed all parts of the program slowly, while looking at Sinatica transaction display, found some code that did not commit the TX. Fixed that and did some more work with Sinatica, see lots of SQL statements which all look OK. I a...

Gentlefolk, Woops, error in previous post. Item 2 is incorrect, the following code is executed if FTrHandle <> nil then begin if FHardCommit then begin FPlainDriver.isc_commit_transaction(@FStatusVector, @FTrHandle); FTrHandle := nil; end else FPlainDriver.isc_commit_retaining(@FStatusVector, @FTrHa...