Home » Developer & Programmer » Forms » Error :FRM-41335
icon11.gif  Error :FRM-41335 [message #216469] Sun, 28 January 2007 13:21 Go to next message
lunate
Messages: 74
Registered: October 2006
Location: Pakistan
Member

HI ALL ,
I HAVE A PROBLEM RELATED TO COMBO-BOX.

PROBLEM IS IN MY DATA BASE BUT HERE I DESCRIBE IT BY AN EXAMPLE.

SIMPLE I WANT TO DISPLAY DEPTNO IN DNAME COMBO-BOX OF DEPT DATA BLOCK.

SO I SIMPLE CHAGE THE TYPE ON 'DNAME' FROM TEXT-BOX TO LIST BOX AND SET STYLE TO'COMBO-BOX'.OK

NOW I WRITE A CODE IN 'NEW-FORM-INSTANCE' OF FORM.AS BELOW

DECLARE
REC RECORDGROUP;
STATUS NUMBER;
BEGIN
REC:=CREATE_GROUP_FROM_QUERY('REC','SELECT DEPTNO,DNAME FROM EMP');
IF NOT ID_NULL(REC) THEN
STATUS:=POPULATE_GROUP(REC);
POPULATE_LIST('DNAME',REC);

ELSE
MESSAGE(STATUS);
END IF;
END;





IN ABOVE >DEPTNO IS DISPLAY ITEM WHILE DNAME IS DATABASE ITEM(RETURN ITEM).

BUT WHEN I RUM MY FORM I GOT ERROR : FRM-41335 POPULATE_LIST:INVALID CLOUMN TYPE FOR COLUMN 1.

CAN ANY ONE HELP ME TO DO SO.(DISPLAY DEPTNO AND RETURN DNAME).

IS IT POSSIBLE TO DO ?

PLEASE TELL ME ,AND CORRECT MY CODE AND SETTINGS ALSO.

THANX
REGARD.
Re: Error :FRM-41335 [message #216498 is a reply to message #216469] Sun, 28 January 2007 22:54 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Why don't you use a regular record_group? What are the datatypes of the fields in the query and the items in your form into which you are going to place them?

David

PS It looks like your caps lock button is stuck again.
Previous Topic: exit form
Next Topic: Need a modal dilaog to show up at (0,0)..ASAP
Goto Forum:
  


Current Time: Fri Dec 02 22:58:12 CST 2016

Total time taken to generate the page: 0.05259 seconds