Home » Developer & Programmer » Forms » record group problem with global (forms 10g , windows xp)
record group problem with global [message #346996] Wed, 10 September 2008 06:39 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 08:20:09 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.