>Hi
>
>How do I access stored procedures in the database
>
>Also,
>
>I have placed the following code in the OpenTables method of the Data Environment because I want the initial position of the tables to be set
>
>DODEFAULT()
>GO TOP IN prsched
>SET KEY TO RANGE prsched.code+prodserv.code,;
> prsched.code+prodserv.code+'~~~~~~~~~~';
> IN specprice
>GO TOP IN specprice
>
>Unfortunately I get an 'Error 1966 Data Environment is alreay loaded'
>
>Why is this?

You need a nodefault at the end to stop the OpenTables firing again.

As far as the code in the Database is concerned it should be automatically searched - have you tried calling a function?

HTH
Caroline