Zeoslib Portal

Hello, I have a problem and I hope I can explain myself. In an old Firebird 1.5 database I have a field whose name is "Città". By connecting TZQuery via a TDataSource to a DBGrid I see the field value correctly. The field name is seen as "Citt" I create a TZQuery.BeforePost event...

Yes yes yes!!!
I updated to zeoslib-code-0-4171-branches-testing-7.2 and confirm that the issue has been solved!
All cases in which the problem was present now behave correctly.

you very much

I have done some test: In the PREVHDR table, the "Arrivo" field is defined as DATE. In the LINGUE_PC table, the "Arrivo" field is defined as VARCHAR(20). This select: SELECT PREVHDR."Arrivo", LINGUE_PC."Arrivo" AS "Arrivo_1" FROM PREVHDR INNER JOIN L...

Hi HegonHugeist, after doing some tests unfortunately your changes did not solve the problem. The strange thing is that if you invert the position of the fields in the SELECT the field type is correctly assigned (review my first post). The problem occurs both in Delphi 7 and in CodeTyphon with all v...

Thanks so much, you are the best!!!

I think that the ability to correctly manage quoted field names is an important feature to be implemented in ZeosLib, also because other components do it without problems. I can agree with Fr0sT that it is not advisable to use them but it is also true that it is not prohibited. In fact, Firebird all...

Hi FrOsT, I created a simple TESTDB.FDB database that demonstrates the error. Tables T1 and T2 have a field with the same name. In T1 "Same_Name_Field" is DATE type, in T2 "Same_Name_Field" is VARCHAR (20) type. /* SQL Manager Lite for InterBase and Firebird 5.5.1.50223 */ /* ---...

Hi, I have tested your query but, unfortunately, does not solve the problem. I believe the error is related to Zeoslib. In fact, using other components such as IBX, UIB or SQLQuery in Code Typhon, the problem does not occur. Among other things, I have always used the names of the listed fields witho...

I'm sorry.
I use Firebird. The problem occurred with Firebird 2.5 but I have reason to believe that it occurs with all versions of Firebird.

Thanks

I noticed that the problem occurs only if the field names, in the tables, are in lower case

Hi, I have the following problem in both Code Typhon and Delphi: I have two tables, PREVHDR and LINGUE_PC, with many fields including two of these having the same name: "Arrivo". PREVHDR."Arrivo" is DATE type, LINGUE_PC."Arrivo" is VARCHAR(20) type. If I execute the fol...

I noticed that if the SQL is the field types, in the field editor, are correct

Hi, I have a problem with the Boolean fields of Firebird 3.0. I use Code Typhon Ver. 6.30 on Windows 10 64. I have created a database with the following table: CREATE TABLE TEST_TABLE ( BOOLEAN_FIELD BOOLEAN NOT NULL, OTHER_FIELD SMALLINT NOT NULL); In CT I create a Form on which I add ZConnection a...