IBDAC with Arrays processing

SeaCay · Post by **SeaCay** » Tue 19 Jun 2007 07:05

I seek clarification regarding IBDAC and arrays.

I have a table

CREATE TABLE AA2 (
UNIQUE_ID INTEGER NOT NULL,
FROMLOC VARCHAR(3) CHARACTER SET NONE,
TOLOC VARCHAR(3) CHARACTER SET NONE,
NUMPOINTS INTEGER,
POINTS INTEGER [1:2,1:100],
INSDATETIME TIMESTAMP,
MODDATETIME TIMESTAMP
);

which I can populate with IBDAC components if the table is created within an InterBase database but not with a Firebird database.

Am I missing something obvious or are arrays poorly supported within Firebird?

regards

SeaCay

Alex · Post by **Alex** » Tue 19 Jun 2007 12:57

There are no array functionality restrictions in Firebird. We found out some problem with updating array using IBDAC, when the ObjectView dataset property is set to False. This issue will be fixed in the next IBDAC build.
As a temporary fix you can set the IBCQuery.ObjectView property to True.
If your problem persists, please send us a small demo project that demonstrates this problem. Send your mail to ibdac*crlab*com.
P.S. I suggest you to try the IBDAC demo project that demonstrates general IBDAC features including array handling.

SeaCay · Post by **SeaCay** » Tue 19 Jun 2007 23:23

Wow!
.objectView := true;
did the trick.

The array field was populated correctly.

Thanks!