>I use three stored procedures to return DynamicForeColor, BackColor, and FontSize to columns in a grid. The procedures work fine in the development environment. Running the .exe returns "Expression is invalid. Use a valid expression for DYNAMICFORECOLOR" and so on for each of the property settings in each column. If I run the .exe from the command window it works fine too, but not standalone.
>
>Any ideas?
>
>Al Allison
When you include a database in a project, that database is opened and set to current when the project is open. At runtime, the database might not be set to the current database when your grid is instanciated, so the SP might not be in scope. You need to have code in the form.load event that opens the database and set it rto the current database with SET DATABASE. Better yet, rethink the location of this code- if the code is form specific, why not put it in a custom form method? If the same code is run from several forms, you can subclass your grid, and put the code in a custom grid method.
Erik Moore
Clientelligence