OraFAQ Forum: Forms » help with execute

Home » Developer & Programmer » Forms » help with execute_query

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

help with execute_query [message #277855]

Wed, 31 October 2007 22:15

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 1021 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

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

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

Report message to a moderator

Re: help with execute_query [message #277871 is a reply to message #277855]

Thu, 01 November 2007 00:35

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.

Report message to a moderator

Re: help with execute_query [message #277874 is a reply to message #277857]

Thu, 01 November 2007 00:42

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator