Search found 107 matches

by louis
12.11.2015, 11:25
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

Re: D2010 + Firebird + Varchar doubles FieldSize?

@Louis Could you try(untested -> no time) to limit the String by limiting the DisplayWidth? The property DisplayWidth is intended for display on DBGrid/DBLookup. Not for editing/saving data. From Embarcadero Help: Description Specifies the number of characters that should be used to display a field...
by louis
07.11.2015, 17:28
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

Re: D2010 + Firebird + Varchar doubles FieldSize?

NOT A BUG!!! I wrote it serveral times in between. Please read http://www.unicode.org, study encodings and you will understand why Varchar(10) * 3or4Byte per Character(30 or 40Byte) = 20 WideChar Characters. Ok, but If I have a varcar(10) field in database and a TWideStringField of 20 characters, t...
by louis
06.11.2015, 16:51
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

Re: D2010 + Firebird + Varchar doubles FieldSize?

Please let me know about your findings. The problem happens even. Try this: a) Create a new Datamodule; b) put in a ZConnection and configure for a existing database with a table that contains a field of type Varchar; c) put in a ZTable and point the table at point b); d) Right Click on ZTable and ...
by louis
04.11.2015, 17:54
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

Re: D2010 + Firebird + Varchar doubles FieldSize?

marsupilami wrote:I will have a look at this later on and keep you informed.
Ok, thanks
by louis
02.11.2015, 11:43
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

Re: D2010 + Firebird + Varchar doubles FieldSize?

marsupilami wrote:which Version of Zeos do you use?
I use version 7.1.4-stable because version 7.2 is in beta.

Thanks.
by louis
31.10.2015, 18:47
Forum: ZeosLib 7.2 Forum
Topic: D2010 + Firebird + Varchar doubles FieldSize?
Replies: 17
Views: 11964

D2010 + Firebird + Varchar doubles FieldSize?

Hallo, I initiated a new project with D2010 and Firebird. I notice that D2010 doubles the size of TWideString Field if the Firebird column is VarChar. I have a column of VarChar(20) but a TWideStringField with a Size = 40! This cause problems because DBEdit permit a 40 character entry but the databa...
by louis
29.01.2015, 15:18
Forum: 6.6 - stable
Topic: Statements in TSQLProcessor seems not work
Replies: 0
Views: 1791

Statements in TSQLProcessor seems not work

Hello, I need to change a Primary Key by adding a new Field in a table. Unfortunatelly when I created the table I forget to set a name for the primary key :oops: Now I need to drop the primary key to recreate it with more fields but I don't know the name of the primary key, and the statement ALTER T...
by louis
26.02.2014, 18:44
Forum: ZeosLib 7.1 stable Forum
Topic: Where I put firebird.msg when i have two clients
Replies: 4
Views: 1089

Re: Where I put firebird.msg when i have two clients

that seems odd to me because usually windows searches for libraries in the application folder, where the exe resides first. Did you rename fbclient21.dll to fbclient.dll in the application directory? Even if I have a fbclient.dll in application folder, firebird.msg doesn't automatically found :( I ...
by louis
24.02.2014, 17:33
Forum: ZeosLib 7.1 stable Forum
Topic: Where I put firebird.msg when i have two clients
Replies: 4
Views: 1089

Re: Where I put firebird.msg when i have two clients

you could try to put the fbclient21.dll and the corresponding files into the application directory of the application that uses this client. Not works, because in the search path (Windows\system32 there is fbclient.dll for 2.5 version :( But I have a solution: I add an EnvironmentVariable via code ...
by louis
21.02.2014, 12:46
Forum: ZeosLib 7.1 stable Forum
Topic: Installing in Delphi 2010
Replies: 1
Views: 604

Re: Installing in Delphi 2010

rblsystem wrote:Someone could tell me how do I solve this problem?
Use D7 package, the package for D2010 AFAIK is not useful.

Bye
by louis
21.02.2014, 10:29
Forum: ZeosLib 7.1 stable Forum
Topic: Where I put firebird.msg when i have two clients
Replies: 4
Views: 1089

Where I put firebird.msg when i have two clients

Hallo, I have a PC with two clients: - fbclient21.dll for version 2.1 in windows\system - fbclient.dll for version 2.5 in windows\system Both clients connect to the 2.5 server version and I cannot change this unless I update the application that uses fbclient21.dll. With application that uses fbclie...
by louis
31.12.2013, 10:13
Forum: 6.6 - stable
Topic: Win 8.1 + FB 2.5 server + FBClient_2.1 - I can do?
Replies: 2
Views: 1614

Re: Win 8.1 + FB 2.5 server + FBClient_2.1 - I can do?

usually you can do this. ... There are some corner cases that seem to give problems nonetheless. ... So in general I suggest to upgrade your appliction as soon as possible to Zeos 7.1 and so at least to Delphi 7. Ok, thanks marsupilami, I'm already rewriting the application with D2010 but it is not...
by louis
28.12.2013, 18:38
Forum: 6.6 - stable
Topic: Win 8.1 + FB 2.5 server + FBClient_2.1 - I can do?
Replies: 2
Views: 1614

Win 8.1 + FB 2.5 server + FBClient_2.1 - I can do?

Hallo, I have a program created by D5 with Zeos 6.6.6 stable that use FB 2.1 protocol. Now this program must run on Win 8.1 and in this PC is installed FB 2.5 (is not possible to install version 2.1 :cry: is prohibited by the owner). I tried the program with FBClient 2.5 and I have many AccessViolat...
by louis
05.12.2013, 19:51
Forum: ZeosLib 7.1 stable Forum
Topic: what's best's in master/detail: DataSource or MasterSource?
Replies: 0
Views: 1278

what's best's in master/detail: DataSource or MasterSource?

Hallo, Like the object: What's best's in Master/Detail relationship: DataSource or MasterSource + MasterFields + LinkedFields? RDBMS is Firebird. In many posts I read some examples that use DataSource and other examples that use MasterSource + MasterFields + LinkedFields. What are the real benefits ...
by louis
10.01.2013, 17:36
Forum: ZeosLib 7.0 Beta Forum
Topic: [solved] Firebird 2.1 + Delphi2010 = EVariantTypeCastError
Replies: 3
Views: 2208

Forgive me, forgive me, :oops: :oops: :oops: Everything works fine! :oops: :oops: :oops: I really wrong to create the TLookupField. (in the test project I created "ztb1lkModo" as type TSmallintField instead was created type TWideStringField!). :cry: Forgive me again, I was wrong as a rooki...