Greetings!

I have developed an application that uses a local and a shared folder SQLite3 DBs and the D SQLite3 wrapper is failing on execute commands. For example, this UPDATE command,

UPDATE LSOpenJobs SET

    ProjID = '871',
    subProjID = '865',
    parent = '209',
    children = '',
    login = 'id999999',
    cust = 'CoCo',
    proj = 'Tape Binder OpMan',
    PClass = 'Quote',
    PSubClass = 'PM',
    bdate = '2007-12-05',
    ddate = '2007-12-05',
    edate = '',
    pm = 'josé',
    pmuk = 'First, Name',
    lang = 'de-DE',
    vendor = '',
    vEmail = '',
    invoice = '0.0',
    ProjFund = '177',
    PMTime = '1.50',
    A_No = 'B9OPMSL0',
    wDir = 'D:\Projects\CoCo\000871-CoCo-Tape-Binder-OpMan\Quote',
    BiliDir = '',
    TMDir = 'T:\Projects\_TMs\CoCo-TMs\actual',
    DeliveryDir = '',
    paid = 'n',
    paidDate = '',
    notes = 'Operator Manual',
    status = 'o',
    pages = '',
    ta = '',
    fromLang = 'en-US',
    techPM = '',
    termPM = '',
    Xtra0 = '',
    Xtra1 = '',
    Xtra2 = 'y' WHERE id = 1601;

threw an exception,

DBIException: near "bs": syntax error

as you can see, there is no syntax error above. What I would like to do is to turn on some debuging utility inside the DBs to see what it is receiving and why the DB is refusing the execute call, if it is, at all. I will post this problem to the DDBI newsgroup and see if they also could help me.

Any help or ideas are appreciated.

thanks,

josé

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to