Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Use table
Message
De
08/09/2008 05:57:30
 
 
À
08/09/2008 05:42:22
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01345664
Message ID:
01345669
Vues:
14
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform