|
|
|
|
| Re: how to change Format mask date in Ontime Where [message #442861 is a reply to message #442849] |
Thu, 11 February 2010 00:46   |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
I'm not sure what HIREDATE is, but here's what I supposed: it is a control block column; once you enter a value in there, you'd want to fetch all records from a certain table whose value is equal to control block's HIREDATE item.
If so, here you are; the main "problem" is that you need to correctly concatenate all parts of the ONETIME_WHERE clause, as there is a fixed part of it (first part of the WHERE clause, parenthesis, date format mask) and variable one (HIREDATE item). In order not to get confused, you can use CHR(39) which represents a single quote, instead of its sign ('). That's what I did.
Here's a screenshot of a form based on Scott's EMP table. I hope you'll get the idea.
|
|
|
|
| Re: how to change Format mask date in Ontime Where [message #443315 is a reply to message #442861] |
Mon, 15 February 2010 01:40 |
tamzidulamin
Messages: 132
Registered: October 2009
Location: Dhaka
|
Senior Member |
|
|
there is an error in your when-button-pressed trigger code.
You wrote:
ow:= 'where hire_date=to_date(''01/02/2010'',''dd/mm/yyyy'')';
SET_BLOCK_PROPERTY(block_name,ONETIME_WHERE,ow);
-- Somthing like that.
but the line would be
ow:= 'hire_date=to_date(''01/02/2010'',''dd/mm/yyyy'')';
SET_BLOCK_PROPERTY(block_name,ONETIME_WHERE,ow); -- Somthing like that.
In ONETIME_WHERE or DEFAULT_WHERE , the where condition only include here no WHERE clause.
Regrads,
Tamzidul Amin.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
