>If anyone can help I'd really appreciate it
>
>thanks
>
>tony c.
Tony,
Test to make sure that your parameter is being passed to the program correctly. A simple ? (parameter name) after the Lparameters statement in your program will echo the parameter value to the screen. If the right table name appears, your problem comes from the way you are attempting to open the table.
When using the parameter value instead of the actual table name, remember that you need to enclose the parameter name in parenthesis
eg use (mytablename) in 0 alias MyTable.
HTH.
John
John Adams
John T. Adams
Software Consulting Services