CH Chee
|
| Posted: 02/17/2002, 12:40 AM |
|
System : CC 2.04/Win 2000/IIS5/MS Visual Foxpro ODBC Driver
Problem :
I've a DBF (Table) with a memo field. IN the Record Form, I've set it as a Text Area. If the input into this memo field is continuous, update=OK. But once I press enter ie hard carriage return to force a new line and enter more text, any update will result inthe following message
[Microsoft][ODBC Visual FoxPro Driver]Command contains unrecognized phrase/keyword. (Microsoft OLE DB Provider for ODBC Drivers)
Please assist.
|
|
|
 |
Nicole
|
| Posted: 02/18/2002, 4:34 AM |
|
Chee,
looks like Visual Fox Pro doesn't accept "vbCRLF" (carriage return). try to replace it with html <br> tag. Then when the field will be displayed on the form as Label you do not need to do the replacement. But when you'll display the field as TextArea you should replace <br> bak with vbCRLF.
In BeforeInsert/BeforeUpdate use:
fldfield_name = replace(fldfield_name, vbCRLF, "<br>")
In BeforeShow event when the memo field is displaying as TextArea (or textbox) use:
fldfield_name = replace(fldfield_name, "<br>", vbCRLF)
|
|
|
|
CH Chee
|
| Posted: 02/18/2002, 4:01 PM |
|
Hi Nicole
Thanx, I'll check it out and revert.
|
|
|
|
CH Chee
|
| Posted: 02/18/2002, 4:42 PM |
|
Hi Nicole
Your solution works !!!
Thanx !
|
|
|
|
|
