vfp connect to postgres view error
Posted on 2011-03-21
I am using database postgres 9.01 and front end with vfp9. By odbc version 9.0.2 I have a problem using the SUM in view. It already come up with Fatal Error C000005...(it is not everytime, but usually, for example, the first time it run without problem, but run again will occur such error)
1.My PCs are windows XP.
2. I have try vfp8 and 9 also have such error.
3. if use odbc 8.04, it have no such error, but it always hang when 'use' or 'require' a view in runnig a application. (but if I insert a susp before the 'use', and resume, then it can run without problem.
I also try to use spt instead of view. but the sum result have not show the value.
ie. use spt to sqlexec command: select sum(qty) as amt from govu
the result only show a blank in column amt, list the table property, the column amt is N(0,2)...
(in vfp6 it should be store in a memo field)
Can any one can help and or have any other way to get the sum value ?
Thanks in advance