Access data set -> data row in beforeOpen

al91206

Hi,

If I wanted to test a parameter with a data row in the beforeOpen is this possible?

For example:

if(params["table_param"]== datarow["paramcheck"] )
{
this.queryText
}
else {
this.queryText + "where something happens"
}

Thanks,

Al

mwilliams

Hi Al,

I don't think you can check against a value until you've fetched the data. Your best bet is probably to create both dataSets with a table tied to each one and drop the one you don't want depending upon the value.