General information
Title:
Database connections in executable
I've written a program that utilizes a view of an OBDC source to store data. But when I built an executable out of the file, it prompts me for a .dbf file. I tried replacing the statement in-program with the SQL displayed when I looked at the SQL of the View, but that doesn't work.
Here is the program line that works in foxpro with the ARRESTSVIEW view:
SELECT ALLTRIM(TICK_NUM) AS TICKUPD FROM ARRESTSVIEW INTO Cursor existingrecs_cursor TICK_NUM = alltrim(ARREST_SRC.TICK_NUM)
Here is the SQL statement that defines Arrestsview connection:
SELECT *;
FROM SFHL_DATA.ARRESTS Arrests
How can I write this to work form an executable, so that it knows and recognizes the ODBC connection?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only