- How to send UPDATEs from form's textarea to a database field?

S

S.B.S.

I have setup an Update form with Database Results Wizard and adjusted the
query to UPDATE the results:

"UPDATE mytable SET fname='::fname::', lname='::lname::', comments='::txt::'
WHERE iid=::id::"

fname - character field, linked to a textbox fname
lname - character field, linked to a textbox lname
comments - text(memo) field, linked to a textarea txt

The problem:
Upon submission of text edited in the editbox, an error is generated if the
text contains newline characters or the length of input exceeds 255. How can
this be fixed?

Here is the error itself:
-----------------------
Database Results Error
Description: [Microsoft][ODBC Visual FoxPro Driver]Command contains
unrecognized phrase/keyword.
Number: -2147217900 (0x80040E14)
Source: Microsoft OLE DB Provider for ODBC Drivers
------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pure Database Interface Wizard doesn't work 3
ms a2k jet database engine won't recognize field as valid 3
apostrophe in text field causing unexpected error 1
Please help....update database 1
Database editor not producing valid query 1
How can I place partial data from a field in a report? 3
How to get one field to update based on a selection from a drop do 2
ASP vs ASP.Net & database 2

Top