| Subject | Re: [firebird-support] Re: Arrays in execute block |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-02-22T22:31:03Z |
At 04:41 AM 23/02/2008, you wrote:
FYI, arrays were put in there for some Borland customer at some point and ignored thereafter. They are formatted blobs and that's how the server sees them. There's nothing you can do with them in SQL except define them. SQL assumes it's talking to a relational database and "relational" doesn't fit with horizontal sets.
There are various API calls for accessing slices of arrays from a client app, which makes them unavailable for invoking on the server. These haven't changed since the dawn of time so you can still pick up a bit from the old IB6 API Guide.
./heLen
>Can someone suggest a tutorial on how to make proper use of theExamples in the Fb 2 and 2.1 release notes. The "block" is an embedded module of run-time PSQL. To respond to your earlier question, PSQL can't take an array as an input or pass one as output. Period.
>execute block statement?
FYI, arrays were put in there for some Borland customer at some point and ignored thereafter. They are formatted blobs and that's how the server sees them. There's nothing you can do with them in SQL except define them. SQL assumes it's talking to a relational database and "relational" doesn't fit with horizontal sets.
There are various API calls for accessing slices of arrays from a client app, which makes them unavailable for invoking on the server. These haven't changed since the dawn of time so you can still pick up a bit from the old IB6 API Guide.
./heLen