Zeoslib Portal

That solution is no use unless the changes are incorporated into the source code, and I can download the fix. Question is when? Another question is has this issue been recorded in the official bugtracker for resolution so that someone can work on it?

Mark

Did you have a look at the test case?

Any idea when this can be solved? My product is suffering without release until this gets resolved.


Regards,
ND

Hi Nicola, 1. If this was previously working with Zeos 6.6.6, then it is a bug in Zeos 7. 2. You should not use "." character in field names, because it has special meaning in SQL Syntax ie it is used as a qualifier for aliases eg. SELECT A.ID, B.Address FROM Person A INNER JOIN Address B ...

Can you upload the source code?
I can have a look - my work environment is D2010 and Zeos 7.0
Only the DFM / PAS files and FDB database file. I already have all the relevant Firebird DLLs from the Zeos SVN trunk.

Thanks
ND

Mark Hope you can solve it :) There is no other component that comes close to Zeos in terms of user-friendliness and light-weight for me (eg. I tried to install FIBPlus but it is so complicated and behaves differently, similarly, I tried the DBExpress [D2010] Firebird driver, and the same thing - it...

mdaems - I have uploaded the source and database for a simple Delphi 2010 test project at this link: http://www.filehosting.org/file/details/165942/testproject.rar Note that I used the latest Zeos source from the Trunk of the SVN. Looking forward to your response and eagerly awaiting a fix soon :? R...

Hi, Using: Delphi 2010 Zeos 7 [ZEOSLIB_TRUNK_REV803] Firebird 2.1.3 embedded Problem: I upgraded my project to Delphi 2010/Zeos 7 (from Delphi 2007/Zeos 6.6.6 - it used to work perfect). Now I am getting this error for stored procedures (Insert, Update, Delete etc...) : Project teml.exe raised excep...

Are you trying to do it in code? What component are you using?

Using: Delphi 2007 Enterprise Zeos DBO 6.6.6 Stable Firbird 2.1 Have ZQuery with SQL property set to: SELECT ORDERID, ORDERNAME FROM ORDERS_LIST ( :ORDCMPSTATUS ); IndexFieldNames property set to: ORDERID Asc where ORDERS_LIST is a stored procedure in the database. ORDERID field is indexed in the so...

After right click on field collection editor in table component and select 'Add all fields', if there is a LargeInt field, it gets added as a String field.

Is this a bug in ZeosDBO that it is not reading the table structure properly?

>>With zeoslib no special updates queries should be necessary to insert/update/delete records from a table when you're using a TZTable component.

Yes. I overlooked that he mentioned TZTable.

-ND

>> q.delete;
will only delete the record from the dataset and not from the database. To delete from the database, you need to execute a SQL statement against the database to do the same. Either you can do this with Query component or with a Stored Proc component.

Read the PrimaryKey for each row from the DBGrid, and use it as a parameter to a stored procedure (TZStoredProc component) with a Delete SQL statement.

If the DBGrid is linked to a dataset (ideal situation), then you can read the primary key from the associated column in the dataset.

Do as described above, and watch the memory usage in Task Manager. Every time the code is called (it is in a procedure that is called by a Timer event every 5 seconds), the memory increases between 20K and 200K (random).

Hi, Using: D2007E, Zeos DBO 6.6.4, Firebird 2.1.1 (embedded). After running code that calls an Insert stored proc, my application memory usage increases between 8K to 30K (different each time). This is not acceptable, as the application runs through the night, and by morning, all Windows memory is u...