Search found 7 matches

by royyu
05.07.2016, 03:03
Forum: ZeosLib 7.2 Betatest Forum
Topic: Parameter Not Found
Replies: 10
Views: 574

Re: Parameter Not Found

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,
by royyu
04.07.2016, 05:41
Forum: ZeosLib 7.2 Betatest Forum
Topic: Parameter Not Found
Replies: 10
Views: 574

Parameter Not Found

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...
by royyu
14.06.2016, 08:58
Forum: ZeosLib 7.0 Stable Forum
Topic: Is not a valid date time format on filter
Replies: 3
Views: 817

Re: Is not a valid date time format on filter

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...
by royyu
13.06.2016, 07:51
Forum: ZeosLib 7.0 Stable Forum
Topic: Is not a valid date time format on filter
Replies: 3
Views: 817

Is not a valid date time format on filter

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...
by royyu
22.10.2014, 14:19
Forum: SQLite
Topic: TZUpdateSQL Param and Unicode
Replies: 1
Views: 803

TZUpdateSQL Param and Unicode

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 ...
by royyu
18.10.2014, 17:40
Forum: SQLite
Topic: Select field with calculation
Replies: 2
Views: 690

Re: Select field with calculation

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...
by royyu
17.10.2014, 16:35
Forum: SQLite
Topic: Select field with calculation
Replies: 2
Views: 690

Select field with calculation

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...

Go to advanced search