This topic is locked

WHERE CLAUSE

7/13/2008 8:15:30 PM
PHPRunner General questions
A
Aleix author

Hello, I am using the PHPRunner 4 day´s ago! I am a novell user
I want use the WHERE CLAUSE in the Lookup wizard.
I have a Lookup table Cia whit the field
IdCia

IdSede
I want choose the IdSede < 2
I try with

IdSede < 2

IdSede < '2'

IdSede < "2"

"IdSede < 2"

$IdSede < 2

and anothers, but they dosen´t work
Can you give some examples? Which is my mistake?
Many Thanks in advance

H
horsey_kim 7/13/2008

Hello, I am using the PHPRunner 4 day´s ago! I am a novell user

I want use the WHERE CLAUSE in the Lookup wizard.
I have a Lookup table Cia whit the field
IdCia

IdSede
I want choose the IdSede < 2
I try with

IdSede < 2

IdSede < '2'

IdSede < "2"

"IdSede < 2"

$IdSede < 2

and anothers, but they dosen´t work
Can you give some examples? Which is my mistake?
Many Thanks in advance


I would of thought this one work "IdSede < 2"
Try "IdSede < '2'"
Kim <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=30997&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

A
Aleix author 7/14/2008



I would of thought this one work "IdSede < 2"
Try "IdSede < '2'"
Kim <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=31005&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />


Hello Kim;
It work´s!
I did not try this option! In another hand I have tried with more complex expression like
"((IdRSedeTipo ='4') or (IdRSedeTipo ='3'))"
And it work´s too!
Kim many Thanks for your help!