Zeoslib Portal

this shouldn't happen. Could you please provide the complete DDL (create table ...) for your table? Yes, FB 2.5: CREATE DOMAIN CURRENCY_D AS Numeric(18,4) DEFAULT 0.00 NOT NULL ; CREATE TABLE TABLE1 ( ID Integer NOT NULL, PREZZO CURRENCY_D DEFAULT 0.00, CONSTRAINT ID_PK PRIMARY KEY (ID) Thanks. Reg...

Using TCurrencyField for numeric values was a problem in early Zeos 7.2 development. We changed these places to use TFloatField or TExtendedField later on. But, in Zeos 7.2.4 stable, why if I have this query: SELECT * FROM TABLE1 I gain a TFloatField (I had mistake writing TCurrencyField, TCurrency...

Hello, in Zeos 7.2.4 I get a: "Type mismatch for field xxx, expecting: Currency actual: Extended." In Firebird 2.5 Table1, "PREZZO" is a field of type Numeric(18, 4). In this query: SELECT * FROM TABLE1 In Fields Editor a TCurrencyField is added for field PREZZO. In this query: S...

Hello, Could you check that with some kind of an hex editor / viewer? This might be a bug in Delphi. with an hex viewer, in a file created by BlobField.SaveToFile, I get: 3c 00 3f 00 78 00 6d 00 6c 00 20 00 76 00 65 00 <.?.x.m.l. .v.e. but with an hex viewer I get in a right file (created by TString...

Hello, I use Delphi 2010 and I have a Firebird 2.5 Database and a table as: CREATE TABLE DOC_FE ( ID Integer NOT NULL, XML Blob sub_type 1, CONSTRAINT DOC_FE_PK PRIMARY KEY (ID) ); The Field XML contain a xml file like this: <?xml version="1.0" encoding="Windows-1252" standalone=...

Hallo,
I need to have a list of all users defined in a firebird server to assign to the role for some of they.

There is a way to have a list of server users?

Thanks

Hello, ok, I am a novice in FB and I will understand it :) I discovered that I can do a "select * from MyStoredProc" within the property SQL of a ZReadOnlyQuery. With this I solved my problem (find the master DataSource of DataModule) and I had semplified my code because in this case I can...

which database do you use (Firebird, PostgreSQL, Sybase, sqlite, ...) and which version of that database? Database is Firebird, version is 2.5.5. I am not si used to using the DataSource Property I need to use "Datasource" property because I need to retrieve the Master-Dataset in a scenar...

Hallo, I need a TStoredProc with a property "DataSource" published because I have a framework that use this property to gain MasterTable in TDataModule. Because TStoredProc not provide property "DataSource" I derived a new component TmxZStoredProc with only add property "Dat...

@ EgonHugeist,

Ok, I misunderstand how Trunk and Test revision works. Sorry

I confirm that regression is fixed, now works Ok.

Thanks

Do you really loaded and rebuilt ZEOS 7.2 svn 3878 or later? I Have TortoiseSVN installed with repository that points to http://svn.code.sf.net/p/zeoslib/code-0/trunk. I start downloads with revision 3806 on ZEOS720b directory in my PC. I periodically right-click on this directory in my PC and then...

Oops, sorry. Force of habit.

See attacked file.

Thanks

EgonHugeist wrote:Louis could you make a little template app with a create-script or a ready database? Else i can't locate your problem..

Ok, see attacked file.
Compile file, then click Button and obtain exception.

Thanks

the option it should work properly now. Confirmed? Sorry but not, even il 3879 revision :( I have this scenario: 1) a table (items) with more fields, one of them is a binary blob (image). this table is a foreighkey for another table (orders). 2) during populate "Orders" table by visual co...

miab3 wrote: There is a problem with the start of the application with the option doCachedLobs = True and full BLOB in first record.
However, if after the start (in runtime) Enable this option it work without error.

I Confirm, if I set doCachedLobs runtime it works, even in 3878 revision.

Thanks