Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VFP to SQL
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Environment versions
Visual FoxPro:
VFP 8 SP1
Database:
Visual FoxPro
Miscellaneous
Thread ID:
00993747
Message ID:
00993781
Views:
17
Are you running select statement in VFP?

>The select statement is very long so I'll give it to you in a shorter version:
>Select FileNo, Description from Tbl into cursor TempTbl
>
>It only works when I do the following but it results in lost data:
>Select FileNo, padr(alltrim(Description),254) as desc from Tbl into cursor TempTbl
>
>However, I noticed that if I CREATE TABLE prior to the SELECT and do an INSERT, the problem disappears. It's just a very tedious and long recode project.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform