Home » Developer & Programmer » Forms » How to use the like clause in Where (FORM 6i)
How to use the like clause in Where [message #404521] Fri, 22 May 2009 01:39 Go to next message
mm_kanish05
Messages: 487
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
icon12.gif  Re: How to use the like clause in Where [message #404524 is a reply to message #404521] Fri, 22 May 2009 01:46 Go to previous messageGo to next message
azamkhan
Messages: 548
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
Re: How to use the like clause in Where [message #404527 is a reply to message #404521] Fri, 22 May 2009 01:59 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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
icon12.gif  Re: How to use the like clause in Where [message #404529 is a reply to message #404521] Fri, 22 May 2009 02:03 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Set_item_property('Chasssis_no',DEFAULT_WHERE, 'unitid = '||''''||:global.unitid and Chassis_no||''''||' like ('||''''||%Chassis_no||'''''||')');
Re: How to use the like clause in Where [message #404540 is a reply to message #404521] Fri, 22 May 2009 03:24 Go to previous messageGo to next message
mm_kanish05
Messages: 487
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 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Thanks

I solved it.

kanish
Re: How to use the like clause in Where [message #404549 is a reply to message #404545] Fri, 22 May 2009 04:30 Go to previous messageGo to next message
Littlefoot
Messages: 20888
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.
Re: How to use the like clause in Where [message #404551 is a reply to message #404521] Fri, 22 May 2009 04:34 Go to previous messageGo to next message
azamkhan
Messages: 548
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...
Re: How to use the like clause in Where [message #404583 is a reply to message #404551] Fri, 22 May 2009 06:47 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
azamkhan wrote on Fri, 22 May 2009 11:34
By the way the food was cooked by someone else and you are saying I cooked it... very funny...

Could you, please, translate it into English?
Re: How to use the like clause in Where [message #404701 is a reply to message #404521] Fri, 22 May 2009 22:13 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear LittleFoot...

The one how should understand I think has understand what I was trying to say...
Re: How to use the like clause in Where [message #404702 is a reply to message #404521] Fri, 22 May 2009 22:31 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi azamkhan,

You are the key person to achieve this. Thank you.

kanish
Re: How to use the like clause in Where [message #404713 is a reply to message #404521] Sat, 23 May 2009 00:37 Go to previous message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
your welcome
Previous Topic: Check Box Like Tab Canvas
Next Topic: "FRM-41042 no such property for set_item_property"
Goto Forum:
  


Current Time: Fri Dec 02 23:00:13 CST 2016

Total time taken to generate the page: 0.07981 seconds