Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use table
Message
From
08/09/2008 11:42:46
 
 
To
08/09/2008 05:36:06
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01345664
Message ID:
01345780
Views:
10
Which line of code doesn't work and what is the error message?


>hi all,
>
>i need to use table after convert it from excel sheet as below,
>
>CLOSE all
>SET DATE BRITISH
>SET CENTURY on
>thisform.text11.Value=GETFILE('xls')
>IMPORT FROM (thisform.text11.value) TYPE xls
>use JUSTSTEM(thisform.text11.value)
>tt=JUSTSTEM(thisform.text11.value)
>CLOSE all
>USE (tt) excl
>FOR gnCount = 1 TO FCOUNT( )
>   m.OldName =  FIELD(gnCount)
>   m.NewName = ALLTRIM(EVALUATE(FIELD(gnCount)))
>      ALTER TABLE (tt) RENAME COLUMN (m.OldName) TO (m.NewName)
> NEXT
>
>tt=JUSTSTEM(thisform.text11.value)
>CLOSE all
>USE (tt) excl
>
>**i try tt.name,ot (tt.name) not works
>
>**********************************************
>
>
>lnFields=AFIELDS(laFields)
>SELECT 0
>CREATE TABLE qcombined1 (name c(LEN(tablename.name)),amt c(17),dedcode c(4)***error (tablename.name)
>
>
>thanks
Previous
Reply
Map
View

Click here to load this message in the networking platform