General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Remote view, Oracle
Mark,
My name is Jason Lanier. I am using FoxPro to connect to Oracle and your articles in Universal Thread were very helpful. I had asked you a couple of questions about it in September/October 2000.
Now I am working on some remote views and would like to ask if you have run into any similar situations. I have a file of closed work orders, but I only want to see a subset of these records. When setting up the view, I added a
filter based on the date and the generated code gives the following SQL code for the view:
SELECT *
FROM COMPLETED_WORK_ORDRS
WHERE WORK_ORDER_DATE > TRUNC(ADD_MONTHS(SYSDATE,-36))
ORDER BY WORK_ORDER_NUMBER
This view works as expected when browsing, etc. The problem is if I need to go back and modify the view. If I attempt to modify, I get the following message "SQL: Column 'SYSDATE' is not found.". Running the code from the command line with SQLEXEC() works fine. At this point, the only way to work around this is to delete the view and re-create it. It's definitely not a "show-stopper", but more of an annoyance. I was just wondering if you knew of a way around this issue.
Thanks,
Jason Lanier
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