Home » Developer & Programmer » Forms » help with execute_query
help with execute_query [message #277855] Wed, 31 October 2007 22:15 Go to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
I am having problems with
execute_query in forms. The error is FRM-41003. I am giving the table structure and the form. Can anyone please tell me where I went wrong. I used the same query in another form and it works.

CREATE TABLE adjdietmas
(name VARCHAR2(40),
bu VARCHAR2(5),
desig VARCHAR2(25),
office VARCHAR2(15),
dietunit VARCHAR2(25),
dietstno VARCHAR2(25),
dietstdt DATE,
dr NUMBER(10),
month VARCHAR2(6),
esec VARCHAR2(2),
empcode VARCHAR2(8))
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE afres
STORAGE (
INITIAL 1064960
NEXT 1048576
PCTINCREASE 0
MINEXTENTS 1
MAXEXTENTS 2147483645
)
/

Thanks

Alister
  • Attachment: diet.fmb
    (Size: 52.00KB, Downloaded 198 times)

[Updated on: Thu, 01 November 2007 00:41] by Moderator

Report message to a moderator

Re: help with execute_query [message #277856 is a reply to message #277855] Wed, 31 October 2007 22:18 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
In the Structure should read as

empcode varchar2(8)


Alister

[Updated on: Thu, 01 November 2007 00:41] by Moderator

Report message to a moderator

Re: help with execute_query [message #277857 is a reply to message #277855] Wed, 31 October 2007 22:20 Go to previous messageGo to next message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Why is it that 8 is not being displayed correctly. I am tring to say the size is 8 but am getting a icon. Why?


Alister
Re: help with execute_query [message #277871 is a reply to message #277855] Thu, 01 November 2007 00:35 Go to previous messageGo to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
i guess that you have changed your block name in the form.
Change it back to the name as you table name.I hope it will work.
Re: help with execute_query [message #277874 is a reply to message #277857] Thu, 01 November 2007 00:42 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
There is a 'Disable smilies in this message' check-box in the optiosn list below the message edit box. Checking it will stop the smilie from appearing.

David
Re: help with execute_query [message #277875 is a reply to message #277871] Thu, 01 November 2007 00:45 Go to previous messageGo to next message
sandeep.kushwaha
Messages: 10
Registered: October 2007
Location: India
Junior Member

Go to block property and put value ADJDIETMAS (i.e table name) for query data source name.
Re: help with execute_query [message #278523 is a reply to message #277875] Sun, 04 November 2007 21:00 Go to previous message
alister
Messages: 101
Registered: August 2007
Location: India
Senior Member
Thank you Sandeep and David.


Alister
Previous Topic: Export données vers excel
Next Topic: how to retrieve database values to a text items(in a separeate block)
Goto Forum:
  


Current Time: Wed Dec 07 02:51:42 CST 2016

Total time taken to generate the page: 0.10022 seconds