Hi Dorin
>You can build the IN (...) clause in VFP and send it to a selectable Firebird stored procedure
>
>In VFP:
>
>SQLExec( hConn, [select * from sp_getacc_detail ( ?m.acc_list )] )
>
>In Firebird select procedure you can build your sql statmenet based on IN clause sent and return details
>The parameter can be a varchar ( up to 32k )
I have some hang-up to use variables in this situation. Plus the users I cannot predict, they might, instead of just running the report and get the full report, might go to the mover and click Select All and we end up with a huge list (:) why have I put in the Select All button when I don't want them to use it? I will remove it alright)
I know you are well versed with FireBird and like I mentioned to Mathias that what he suggested is something that calls for a class to be created to CREATE, INSERT and DROP table in the FireBird database based on the provided cursor name. Do you already have such a class created?