Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Variable not found
Message
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00232419
Message ID:
00232538
Views:
13
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform