Solved

Converting to Integer Problems

Posted on 1998-02-24
2
275 Views
Last Modified: 2010-04-06
I am having problems converting a string value in a table to an integer.    An example is listed below.

   Note: psoc is defined as an integer.
         Table2's er_ssn is defined as a string.

psoc :=table2.FieldByName('er_ssn').asinteger;

Later I insert the value of psoc in a table and get...

psoc => -32324

if I do...
label1.capton :=table2.FieldByName('er_ssn').asstring;

I get ...
label1.caption => 006521276  (Which is the correct Number)

How do I populate the new table with the correct integer value???

   P.S.  I have changed the 'picture' property in the new table to display unsigned integer... But I still get -32324?

What do I do now....
0
Comment
Question by:pepe
2 Comments
 

Author Comment

by:pepe
ID: 1359749
Edited text of question
0
 
LVL 8

Accepted Solution

by:
ZifNab earned 100 total points
ID: 1359750
You get this error, because integer types can't  contain such high values, these are the ranges.

SmallInt      -32768 .. 32767      Signed 16-bit

Longint      -2147483648 .. 2147483647      Signed 32-bit

What if you change the field to type LongInt, Cardinal? Or you have to go to real values. Also psoc has to be such a type!!



0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Mydac connection data base issue 3 166
Intraweb download file link ? 1 156
TServerSocket - file via sendbuf or Text via sendtext ? 1 65
Delphi and Access based Enumeration 9 70
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

831 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question