Subject | AW: [firebird-support] Array datatype? |
---|---|
Author | Check_Mail |
Post date | 2019-08-29T06:41:44Z |
Hello Kjell,
then I have to do the mapping between Monday = 1, Tuesday = 2, Sunday = 0. But I can only select the value with an execute statement.
I will test it, thank you. 😊
Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Donnerstag, 29. August 2019 07:46
An: firebird-support@yahoogroups.com
Betreff: Re: [firebird-support] Array datatype?
Den 2019-08-29 kl. 07:17, skrev 'Check_Mail' check_mail@...
[firebird-support]:
>You should probably consider a lookup table, i.e. whatever you would
> Okay,
>
> unfortunately there is no coherence between the weekday 0-6 and my
> table-Field Montag, Dienstag etc. (developed historically) and the execute
> statement works not too (not with "variable = variable + variable" and not
> with "select variable + variableb from rdb$database"
>
> Thank you, Dimitry!
>
like to put in an array, put it in a separate table instead, one record
for each array entry.
If the "array" is different for each execution of the procedure,
consider using a global temporary table, GTT. You can find more on this
page (about 1/4 down):
https://firebirdsql.org/rlsnotesh/rnfb210-ddl.html
Regards,
Kjell
[Non-text portions of this message have been removed]