Home » Developer & Programmer » Forms » WHERE Clause
WHERE Clause [message #79518] Wed, 19 June 2002 02:56 Go to next message
Nishant
Messages: 20
Registered: August 2001
Junior Member
Thanks previous query's answer.

Can we use 'LIKE' operator with screen text fields value in Condition of where clause of SET_BLOCK_PROPERTY? for ex. user enter 'ab' in description field then it sould return all records starting or anywhere in the field with 'ab'.
Please write a syntax with example.

Report message to a moderator

Re: WHERE Clause [message #79520 is a reply to message #79518] Wed, 19 June 2002 03:30 Go to previous message
Subhash
Messages: 105
Registered: October 2001
Senior Member
Set_Block_property(:system.cursor_block,default_where,'value like ''%'||:block.value||'%''');

Regards

Report message to a moderator

Previous Topic: WHERE Clause
Next Topic: help
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 24 17:14:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.