Search found 8 matches

by woolfik
10.06.2011, 23:48
Forum: 6.6 - stable
Topic: Unsupported operation
Replies: 2
Views: 857

And what about PostgreSQL it is the same problem.
by woolfik
08.04.2010, 08:03
Forum: 6.6 - stable
Topic: [Firebird 2.1] Codepage problem
Replies: 1
Views: 466

[Firebird 2.1] Codepage problem

Hello I have database on Firebird 2.1 with UTF8 encoding. Yesterday I use zeos to connect and I have problem with encoding. When I put codepage=UTF8 to TZConnection properties my polish chars like "żąśźćęóńł" disappear and I have strange difrent chars. When I use codepage=WIN1250 polish ch...
by woolfik
25.01.2010, 10:06
Forum: 6.6 - stable
Topic: How to check new records on refresh method
Replies: 1
Views: 370

How to check new records on refresh method

Hello I have a database on PostgreSQL and my main application (serwer) reads some information from a remote location and save new records to one of the tables. The secont application (client) works on many diffrent computers and reads only this table from our database. In my application is a query, ...
by woolfik
02.10.2009, 07:58
Forum: ZeosLib 7.0 Beta Forum
Topic: Unknow symbol "." in filter
Replies: 4
Views: 581

Mark thank you very much when I set alias on aktywny as akt and filtering on akt = true it is working ok. Beer for you :)
by woolfik
01.10.2009, 10:16
Forum: ZeosLib 7.0 Beta Forum
Topic: Unknow symbol "." in filter
Replies: 4
Views: 581

Unknow symbol "." in filter

Hello I have next error I have an sql query like this: SELECT DISTINCT us.idx_osoby, us.imie, us.nazwisko, us.login, dz.nazwa as "nazwa_dzialu", bl.blokada, bl.idx_device, ur.nazwa, ds.idx_strefy1, ds.idx_strefy2, ds.idx_strefy3 FROM public.users as us LEFT JOIN public.dzialy as dz on us.i...
by woolfik
25.09.2009, 14:41
Forum: ZeosLib 7.0 Beta Forum
Topic: Is not a valid date time format on filter
Replies: 3
Views: 820

Ok I have looking for this error in code and it's look like this When it goes to: unit ZExprParser; procedure TZExpressionParser.TokenizeExpression; in case function in case TZTokenType({$IFDEF FPC}Pointer({$ENDIF} Tokens.Objects[TokenIndex]{$IFDEF FPC}){$ENDIF}) of it goes to: ttTime,ttDate,ttDateT...
by woolfik
25.09.2009, 09:38
Forum: ZeosLib 7.0 Beta Forum
Topic: Is not a valid date time format on filter
Replies: 3
Views: 820

Is not a valid date time format on filter

Hello I'm using zeos on d2010 and when I'm filtering records from db (postgresql) like qrUser.Filter := 'surname = '+#39+ edit.text+#39; // if Surname is Smith is OK // if surname is smith-webber is OK and I have found in db surrname looks like: smith - - webber and when I would like filter my recor...
by woolfik
08.07.2009, 11:21
Forum: ZeosLib 7.0 Beta Forum
Topic: Zeos 7 Alpha and Delphi 2009 Support - Official Thread
Replies: 97
Views: 29223

Hi all I'm working on Delphi 2009 few month's ago I was using Delphi 2007 and in my aplication I have working with postgresql 8.3. In delphi 2007 when I want same code in database and aplication in "properties" on ZConnection I have writing some thing like that: codepage=WIN1250 In delphi ...