I have an MSHFlexGrid control whose datasource is a stored procedure that takes 3 parameters. When I add or delete records I want to close and reopen the datasource, and obviously have to reprovide the correct parameters.
Initially this was fine, as the parameters were provided by controls on the form from which the dataentry form was launched.
The trouble is that now the form can be launched from a number of different places, so the values for the parameters come from different places. What I would like to do therefore is, before closing the command object I want to find out what parameters are being passed to it so that I can immediately reopen it with the same parameters. I thought I could do this with Dataenvironment1.commands("NameOfCommand").Parameters(1) etc. but that returns an empty string. So what do I do?