Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Use table
Message
From
08/09/2008 05:57:30
 
 
To
08/09/2008 05:42:22
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:
01345669
Views:
13
Hi Thomas,
thank you very much,

>Hi Mohammed,
>
>tt isn't the name of your cursor. Its just a variable. To access the Field in 'tt' you could use macro substitution.
>
>&tt..name
>
>
>>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