OraFAQ Forum: Forms » record group problem with global

Home » Developer & Programmer » Forms » record group problem with global (forms 10g , windows xp)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

record group problem with global [message #346996]

Wed, 10 September 2008 06:39

emadnabil
Messages: 179
Registered: August 2007

Senior Member

Hii all

i have a record group based on a sql statement containing condition of global

when running the form and try to show the list of value based on this record group
sometime i got this error
FRM:40502 : Unable to read List of Values

to solve this :
i replace the global value with static value and run again the result of the list of value is shown based on this static value

and then i return back and use the global so that the list of value get the result on this global value

this was the solution
if you read it carefully you will got that i didnot do any update in the sql statment

all i done replace it with static and run and then replace it with global

i don't know why this happening
and how can i avoid this

N.B the global is always set
i checked for it by a message before the list of value is shown

Report message to a moderator

Re: record group problem with global [message #347136 is a reply to message #346996]

Wed, 10 September 2008 18:45

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

The language of this forum is English. The method of starting a sentence is via a capital letter, not a new line. Also, each sentence ends with a punctuation mark indicating whether the preceding sentence is a statement (period), exclamation (exclamation mark), or a question (question mark). USE THEM!!!

Is this happening when you try to show an LOV or when you ask for the 'record group' to be populated?

Have you signed on to the database?

David

Report message to a moderator

Re: record group problem with global [message #347282 is a reply to message #346996]

Thu, 11 September 2008 04:27

emadnabil
Messages: 179
Registered: August 2007

Senior Member

This happens when double click on a field item
that contain this trigger code
WHEN-MOUSE-DOUBLECLICK

	declare 
         	x boolean;
	        x:=show_lov('SALES');
	end;

this list of value map from the record group

,
also i'm signed on to the database

Report message to a moderator

Re: record group problem with global [message #347475 is a reply to message #347282]

Thu, 11 September 2008 18:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

This is not the code that you run in your form as there is no 'begin' statement. CUT AND PASTE THE CODE THAT YOU RUN, DON'T TYPE IT FROM MEMORY!!!

David

Report message to a moderator

Previous Topic:	How to create Hex value in Form6
Next Topic:	Call .Net web services from Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 07 03:57:47 CDT 2026