Zeoslib Portal

Jan, In this case rows number is varied, based on parameters that user supplies... Anyway i've used TZUpdateSQL but in selective way: i suppky only RefreshSQL to it, and attach it to ZQuery in ZQuery->AfterPost. Then i locate each ID i neet to refresh, and call ZQuery->RefreshCurrentRow(false). Afte...

Jan, I've got editable grid with a lot rows - 30k+ After editing one row Postgresql trigger changes data on other rows (5 to 10 rows). Application is then notified of changed rows id's. I need to fetch data for these rows from DB. Edit() ... Post() method is sending data to DB again, and i want to a...

Hi,

Is there a way to fetch only one row from database?
I tried RefreshCurrentRow - with error quoted by Fr0sT.
I would like to avid Edit...Post dataset update method since this post data back to DB and i need to avoid this.

Best regards,
Marek

konsul,

You use :: as cast operator - that works fine in psql or pgadmin, but
zeos uses : as param character by default - so after parsing Your query there are weird results.
You should either change param char in ZQuery object you use, or use cast() function from postgres.

Best regards,
Marek

Michal,

But apparently this directive works fine with Delphi.
Although Hereibi recent problem looks very similar...

Best regards,
Marek

Hi All, I've decided to try Zeos with new CBuilder XE8. I've used rev 3628 and zeos.inc that Michal posted for Delphi XE8. At first i had some hassle with paths: C++ compiler and delphi compiler paths are now separate parameters. After succesfull compilation of all packages and installation of compo...

Hi, Maybe it is a better idea to first save the bookamrks to an array or something Grid.SelectedRows is already type TBookmarkList. I suggest using another variable of type TBookmark: TBookmark selRow = dbgprod.SelectedRows.Items[Idx]; qryprod.GotoBookmark(selRow); btw: you should also think about u...

Michael,

i don't feel ignored - don't worry:)
I assumed that you don't have time for my everlasting list of requests and questions. I also assumed that since i didn't prepared a testcase in Pascal - you'll not attend my issue.

Best regards,
Marek

Michael, I don't have testcase for you yet, but... I've played a little more with my report query of select case when coalesce(:date_grp,false) = true then date_field else null end as date_field, sum(int_field) as int_field, sum(real_field) as real_field from test_tab group by case when coalesce(:da...

Thats why the STMT is prepared and cached too. One of the performance goals. Simply close the DataSets which accessing the changed table. After your changes are done, the Cache is cleared :? you can reopen them again. We do NOT cache the Stmts it's selves in a list or so (for updates i'm doing this...

Hi all, i've found some time to check some more. Error about changing result set occurs when Query is using real prepared statements. When i added EMULATE_PREPARES=true grid edit on temp tables works, but with clearing cache after each structure change. It seems that after structure change prepared ...

Michael, i've checked with param You suggested - and it works:) Now i got a question: is there a way that i can determine if query will work with CAPI prepared statements - so i can turn on 'EMULATE_PREPARES only for them? I mean without executing query and catching exception ;) I don't fully unders...

Michael, Patch tested - works fine:) Thanks a lot I've also tested patch for issue from http://sourceforge.net/p/zeoslib/tickets/57/ , didn't had time to check it earlier, and now ticket is closed. But when i execute command: ZConnection1->ExecuteDirect("alter table temp_test add column \"...

Parameter will be good - yes:)
I was also thinking about conditional define in ZDbcPostgreSqlMetadata.pas to enable
SQL := SQL + ' AND pg_table_is_visible (c.oid) ';

Hi, I will start with test case: create table test_tab{ date_field date, int_field integer, real_field numeric(18,6) WITH ( OIDS=FALSE ); fill data in any way - it doesn't matter too much now in application execute query like this: select case when coalesce(:date_grp,false) = true then date_field el...