Can't Update Text or Memo field

[bluzegtr]

Can't Update Text or Memo field - using FP 2002 w/MSA DB backend.

For this one update I have 3 fields that are affected:
Numb - Number,double
Jobs - Number,double
Desc - Memo (also tried converting to text)

This portion works:
UPDATE TabA
SET Numb = '::Numb::', Jobs = '::Jobs::'
WHERE PRACTID = ':RACTID::'

If I add Desc:
UPDATE TabA
SET Numb = '::Numb::', Jobs = '::Jobs::', Desc = ':esc::'
WHERE PRACTID = ':RACTID::'

I get the following message:
****************
Server error: Unable to retrieve schema information from the query:

UPDATE TabA SET Numb = '1', Jobs = '2', Desc = '3' WHERE PRACTID = '4'

against a database using the connection string

DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/db2.mdb.

The following error message comes from the database driver software; it may appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217900 (0x80040e14)
************

I don't understand why I can update numeric fields but not text or memo. At one point in the past I converted a memo to text and was able to update.

Thanks


"I feel more like I do now than when I got here."
~ Defcon Moderator ~

 

[bluzegtr]

I have noted that I can update numeric fields and text fields that are set to length of 50. For text fields set at 255 length or for type=memo, I cannot update. Is there some constraint that I don't know about?

Don

"I feel more like I do now than when I got here."
~ Defcon Moderator ~

 

[bluzegtr]

I get the table to update the field with:

UPDATE TabA
SET TabA.Numb = '::Numb::', TabA.Jobs = '::Jobs::', TabA.Desc = ':esc::'
WHERE TabA.PRACTID = ':RACTID::'

I have not had to implicitly declare the table before. Why would I need to declare the table implicitly for text or memo fields but not for numeric fields?

The 'Desc' field is a description field. Some are blank so the user will need to add data. The problem is that when data is entered to update that record, a single comma is added each time the update is done. Why is that?

"I feel more like I do now than when I got here."
~ Defcon Moderator ~