Re: [sqlite] 4invalid UTF-8 sequence
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 = 'id99', 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] -
Re: [sqlite] 4invalid UTF-8 sequence
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 = 'id99', 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] -
[sqlite] 4invalid UTF-8 sequence
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 = 'id99', 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] -