Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Opening a table and select
Message
 
To
11/01/2006 07:55:47
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01085567
Message ID:
01085583
Views:
26
Grady,

Make sure your details form DataSession = 1 - Public. Also, you may want to recode your USE statement like this:
<
>
USE (FileName) IN SELECT('MyFile') ALIAS MyFile
<
>
That will close any currently open table/cursor named or using using the alias MyFile and then open the new file with that alias. If the alias was in use, you will reuse the same workarea, if it wasn't in use, you will use the first available work area.

HTH,
Chad


>What have I done wrong here?
>
>
>FileName = GETFILE('DBF')
>USE (FileName) IN 2 ALIAS MyFile
>
>
>After opening this table in the load area of a form, a user can click on a map in the form.
>The click event calls a details form. The details form opens fine. I have option button choices on the details form. When the buttons are clicked values are not replaced in the fields. Furthermore, modify memo does not work.
>
>If I hard code a table to the details form everything works fine, so I think the code above is causing the trouble.
>
>Any ideas?
_________________________________
There are 2 types of people in the world:
    Those who need closure
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform