The only occurence of the string "bs" in your code is at the table name
LSOpenJobs
Maybe the DBI layer is not passing everything since there is a carriage return
after the SET?
HTH
Ken
jose isaias cabrera <[EMAIL PROTECTED]> wrote:
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]
-----------------------------------------------------------------------------
