Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Environment causing ALIAS shift
Message
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00056573
Message ID:
00056585
Views:
29
>>>I had a form with one table in the DE, some text boxes, and some nav buttons. No problem. I added a grid with .Recordsource = myview, and added the view to the DE. Still no problem. Then I added another table to the DE, intending to use it as a combo.Rowsource. Then my nav buttons stopped working. It would jump from the first to the last record, showing maybe one or two records in between. The behavior is the same, whether I use the form wizard buttons or my own nav buttons, which are similar. Tests with the debugger have indicated that the selected ALIAS() is shifting, and that the original alias, when it returns, is at EOF(). But I have no code that selects this third cursor in the DE.
>>
>>If you have your owh buttons, then, I guess, you should just Select table1 before issuing SKIP.
>
>I do. My nav buttons class, modeled after wizstyle.txtbtns, gets the "table1" and puts it in a property when starting up. It selects this table before SKIPping. The jumping around seems to already have happened when the button.click executes. I made sure that the correct cursor was the DataEnvironment.InitialSelectedAlias, and, anyhow, if the correct one was selected before, adding a table to the DE shouldn't hurt anything.
>
>I just tried it again. This time, I was able to put the table in the DE, and didn't get the weird behavior until I made that table the combo.Rowsource. I have since added another table to the DE and used it for a SELECT - SQL which is the rowsource of another combo, which is in my grid. I had this happening before, decided it was a corrupted form, and deleted the form. The problem went away for a while, or so it seemed.

Bret,
Are one of the tables in your DE a view?

Mark A. Struck
Previous
Reply
Map
View

Click here to load this message in the networking platform