V4MD query contain dot

[Ruslan Zasukhin]

on 12/5/03 7:03 AM, Ricky at ricky at babonmultimedia.com wrote:

> hello,
> 
> i have this query,it is no problem when idcat variable contain no 'dot'
> 
> but when there's 'dot' it return zero rows.ex idcat = "FU.TB" or "AC.SP"
> 
> "SELECT fd_Code,fd_Name,fd_Colour,fd_Size,fd_MinOrder,fd_blob FROM
> rdInventory WHERE fd_blob IS NOT NULL AND fd_Group=" & idcat
> 
> is there any suggestion for me?

Hi Ricky,

Yes, you have forget wrap it by quotes


"SELECT fd_Code,fd_Name,fd_Colour,fd_Size,fd_MinOrder,fd_blob FROM
rdInventory WHERE fd_blob IS NOT NULL AND fd_Group= '" & idcat & "'"
                                                    ^^^^^^^^^^^^^^

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------