[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index]
[Date Index]
[Thread Index]
[SQR-USERS Info]
[SQRUG Home Page]
RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object Conversion Error.
Nope, but it is a select of a view. And it works fine in TOAD.
-----Original Message-----
From: the dragon [mailto:ceprn@hotmail.com]
Sent: Friday, September 26, 2003 5:46 PM
To: sqr-users@sqrug.org
Subject: RE: [sqr-users] (SQR 6806) String2Em: String to Decimal Object
Conversion Error.
It isn't a dynamic select, is it?
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----
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-----
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
----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.
_________________________________________________________________
Add MSN 8 Internet Software to your existing Internet access and enjoy
patented spam protection and more. Sign up now!
http://join.msn.com/?page=dept/byoa
_______________________________________________
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