Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GETFILE() why is it different for SQL Views?
Message
 
To
08/09/2006 12:15:39
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
MS SQL Server
Miscellaneous
Thread ID:
01152361
Message ID:
01152402
Views:
15
Is NUL a variable? Is it different depending on what database is used?

>I have a persistent problem that I don't know how to fix. It's mainly cosmetic, but its really a pain in the *&^%$.
>
>I have an application that can be configured to use either visual foxpro tables or SQL Views to SQL Server. In the application I have links to do mail merge, etc. and will use the GETFILE() function to prompt for a form letter. When I open the application and use a visual foxpro database the GETFILE() window looks and works normal, I can change the view to details, etc.
>
>But when I open a database using SQL Views, the SAME GETFILE() and the exact same code gives me a different window that although it has the buttons for changing the view, etc. will not change the view and the buttons look different (all I get is an Icon View).
>
>It appears as if a low level function is changing when SQL Views are being used, or I am not seeing something... Here is the line of code that is used for both types of database:
>
>m.cDocName = GETFILE("DOC|DOT",NUL,"Open",1,"Select a Form Letter Document")
>
>BTW, The same behavior is also occuring with PUTFILE().
>
>Oh, and one more thing. Once I've opened a SQL database, and tried GETFILE, then when I reopen the foxpro database the bogus GETFILE() window is still there, I have to exit the program or if I'm running in the development environment exit foxpro and reenter to get the regular GETFILE() window back. This is also true for the development environment. If I attempt to open a program file, the bogus GETFILE() type window is there until I exit foxpro.
>
>Thanks for any suggestions...
>
>Bob Bartel
>MarketWare systems
>www.marketware.us
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform