Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Alter problem
Message
De
28/03/2010 13:19:32
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Alter problem
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Novell 5.x
Divers
Thread ID:
01457693
Message ID:
01457693
Vues:
108
Hi All:

I have a program that works fine on my end, but my client has a problem. He's running Windows XP with Novell.

Here's the code:
tcFileName = 'PO'
WAIT WINDOW NOWAIT 'Now processing ' + UPPER(tcFileName)
USE (tcFileName)  EXCLUSIVE

TRY
	ALTER TABLE &tcFileName ADD COLUMN chk c(1)
CATCH
ENDTRY
On my machine, the above code adds a new field 'chk' the first time the program is run and all subsequent times, it raises an error which is CATCHed, since the field already exists.

On my client's machine, it never adds the field, since it always gets an error. The nessage states 'unable to create temporary work files'. This error happens even when I strip the file down to 5 records. i.e. it is not a size problem.

Can you help?

Thanks,

Yossi
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform