Zeoslib Portal

Hi Michal,

Sorry for typing wrong:
ZQuery1.Close;
ZQuery1.SQL.add('select * from sys_user where user_id = :user_id');
ZQuery1.ParamByName('user_id').AsInteger := 1; //Paramrter 'user_id' not found
ZQuery1.Open;

Table name is 'sys_user'

Best Regards,

Hi, ZEOS 7.2.0-beta on Delphi 2009 / Windows XP, PosgreSQL 8 It cause a problem, when i using this SQL ZQuery1.Close; ZQuery1.SQL.add('select * from sys_user = :user_id'); ZQuery1.ParamByName('user_id').AsInteger := 1; //Parameter 'user_id' not found ZQuery1.Open; No problem when using ZEOS 7.0.0-de...

Hello Jan, The table declaration is as below: CREATE TABLE public.mf_goods ( goods_id SERIAL, goods_code VARCHAR(40) DEFAULT ''::character varying, goods VARCHAR(50) DEFAULT ''::character varying, CONSTRAINT mf_goods_pkey PRIMARY KEY(goods_id) ) WITHOUT OIDS; I am using a dataset ZQuery1 which sql i...

Hello! Any solution of the following problems? http://zeoslib.sourceforge.net/viewtopic.php?t=2528 I am using Delphi 2009 with postgresql DB. I have got an error 'is not a valid date and time' when I try to filter a string like 'aaaa-bbbb-cccc' And the field is in varchar type in DB but not date typ...

I am using ZeosLib 7.1 + Delphi 2009 + DevExpress Component. I am trying to input some Traditional Chinese into the SQLite DB. However, some words such as '當歸' will become something else like 'vuxk' after saved. So I try to add a TZUpdatesSQL and write my own update SQL. I found that if I write the ...

Thanks for your reply! But I have face another problem now. I need to input some Traditional Chinese into the sqlite DB. For example '當歸', but it become 'vuxk' after saved. So I try to use a TZUpdateSQL object and write my own update sql. I found that if I write the update sql using param like: Upda...

I am using ZeosLib 7.1 + Delphi 2009. And have a sql statement like below: select round(amount / exchange_rate,2) as fieldA from tableA; but the return type of fieldA just like String, I have set the sub-total of that field on a grid, but the sub-total is empty. I have try to cast it as numeric, but...