Zeoslib Portal

OK - don't worry. I loaded REV Testing 725 and that seems to work OK.
Thanks - Kerin

Thanks Seawolf. In the light of your comments, I thought I would start again from scratch. I deleted everything related to Zeos, and downloaded Trunk Rev 726. I cannot find any documentation on how to install it to D2010 on WinXP, so I loaded I:\Zeos\packages\delphi14\ZeosDbo.groupproj and tried to ...

I'm using Zeoslib 7.0.0 dev. with Delphi 2010. on WinXP. I was happily compiling and running my program OK, when I clicked on Build Project instead of compile. I then got the error "Unit ZAbstractRODDataset compiled with a different version of ZExpression.IZExpression" and it won't go away...

Thanks seawolf, and sorry for the delay in responding. There was actually a ; in the last END (typo) I tried putting in the SET TERM lines, but I got an error Unknown token - line 1 column 5 TERM, error code -104 Seems to work better without them. I checked with Firebird Maestro, and the procedure i...

Thank you very much seawolf. Very helpful. I am now creating a stored procedure as follows:- with ZQuery1 do begin SQL.Text := 'CREATE PROCEDURE MY_REFRESH'; SQL.Add('AS BEGIN'); SQL.Add('POST_EVENT ''my_event'';'); SQL.Add('END'); ExecSQL; end; I then drop a StoredProc component on the form, set th...

Hi, Using Delphi 5, Firebird 2.1, and ZEOSLib 6.6.5 I've been trying to use POST_EVENT, which I thought would be straightforward - so I tried ZQuery1.SQL.Text := 'POST_EVENT ''my_event'''; ZQuery1.ExecSQL; I get the Dynamic SQL error message, invalid token line 1 column 1. This is saying the POST_EV...

Thanks very much for the tip. I had already deleted the Borland folder, but I then looked in the registry and found lots of references to Delphi5 which I removed, and I can now compile OK :D One curious thing is that I had to add a path to the $(BDSCOMMONDIR)\Bpl folder, because the compiled dcu fil...

Hi, I've just upgraded from Delphi 5 to Delphi 2010 (on WinXP), and have downloaded the zeos 713 snapshot, which am trying to compile. I can compile the ZCore.dpk and ZPlain.dpk OK, but the ZParsSQL and ZDBC both give errors:- Undeclared identifier "ttTime", "ttDate" and "tt...

Thanks Mark - that is better.

I have found the answer.
I have to use the local path name on the remote PC instead of the remote name i.e. C:\roes\ljm.fdb.
Thanks for looking
Kerin

Hi, I've been trying for a week now to access a Firebird DB over a LAN without any success. I'm running Delphi5 Pro and Zeos 6.6.5. Once PC is running XP and the other WIN2000. I have established that the 2 PC's can ping each other, and that port 3050 is not blocked. Both PC's are running Firebird 2...

Thank you for the advice. I will implement your trigger idea.

Thanks for clarifying FK vs PK for me.

Does this mean there is no way to implement referential integrity between the two tables?

Kerin

Thanks Mark, I am currently querying the RDB$REF_CONSTRAINTS table for the RDB$CONSTRAINT_NAME tosee if it exists. I just thought there might be a more elegant way to do it in one SQL statement (using IF EXISTS or something). Anyway, what I have seems to work, although it's not ideal. I haven't used...

Me again, I have a table of items (ITM), and each item has a price code e.g. PK...Item.....Price_Code 1.....IT2.......PC1 2.....IT32.....PC3 3.....IT9.......PC1 The price codes are held in another table (PCD), but the price per item can vary depending on the quantity e.g. PK....Price_Code.....Qnty.....