All I want to do is hard code two parameters to a stored procedure. I have tried
{call MyProc ('StringParam') , 56}
{call MyProc 'StringParam' , 56}
{call MyProc ('StringParam') , (56)}
{call MyProc 'StringParam' , 56}
{call MyProc 'StringParam' 56}
{call MyProc ('StringParam') (56)}

and nothing works - I get 'syntax error or access violation when opening the record set. Hard coding a single parameter stored procedure works a treat :-

{call MyProc ('StringParam')}

Please help. Could you also mail me back on [email protected] as I am still waiting my login password to this forum. Thanks.