Problem SQL ADO

infidel saint.infidel at gmail.com
Tue Sep 27 15:41:56 EDT 2005


> "SELECT
> VA_MK_YEAR,VA_MK_DESCRIP,VO_VIN_NO,VO_MODEL,VO_BODY,VO_DESCRIPTION" + \
>     "FROM D014800 LEFT OUTER JOIN D014900 ON (VA_MK_NUMBER_VER =
> VO_MAKE_NO) AND (VA_MK_YEAR = VO_YEAR)" + \
>     "WHERE (((VA_MK_YEAR)=?) AND ((VA_MK_DESCRIP)=?) AND
> ((VO_MODEL)=?))"

Doesn't look like you have a space between "VO_DESCRIPTION" and "FROM"

SQL statements are a good place to use Python's triple-quote feature:

sql = """\
SELECT
    VA_MK_YEAR, VA_MK_DESCRIP, VO_VIN_NO,
    VO_MODEL, VO_BODY, VO_DESCRIPTION
FROM
    D014800
    LEFT OUTER JOIN
    D014900 ON (
        VA_MK_NUMBER_VER = VO_MAKE_NO AND
        VA_MK_YEAR = VO_YEAR
    ) 
WHERE VA_MK_YEAR = ?
AND VA_MK_DESCRIP = ?
AND VO_MODEL = ?
"""




More information about the Python-list mailing list