OraFAQ Forum: Forms » How to use the like clause in Where

Home » Developer & Programmer » Forms » How to use the like clause in Where (FORM 6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to use the like clause in Where [message #404521]

Fri, 22 May 2009 01:39

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

HI,
How to use the "Like" clause in Where property

i want to like

s_no like '%blocka.sno'

kanish

Report message to a moderator

Re: How to use the like clause in Where [message #404524 is a reply to message #404521]

Fri, 22 May 2009 01:46

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Create your Block's Default_Where clause programatically instead of direct writing the code in the property palette.

Regards,
Azam Khan

Report message to a moderator

Re: How to use the like clause in Where [message #404527 is a reply to message #404521]

Fri, 22 May 2009 01:59

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

please guide how use this, i have error

Set_item_property('Chasssis_no',DEFAULT_WHERE,'unitid = :global.unitid and Chassis_no like ||''''||%Chassis_no||''''');

Set_item_property('Chasssis_no',DEFAULT_WHERE,'unitid = :global.unitid and Chassis_no like '''%Chassis_no'''');

both having runtime error.

how to solve this case.

kanish

Report message to a moderator

Re: How to use the like clause in Where [message #404529 is a reply to message #404521]

Fri, 22 May 2009 02:03

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Set_item_property('Chasssis_no',DEFAULT_WHERE, 'unitid = '||''''||:global.unitid and Chassis_no||''''||' like ('||''''||%Chassis_no||'''''||')');

Report message to a moderator

Re: How to use the like clause in Where [message #404540 is a reply to message #404521]

Fri, 22 May 2009 03:24

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Even your coding also getting compilation error.

anyway i solved it

Set_Block_property('Chasssisitem',DEFAULT_WHERE, 'unitid = '||:global.unitid||' and Chassis_no like ('||''''||'%'||:Chassis_no||''''||')');

but nothing will work

suppose if i give 1202

it should reterive like %1202, is not comming (still value is there like that pattern in table)

kanish

[Updated on: Fri, 22 May 2009 03:35]

Report message to a moderator

Re: How to use the like clause in Where [message #404545 is a reply to message #404521]

Fri, 22 May 2009 04:03

mm_kanish05
Messages: 493
Registered: January 2007
Location: Chennai

Senior Member

Thanks

I solved it.

kanish

Report message to a moderator

Re: How to use the like clause in Where [message #404549 is a reply to message #404545]

Fri, 22 May 2009 04:30

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

... and it would be very nice of you if you shared the solution with the rest of the community, so that someone else (who has the same problem) learns something from it.

Report message to a moderator

Re: How to use the like clause in Where [message #404551 is a reply to message #404521]

Fri, 22 May 2009 04:34

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Yes I can see... forgotten to put % symbol in inverted commos...

By the way the food was cooked by someone else and you are saying I cooked it... very funny...

Report message to a moderator