Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

EConvert Error '14200338696' is not a valid integer value

Wed, Apr 25 2007 3:50 PM	Permanent Link
brad@pcpoll.com	I am using a dbisam query and i am using Delphi7 and i am having problems with the statement "Where PLUCode = 14200338696'. This statement comes up with an error saying that 14200338696 is an invalid integer value, PLUCode is a Float field so i am confused on why it would be thinking that 14200338696 is an integer. Is there anything i can do so that it will think that the number is a float value.
Wed, Apr 25 2007 4:01 PM	Permanent Link
Jim Margarit	brad@pcpoll.com wrote: > I am using a dbisam query and i am using Delphi7 and i am having problems with the > statement "Where PLUCode = 14200338696'. This statement comes up with an error saying > that 14200338696 is an invalid integer value, PLUCode is a Float field so i am confused on > why it would be thinking that 14200338696 is an integer. Is there anything i can do so > that it will think that the number is a float value. > "where PLUCode = 14200338696.0" ? Jim
Wed, Apr 25 2007 5:47 PM	Permanent Link
brad@pcpoll.com	Jim Margarit <mail@drmargarit.com> wrote: brad@pcpoll.com wrote: > I am using a dbisam query and i am using Delphi7 and i am having problems with the > statement "Where PLUCode = 14200338696'. This statement comes up with an error saying > that 14200338696 is an invalid integer value, PLUCode is a Float field so i am confused on > why it would be thinking that 14200338696 is an integer. Is there anything i can do so > that it will think that the number is a float value. > "where PLUCode = 14200338696.0" ? Jim Thanks that worked
Fri, Apr 27 2007 7:34 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Brad, << I am using a dbisam query and i am using Delphi7 and i am having problems with the statement "Where PLUCode = 14200338696'. This statement comes up with an error saying that 14200338696 is an invalid integer value, PLUCode is a Float field so i am confused on why it would be thinking that 14200338696 is an integer. Is there anything i can do so that it will think that the number is a float value. >> Is this only occurring in the IDE ? If so, just ignore it since DBISAM will trap it and handle it at runtime. -- Tim Young Elevate Software www.elevatesoft.com