Thanks Ivan,

I think use array without API... but :(

Best regards

Gerson


-----Mensagem original-----
De: Ivan Prenosil [mailto:Ivan.Prenosil@...]
Enviada em: quinta-feira, 16 de dezembro de 2004 08:12
Para: firebird-support@yahoogroups.com
Assunto: Re: [firebird-support] How work with Arrays in Firebird ?

> I am try to work with array, what I need to do ?
>
> I create a test table with field: qtd_day integer[1:365]
>
> And try insert like: insert into table value (123[1]) <<<< ?
> or perhaps: insert into table value (123(44)) <<<< ?
>
> but dont work ...
>
> May I work with Arrays field in Stored Procedure, Triggers or not ?
>
> What I need to do ?

The *only* operation on arrays supported in sql (and in SP/triggers)
is retrieving individual value, e.g.

SELECT qtd_day[30]
FROM tab
WHERE qtd_day[1]=1000;

All other functionality is accessible via specialized API *only*.

Internally, arrays are just specialized blobs. So if you use blobs
instead of arrays you will loose the ability to directly retrieve
single values in sql, but you will get better support from other
tools and libraries.

Ivan
HYPERLINK
"http://www.volny.cz/iprenosil/interbase/"http://www.volny.cz/iprenosil/
interbase/



Yahoo! Groups Sponsor

ADVERTISEMENT
HYPERLINK
"http://us.ard.yahoo.com/SIG=12961ebe3/M=294855.5468653.6549235.3001176/
D=groups/S=1705115386:HM/EXP=1103278354/A=2455397/R=0/SIG=119u9qmi7/*htt
p://smallbusiness.yahoo.com/domains/" \nclick here
HYPERLINK
"http://us.adserver.yahoo.com/l?M=294855.5468653.6549235.3001176/D=group
s/S=:HM/A=2455397/rand=520902090"


_____

Yahoo! Groups Links


* To visit your group on the web, go to:
HYPERLINK
"http://groups.yahoo.com/group/firebird-support/"http://groups.yahoo.com
/group/firebird-support/


* To unsubscribe from this group, send an email to:
HYPERLINK
"mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe
"firebird-support-unsubscribe@yahoogroups.com


* Your use of Yahoo! Groups is subject to the HYPERLINK
"http://docs.yahoo.com/info/terms/"Yahoo! Terms of Service.



--
No virus found in this incoming message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 15/12/2004



--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.296 / Virus Database: 265.5.4 - Release Date: 15/12/2004



[Non-text portions of this message have been removed]