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