Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL selct problems
Message
From
14/05/1998 09:13:00
Mark Hall
Independent Developer & Voip Specialist
Keston, Kent, United Kingdom
 
 
To
14/05/1998 08:49:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00099376
Message ID:
00099383
Views:
16
>When trying to do a select into an array and then an append from array I get numeric overflow errors even when appending back onto the table that I selected from in the first place, this doesnt seem to happen when I use Copy to Array and then apend from array.
>
>Is this a problem other people have? I know there is a workaround by using copy but it is still irritating.
>
>Ashley
I don't think you are, but,
Are you manipulating the numeric values in the SELECT, so that they become too big for the fields?

SELECT numb * 999 FROM Table INTO ARRAY laTest
APPEND FROM ARRAY laTest
Regards
Mark

Microsoft VFP MCP
Menulib - OO Menus for VFP www.hidb.com/menulib
Previous
Reply
Map
View

Click here to load this message in the networking platform