|
|
|
Re: Oracle Error 00904 [message #614376 is a reply to message #614374] |
Wed, 21 May 2014 04:14 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Take the select statement from the error message and run it in sqlplus and see what that says.
It's difficult to tell from the screenshot but it looks like the dates aren't wrapped in quotes. If so that's the problem, so where do the dates come from?
[Updated on: Wed, 21 May 2014 04:14] Report message to a moderator
|
|
|
|
|
Re: Oracle Error 00904 [message #614379 is a reply to message #614378] |
Wed, 21 May 2014 04:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Assuming d1 and d2 are date datatypes you should have just written:
set_block_property('update_sal',default_where,'dt between :d1 and :d2');
Forms has no issue with refering to the names of datablock items in where clauses, it does it implicitly all the time.
You should also get into the habit of writing the block name when refering to items.
|
|
|
|
|
|
|