""Sandeep"" <sandeep@...> wrote in message
news:3BDEC078.12866.16556F6@localhost...

> I have a table with array field called "Address" (Dialect 3)
>
> the following statement works alright
> select "Address" [1] from "Address_Book"
>
> but if I do
> insert into "Address_Book" ("Address" [1]) values ('Auckland')
>
> I get an error saying
> Token unknown [

You have to use the API in this case. Or a package that handles arrays, like
IBO and FibPlus.

C.
--
Claudio Valderrama C. - http://www.cvalde.com - http://www.firebirdSql.org
Independent developer
Owner of the Interbase® WebRing