[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 498
  • Last Modified:

9I Forms problem when using LOV Wizard, FRM-10095

Hi All:

I am using Oracle9i Developer Suite / Forms Builder to create forms against a 9i Database, I am running a Win 2000 machine.

I successfully created a Student form by using Data block wizard based on a Student table in the database. Now I am trying to add a LOV button on the Student form. The first step is to edit LOV, what I did was:

[1] right click LOV in Object Navigator, open LOV Wizard.

[2] in the SQL Query Statement window, I wrote:

select major into : STUDENT.major from major_list

among these: STUDENT is my datablock name, major_list is a table.

[3] I compiled without error.

[4]When I clicked Finish button on LOV Wizard, I got error:

FRM-10095; Assertion failed in iewvqri_check_syntax, at E:\f021w32\src\ie\jewvqr.c:763


Please help!


Thanks


David Zhu


0
wzhu
Asked:
wzhu
  • 2
1 Solution
 
Helena Markováprogrammer-analystCommented:
I think that
2] would look like this:

select major from major_list

There is no need to use   into : STUDENT.major   there.

Henka
0
 
Helena Markováprogrammer-analystCommented:
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

Accept Henka's comment as answer.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now