Search found 4 matches

by tvvwild
05.06.2015, 08:33
Forum: ZeosLib 7.2 Forum
Topic: Bag or not with Params TZquery
Replies: 0
Views: 1327

Bag or not with Params TZquery

I'm use only 1 TZquery component for many queries. Database PostgreSql like select * from public.p_test1(:id, :b, :c) :id is integer param :b, :c other params no matter what types then other query select * from public.p_test2(:id, :d, :e) :id is integer[] param (array) :d, :e other params no matter ...
by tvvwild
13.08.2012, 11:11
Forum: ZeosLib 7.0 Beta Forum
Topic: Query Bug with stored function and table
Replies: 5
Views: 2231

I think that fix this bug fully but not. This patch doesn't fix follow select p.* from p_test() p join test_table t on p.b = t.a so add second fix in "function TZAbstractResultSetMetadata.ReadColumnByName(FieldName: string; TableRef: TZTableRef; ColumnInfo: TZColumnInfo): Boolean;" before ...
by tvvwild
13.08.2012, 04:34
Forum: ZeosLib 7.0 Beta Forum
Topic: Query Bug with stored function and table
Replies: 5
Views: 2231

here.
I install from "svn://zeos.firmos.at/zeos/trunk" and "Zeos.inc" have rows

Code: Select all

//PATCH TO DO NO METADATALOADING / UNTESTED HIGH RISK
{.$DEFINE FOSNOMETA}
by tvvwild
12.08.2012, 19:54
Forum: ZeosLib 7.0 Beta Forum
Topic: Query Bug with stored function and table
Replies: 5
Views: 2231

Query Bug with stored function and table

Hi! I work with Potgresql. Any heavy queries I build with stored functions. And what I found. Some times If I join function with table(view), some fields have the wrong datatype. Like this CREATE OR REPLACE FUNCTION p_test () RETURNS TABLES( A bigint, B integer ) $body$ DECLARE ... BEGIN ... return;...