I just created a connection in VFP6 to PostgreSql 7.1.3 through ODBC (Version 7.1.9).
When I used 'Sqlconnect' and 'Sqlexec' the results are are expected.
But when I try creating remote view from Database Designer the are error shown
'No result set has been returned by the server'.

Futher checking the 'Parse Statements' int the Options(Advanced) of the driver the view was created but the view could not be opened.

But creating the view with 'Create Sql View' command works fine and can then be modified as reqd.


Rajesh