Environment versions
Network:
Windows 2008 Server
Have you run this query in pgadmin? Did it work? I no longer have foxpro running on a system that can access a postgres database so I can't test.
I'm a little concerned about the 'with' statement in the function - I thought that was a T-SQL SQL feature (non-sql standard).
I'm not any sort of SQL guru so I could be wrong here.
Also have you been able to prove the connection is working? Are you slowly building the sql up to prove the code works?
Johnf
Previous
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