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:
00993780
Views:
15
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform