ISTech Support Forum

ISTech Support Forum
http://www.istechforum.com/YaBB.pl
Crystal Reports, ODBC & Access >> Access General Issues >> WOBOM_LINE^
http://www.istechforum.com/YaBB.pl?num=1208800343

Message started by Kelloggs on 04/21/08 at 10:52:23

Title: WOBOM_LINE^
Post by Kelloggs on 04/21/08 at 10:52:23

We just upgrade to Pervasive v10 and the lates Evo patch 03/28/08.
We are having problem with this query. It is the WOBOM_LINE^ column, we believe the "^" character.

Do you know a way around?

thnks

SELECT
WOBOM_WOPRE AS WOPRE,
WOBOM_WOSUF AS WOSUF,
WOBOM_LINE^ AS WOLINE,
WOBOM_^ISSUED AS ISSUED,
WOBOM_AMATCST AS COST,
WOBOM_QTYISSUED QTYISS F
ROM WOBOM WHERE WOBOM_WOPRE=1010

Title: Re: WOBOM_LINE^
Post by GasGiant on 04/21/08 at 11:54:58

Enclosing it in quotes works for MS Query into Excel

Title: Re: WOBOM_LINE^
Post by Kelloggs on 04/21/08 at 12:16:03

yeahhhh :P