Wrong "Create Selectable SP" output

[arvanus]

(Same bug for EXECUTE BLOCK statement)

Output: If I change in View->Preferences->Fields to "Only show datatype" it creates correctly: (but ideally would be to show the domain) With show both domain and datatype, appears like this (bug):

I think that the same routine is used both for initial TreeView and for this, I think that when extracting FR would need to use the field domain when existing and the datatype elsewhere. I would like to get some suggestions of what would be the most "elegant" way to give to the user this SQL

Thanks

[Jdochoa]

I created two new types of parameters

• Source
• TypeOf. Please see selectable procedure for a example of "Type Of" and selectable Execute Block for a example of "Source"

[luronumen]

Hi @arvanus,

Is this issue still reproducible in 0.9.3.8 Snapshot version?

[arvanus]

Hi, almost there! At "Create selectable stored procedure", it's correctly using "type of" At "EXECUTE BLOCK", it's always using the domain, even when there is no domain so it's using RDB$##, needs to fix this:

Note: type of column was add at Firebird 2.5, so this might be optional https://firebirdsql.org/refdocs/langrefupd25-psql-declare.html

[Jdochoa]

Hi, almost there! At "Create selectable stored procedure", it's correctly using "type of" At "EXECUTE BLOCK", it's always using the domain, even when there is no domain so it's using RDB$##, needs to fix this:

Note: type of column was add at Firebird 2.5, so this might be optional https://firebirdsql.org/refdocs/langrefupd25-psql-declare.html

Hi @arvanus

I created two new types of parameters

Source
TypeOf.
Please see selectable procedure for a example of "Type Of" and selectable Execute Block for a example of "Source"

if you need execute block with "Type Of" please change the your local file create_selectable_execute_block For the show type verify you settings.

./jo

[arvanus]

Yes, but where it's not used a domain, Fr needs to deliver the primary type, not the "RDB$" domain

[luronumen]

Hi @arvanus

Could you please retest this issue on FlameRobin 0.9.3.12 and close it if it is no longer reproducible?

Thanks in advance, Luciano