Forms and LOV problem.

I am creating a form that uses a LOV for a field. It is a State field. What the problem is I get an error saying that the LOV contains no entries (frm-41830).

I know that the table I am using does contain all of the states and I am pointing the record group to use the correct table and fields.

To get where I am now I:

1. Created a Record Group with the query being "select * from states"
2. Created a LOV based on the existing record group
3. Applied the appropriate column mapping
4. Pointed the desired field to the LOV to use
5. Hit the "Run From" button, pressed 'F9' on the correct field
6. Received error message FRM-41830, LOV contains no entries.

What I have done above has worked for creating other lovs. So I don't know what is up now. The only difference is that I am on a different machine now.

I am able to do "select * from states" at the sql*plus prompt and I am using the correct user and schema.

I do hope somebody can help me.
Jon Received on Sat Apr 03 1999 - 21:08:30 CEST