If I'm reading this correctly, you have to strip out the "$" before you can use it in a numeric field
--- On Tue, 6/1/10, Sytze de Boer <[email protected]> wrote: > From: Sytze de Boer <[email protected]> > Subject: Data type mismatch > To: [email protected] > Date: Tuesday, June 1, 2010, 4:44 PM > My system imports data from several > bank CSV files > One of the fields is a character field that MAY include > data which my app > wants to process > > The code goes something like this > go top > scan > Nsrch=val(alltrim(analcode)) > if Nsrch>0 > sele glcodes > && indexed on Code, numeric 6,2 > seek Nsrch > etc > > Suddenly, yesterday, I received this error report, Data > type mismatch > > I found the following data in the field analcode, $1.35 > So it would give me Nsrch as 1.35, but bomb out on Data > type mismatch > > Does anyone wish to comment > > -- > Regards > Sytze de Boer > Kiss Systems > Hamilton, NZ > Ph: 64-7-8391670, Mob:64 21 937611 > URL: www.kiss.co.nz > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/[email protected] > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
