| Execute_query [message #144935] |
Sat, 29 October 2005 03:46  |
fmis
Messages: 11
Registered: October 2005
Location: CALICUT
|
Junior Member |
|
|
hai
In prequery trigger can i spcify 'distinct clause' in 'default_where' of set_block_property inorder to get only one matching record.
|
|
|
|
| Re: Execute_query [message #144951 is a reply to message #144935] |
Sat, 29 October 2005 11:28  |
sachinjainonweb
Messages: 24
Registered: October 2005
|
Junior Member |
|
|
hi
If u havent done much work as of now on that form then make a view using select distinct clause and base ur form on that view. and if now its not possible then use good old rowid method .
give ur table alias say 'a' in block property and use this in where clause
rowid in (select min(rowid) from <table> where <col>=a.<col>)
Luck Always
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
