RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object Conversion Error.

["Alexander, Steve" <Steve.Alexander@sanjoseca.gov>]

Thanks for the reference, Larry, but I didn't understand the advice given
there.  That forum seems to be pretty loose compared to the serious tone we
usually keep here.  I've done some further research and found I was wrong
about the values in the field.  It's actually a different field causing the
problem, and that field usually has 11 digit numbers.  Does that give
anybody any ideas?

-----Original Message-----
From: Larry Roux [mailto:lroux@syr.edu]
Sent: Friday, September 26, 2003 6:06 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
Conversion Error.


There is a similar question answered on the PeopleSoft Fans site:

http://www.peoplesoftfans.com/psfans/forum/tools/messages/3295.html




******************************
Larry Roux
Syracuse University
lroux@syr.edu
*******************************
>>> Steve.Alexander@ci.sj.ca.us 09/26/03 20:35 PM >>>
Thanks for the suggestion.  I had done that.  Also, the select worked when I
didn't return this field and didn't work when I did return this field.
Strangely, this program has been in production (unchanged) for months.

-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com]
Sent: Friday, September 26, 2003 3:48 PM
To: sqr-users@sqrug.org
Cc: Steve.Alexander@ci.sj.ca.us
Subject: Re: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
Conversion Error.


Look in your where clause.  check for data type mismatches.  copy your sql 
statement tinot your sql tool and run it with the same values you're using 
in your sqr.

clarl 'the dragon' willis



PSA: Salary <> Slavery.  If you earn a salary, your employer is renting your

services for 40 hours a week, not purchasing your soul.  Your time is the 
only real finite asset that you have, and once used it can never be 
recovered, so don't waste it by giving it away.

"Time is the coin of your life. It is the only coin you have, and only you 
can determine how it will be spent.  Be careful lest you let other people 
spend it for you."

Carl Sandburg
(1878 - 1967)


----Original Message Follows----

I got the following message on the first row of a select statement when
reading a numeric field:

(SQR 6806) String2Em: String to Decimal Object Conversion Error.

What does it mean?  The field contains the number 1.

_________________________________________________________________
Get MSN 8 Dial-up Internet Service FREE for one month.  Limited time offer--

sign up now!   http://join.msn.com/?page=dept/dialup

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users