[V4MD] SELECT with AND syntax

[Irv Kalb]

Thanks Florian.  I added single quotes around the 
second string - and that did it.

Irv

At 8:33 PM +0200 9/20/08, Florian Bogeschdorfer wrote:
>"HI" is a string and my guess would be to put it in '' :
>
>... ='HI')"
>
>best
>
>Florian Bogeschdorfer
>——————————————————————————————
>e-mail  fb at memedia.de
>fon(E)  +34 680 75 19 77 (nur bei Aufenthalt in Spanien)
>fon(D)  +49 173 58 44 26 0 (nur bei Aufenthalt außerhalb Spaniens)
>skype   florian.bogeschdorfer
>skype.in  +49 561 98 77 84 0
>——————————————————————————————
>m e m e d i a
>Agentur für Neue Medien
>Weinbauernstraße 12a
>D-81539 München
>
>e-mail         info at memedia.de
>fon            089 – 21 90 98 0 - 0
>fon direct     089 – 21 90 98 0 - 16
>fax            089 – 21 90 98 0 – 99
>—————————————————————————————
>
>
>>-----Original Message-----
>>From: valentina-bounces at lists.macserve.net [mailto:valentina-
>>bounces at lists.macserve.net] On Behalf Of Irv Kalb
>>Sent: Saturday, September 20, 2008 8:29 PM
>>To: Valentina Developers
>>Subject: [V4MD] SELECT with AND syntax
>>
>>Hi,
>>
>>I need help with SQL syntax on what should be a simple SELECT
>>statement.  I want to select all records from a table where one field
>>equals one value and another field equals another value,  The value
>>of the first field may have spaces in it, and I found though
>>experimentation that I need to enclose such fields with single quote
>>characters.  Here's what I am trying:
>>
>>on mMatchLabelAndMovie me, theCurrentLabel, theCurrentMovie
>>
>>    cursor = poDB.SqlQuery("SELECT * FROM Main where (FrameLabel = " &
>>"'" & theCurrentLabel & "'" & ")" & " AND (MovieName = " &
>>theCurrentMovie & ")")
>>
>>...
>>end
>>
>>The specific query string that gets built from the first time this is
>>called is this:
>>
>>"SELECT * FROM Main where (FrameLabel = '#E1_Goals: The Presence of
>>the Past') AND (MovieName = HI)"
>>
>>This looks right to me, the values are exactly what I want to find,
>>and I know that there is a single record that matches this criteria.
>>
>>But when I execute this, I get back this:
>>
>>[#errNumber: 333056, #errNumberHex: "0x51500", #errString:
>>"Identifier "HI" is not found."]
>>
>>I'm hoping that someone can tell me what's wrong with my SQL syntax here.
>>
>>If it helps, I'm trying to convert this from V12, and my calls to get
>>this information from V12 were like this:
>>
>>    --  mSetCriteria(pxTableMain, "FrameLabel", "=", theCurrentLabel)
>>    --  CheckV12Error()
>>    --  mSetCriteria(pxTableMain, "and", "MovieName", "=", theCurrentMovie)
>>    --  CheckV12Error()
>>    --  mSelect(pxTableMain)
>>    --  CheckV12Error()
>>
>>
>>Thanks,
>>
>>Irv
>>
>>--
>>
>>Multimedia R Us
>>_______________________________________________
>>Valentina mailing list
>>Valentina at lists.macserve.net
>>http://lists.macserve.net/mailman/listinfo/valentina
>
>_______________________________________________
>Valentina mailing list
>Valentina at lists.macserve.net
>http://lists.macserve.net/mailman/listinfo/valentina


-- 

Multimedia R Us