Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable not found
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00232419
Message ID:
00232538
Vues:
14
>Mark:
> I used sql to generate a Table. It looks something like this:
>
>select nLength as length, quotes.quote_id (there are more fields in real one) from quotes where quote_id <> 0 into c:\dummy\sql_tmp
>if _tally > 0
> alter table sql_tmp add column binding m null
> alter table sql_tmp add column extra m null
> update sql_tmp set binding = binding_r, ;
> extra = ex_r where quote_id = iCur_Q_id
> select sql_tmp
> use
> use c:\dummy\sql_tmp
> REPORT FORM output TO PRINTER PROMPT NOCONSOLE
>endif
>
>I used this routine on other places. It works fine. Thank you.
>sherry

I see you are placing this table into a C:\Dummy folder. On the computers where you experience the problem, have you verified that this folder exists? Why not use a folder that is not likely to be deleted? I would use the GETENV("TEMP") return value as the folder for temp files for creating the table in. At least you can always be sure that folder is intended for temp files. Then you could use the ADIR() function to verify that the directory does exist.
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform