One more question on this... What if I don't send UTF-8 characters?
From: "Ken" who said,
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]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------