Is it possible to use SQL statements in an exe? We needed to modify a database, and it's cdx index. We used FoxPro 2.6 since the legacy programs that create and maintain the database are written in 2.6 and require the cdx index.
A couple of SQL statements using SELECT DISTINCT commands did the job very nicely, when running from within the deveolopment environment, but when we run the exe, we get a message indicating that FoxPro doesn't support this in an exe.
Is there a way to work around this? It will complicate the program a great deal to rewrite the program without using SQL.
Thanks for any suggestions.
A couple of SQL statements using SELECT DISTINCT commands did the job very nicely, when running from within the deveolopment environment, but when we run the exe, we get a message indicating that FoxPro doesn't support this in an exe.
Is there a way to work around this? It will complicate the program a great deal to rewrite the program without using SQL.
Thanks for any suggestions.