Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

changing type of a variable.

1 view
Skip to first unread message

Anthony Perkins

unread,
Oct 26, 2004, 6:44:53 AM10/26/04
to corel.wpoffice.paradox-opal

We have a system that has been in use for 10 years and some tables are
getting rather large so we need to change smallint variables to longint.

Is there any problem, apart from using more memory, with doing this to all
the smallint variables in the application?

We are using Paradox 10.

Thanks in Advance.

Anthony

Eric Frohmann

unread,
Oct 26, 2004, 9:33:45 AM10/26/04
to corel.wpoffice.paradox-opal

No problem. Just make sure that you get them all - a longint crammed into a
smallint will simply truncate bytes.

--
--EricF

"Anthony Perkins" <antp...@aol.com> wrote in message
news:417e247c$1_3@cnews...

Anthony Perkins

unread,
Oct 26, 2004, 12:56:25 PM10/26/04
to corel.wpoffice.paradox-opal

Thanks for the reply.

Anthony

"Eric Frohmann" <solv42.vianet@on@ca> wrote in message
news:417e4c23_2@cnews...

Michael Israel

unread,
Oct 27, 2004, 12:44:59 AM10/27/04
to corel.wpoffice.paradox-opal

Make sure all objects using smallint are change to LongInt, such as forms
with their respective libraries.

"Anthony Perkins" <antp...@aol.com> wrote in message
news:417e247c$1_3@cnews...
>

Anders Jonsson

unread,
Oct 27, 2004, 2:58:30 PM10/27/04
to corel.wpoffice.paradox-opal

As others have said, it shouldn't be a problem but make sure you get all
tables because if you have links on these integers they will brake unless
they are of the same type.

Also consider the fact that you might have code with variables declared as
smallint. If that is the case you might have som work infront of you. :-)

Anders

0 new messages