Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Local SQL works if parsed from string
Message
From
18/02/2001 16:44:48
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Local SQL works if parsed from string
Miscellaneous
Thread ID:
00477135
Message ID:
00477135
Views:
56
I have a small utility to rebuild views from a data dictionary. Because we are handling cascading views, I open each view as it is built(with the alias expected by the next view) and then go on to build the next one.

So the command is:
USE (lc_use) ALIAS (lc_alias) IN 0

This works fine for about seven views.

Then on the 8th it starts failing.

At this point lc_use="\\venus\datastore\int\dd\ddvalprogs\valindata\valindata!lv_main_daily_counts"

lc_alias="v_main_daily_counts"

The full path reference including server to the database is used througout the program. I'll check if removing it will work.

This is on Window 2000 (just got on this machine) In VFP 6.0 with all patches.
Thanks

Gar W. Lipow
Next
Reply
Map
View

Click here to load this message in the networking platform