Transferring data from stored procedure to form edits

Database
1

Hi All,
Can anyone show me how to best (read fastest way in terms of connectivity)

a) run a stored procedure that returns a blob field to populate a memo components
b) using the same stored procedure to populate edit components

Should I create a purpose type and use a strings list for the blob field as a transport between the SQL query on my DB interface form and the form requiring the data or is there a better way to do this

I’m using IBDAC components for Fire-bird

Thanks in advance
Grant

2

Hi Grant

Does your storedproc use the SUSPEND verb?

If so, in your query component you should be able to do something like

SELECT * FROM MyStoredProc()

I must admit that I haven’t done this for 10 or so years but in a previous life using FireBird I remember doing somethink like the above.

Regards
Graeme