I really hope someone has an answer to this, because it is driving me
crazy.
I am trying to create a remote view to an AS400 database to do a
crosstab.
The view works fine with the crosstab box unchecked but if I check it
and then try and run the view I get:

"Connectivty error:[IBM][Client Access Express ODBC
Driver(32-bit)][DB2/400 SQL]SQL0122 - Column Avavva or Expression in
select list not valid."


Is this a VFP problem or an ODBC Driver problem?

Any ideas would be very appreciated.

Thanks
Frank

On a wild guess, I'll bet VFP is sticking the "DO (_genxtab)" command after
the sql-select in the view definition, and that's what's throwing your
error. Can you open the view designer and view the SQL source to see if this
is the case?

If so, it's an under-design. The obvious workaround is to leave Crosstab
unchecked, and run GenXtab yourself after the records are retrieved.

Dan

"Frank" <sciarref (AT) mscdirect (DOT) com> wrote

"Dan Freeman" <dan.freeman (AT) sbcglobal (DOT) net> wrote


That was the problem and I am unchecking crosstab to resolve the problem.
I was just hopeing there was a solution other than that so I could
do the task in one line. I wonder if this was fixed in Version 8?

Thanks!!

Put it in a prg and it's one line again. <g>

Use TheView
DO (_genxtab)

I doubt it's considered broken, so I doubt it will be fixed.

Dan