| Help [message #133646] |
Sat, 20 August 2005 10:19  |
David_nyh
Messages: 3
Registered: August 2005
|
Junior Member |
|
|
IF :block_name.item_name IS NULL THEN
MESSAGE('Field is empty');
RAISE FORM_TRIGGER_FAILURE;
ELSE
EXECUTE_QUERY;
END IF;
The problem is that the datatype a number is. When I put a number in it works. But when I fill a > or < it still says that it is empty because it is not a number. But in enter query mode you can type that in. So how can I make them recognize > or < not as null.
|
|
|
|
|
|
| Re: Help [message #133707 is a reply to message #133647] |
Sun, 21 August 2005 19:22  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
In which trigger do you have this code?
Do you have this trigger's 'Fire in Enter-Query Mode' set to 'Yes'?
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
