ernesto
|
| Posted: 11/12/2002, 3:29 AM |
|
hi there!
still trying to fill my MEMO-Fields from a current form and get this message:
---
Source: Record RedAct1 / Update Operation
Command Text: UPDATE RedAct SET Text=?, Klappentext=?, FusszeilenText=? WHERE ID = 5
Error description: Syntaxfehler in UPDATE-Anweisung. (Microsoft JET Database Engine)
UPDATE RedAct SET Text=?, Klappentext=?, FusszeilenText=? WHERE ID = 5
---
so the MEMO-field is not inserted correct. It seems that there is a bug in handling such memo-fields. A friend of mine told me to change the order of the fields, but it still doesn't work ...
please help!
greetings from austria
ernesto
|
|
|
 |
DataObjx
|
| Posted: 11/13/2002, 7:44 AM |
|
This is a rough guide, since I am unable to reference one of my projects right now, but... also I haven't looked at the code yet, but it's likely that for one a Unicode convert is going down and for the other type it's not.
Nevertheless, there should be sufficient clues here to get you on your way.
Input Params - Memo field vs. Text Field
I have found that when using an MS Access Database, you use the Memo field.
[Another thing, If you're using MS Access and a Memo field, Open the table, click on the Memo field and in the properties area try changing 'Allow Zero Length' to True to see what effect you get.]
If you are using MS SQL Server, you need to reset them to a Text Field.
For instance,
If you're using SQL Server and you indicate that it is a Memo Field you'll get the error you described. Try changing the Input Box to a Text Field. That should fix the problem.
Output Values - Text vs. HTML
Experiment with the displayed output of each field type by performing the following;
Add a record to the database. Populate the Input Box with a couple of paragraphs that contain carriage returns, etc.
Then set the field that displays InputBox Text to display as 'text'.
View the record in the browser.
Next, set the field that displays InputBox Text to display as 'HTML'.
View the record in the browser. - Notice that you'll loose the paragraph formatting.
|
|
|
|
Nicole
|
| Posted: 11/14/2002, 6:50 AM |
|
Ernesto,
The simple suggestion is you have set up incorrect data type for the field. It should be Memo for memo fields.
Also have you tested any CCS examples where with Memo fields? Do they work for you? If yes, then it means that the problem is with field settings.
|
|
|
|
|
