V4MD query contain dot

Ricky ricky at babonmultimedia.com
Fri Dec 5 13:03:41 CST 2003


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?

Thanks

Ricky



More information about the Valentina mailing list