Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Combobox 'Record out of range' error
Message
 
 
To
30/07/1998 12:47:22
Cheryl Qualset
Qualset Computer Consulting
Davis, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00122446
Message ID:
00122918
Views:
39
We are not having difficulty using combobox, list box controls be it View, SQL, Alias as rowsourcetype. If you don't mind, try to send to me by e-mail the specific module (zip) and I'll check what went wrong.

>>>>>I have a form with 2 comboboxes. The first contains a list of agencies. The user picks an agency and requeries the second combobox from the contact table for the contacts in the selected agency.
>>>>>
>>>>>I have a separate find form where the user can pick a specific record containing an agency key.
>>>>>
>>>>>When the user picks a record with an agency that has, let's say, 5 contacts. The agency combo box displays the correct agency, the contact combobox is blank. Tabbing through the contact and then shift-tabbing back displays the correct contact. Problem 1.
>>>>>
>>>>>After displaying the record with the 5th contact selected and choosing a different record to display, if the agency's contact list is only 2 long, I get a record out of range error. Problem 2. I have requeried contact before the error and the refresh seems to cause the problem. The control source for the contact combo is the parent record contact key (as opposed to something in the agency view).
>>>>>
>>>>>Any help will be appreciated.
>>>>>
>>>>>C Qualset
>>>>
>>>>Record out of range is being triggered by the ff.:
>>>>
>>>>1. possibility that index is corrupt.
>>>>2. using GOTO N where N is out of range.
>>>>3. using SKIP N where N is out of range (EOF / BOF has been encountered).
>>>
>>>
>>>Another possible reason is #(253 + 256n) record will known bugs error!!
>>>
>>>Because the error will cause Serious program error and crash at once every you have add error handling to catch the error!! >_<'
>>
>>
>>Actually, 'Record out of range' returns error no. 5.
>
>Yes, it is error #5. It is definitely trying to move to a record past EOF.
>
>The combobox seems to have a pointer to a record in the last version of the record set that doesn't get reset when the view is requeried. I have tried changing the control source to blanks before requerying, setting the listindex to 0 or 1 before requerying, doing a refresh before and after these things,.... SQL or Alias rowsource type makes no difference that I have found yet. I am very frustrated.
>
>Cheryl
JESS S. BANAGA
Project Leader - SDD division
...shifting from VFP to C#.Net

CHARISMA simply means: "Be more concerned about making others feel good about themselves than you are in making them feel good about you."
Previous
Reply
Map
View

Click here to load this message in the networking platform