At 07:49 PM 07-05-02 -0400, Alan Davies wrote:

>Hi
>I use Delphi 6 and FB 1.0, but this would apply to IB too, and previous
>versions of Delphi
>I have read the article in Embedded SQL about using arrays and cannot
>figure out how to read/write data into arrays. The examples shown appear to
>be ok but when I try to insert data I get nowhere.
>I can create a table such as:-
>CREATE TABLE ARRAYTEST(
>DESCRIPTION CHAR(5),
>INT_ARR INTEGER [3]
>)
>But I cannot work out how to insert data into the table

For dynamic SQL array operations are done through the medium of API array
descriptors and functions (isc_array.set_desc() etc.) and you work with
array slices. You can't refer to array dimensions dynamically in DSQL.

>Does anyone know of a clear example of how to do the following:-
>in Delphi

AFAIK, the VCL has no support for FB/IB arrays. IB Objects does have
it; I don't know about FIBPlus and IBX.

If you want to roll your own, the API Guide has detailed instructions.

Helen

All for Open and Open for All
Firebird Open SQL Database · http://firebirdsql.org ·
http://users.tpg.com.au/helebor/
_______________________________________________________