Zeoslib Portal

Yes everything is normal, just Delphi 7 professional. When I add a normal TQuery or TTable it is fine, only when I put a ZEOS component it doesn't want to go... edit: i'm sorry, I have to revise :) I tried the TTable component and it gives me the same error :? So I will try to figure out what is wro...

Hello, I am using 6.6.3 stable on Delphi 7 pro. I have a host application that does not use any ZEOS components, but I attach a plugin to it, created by JvPlugin, so it is a BPL package. In there is a datamodule where I want to put some ZEOS components. If I add the TZConnection component, it will c...

I monitored the output with the Monitor component, and you are right, there was no index specified:
UPDATE table SET field = 'value';
No where clause included.

Thanks anyway!

I have a TZTable connected to a SQLite table, which I want to update. I do this with: Table.Edit; Table.FieldByName('Name').AsString := 'test'; Table.FieldByName('Address').AsString := Edit2.text; Table.Post; Should be ok right? Well if I refresh the table right after this, ALL the records have been...

Hello Bottleneck,

I know what you mean, and i wasnt talking about the Query component but the table component. Try to use that one and you will see its not that easy anymore...

Im trying to do it with the sequencer now. The refreshrow from the latest test release does not really work as it gives me a message its only to be used with updates :) It is not such a big deal as its the embedde firebird for only 1 user. The problem is not really getting the autoinc key, as I foun...

Ok if I refresh the table its all fine and working. Im didnt really look in the source of the Zeos lib, but Im confused how the Table handles the request for the insert then. Does it give a normal query out to firebird? If so it should give a result for the autoinc number, as a normal query with a T...

Have you tried to set MapsTable.FieldByName('ID').Required:=false? As it's a primary key we assume it is required by default as we can't know for sure a generator is used by examining the table structures, the way we can in mysql.(If autoincrement we can allow null values) Or do you know a way we c...

I use the latest Zeos with firebird 2.0, but I have trouble inserting data to my tables with autoinc columns. Ie I have this table: CREATE TABLE MAPS ( ID INTEGER NOT NULL, DESCRIPTION VARCHAR(255) CHARACTER SET UTF8 COLLATE UTF8); ALTER TABLE MAPS ADD PRIMARY KEY (ID); CREATE GENERATOR MAPS_ID_GEN ...

I am also bothering with this issue, but I cant get it to work either.. I keep getting the error: This application has failed to start because ZDbc100.bpl was not found. Re-installing the application may fix this problem. But I cant seem to find this package anywhere... Edit: Ok sorry me, I was too ...

With the new release of ZEOS, can I just use the TZStoredProc component? I use it like this and it looks really handy. StoredProc1.Active:=False; StoredProc1.StoredProcName:='test_proc'; StoredProc1.ParamByName('@param_id').AsInteger:=1; StoredProc1.ExecProc; StoredProc1.Active:=True; But i get the ...