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

Click here to load this message in the networking platform