Problem with MEMO in DB Access

General
1

Hello group, one of my usual problems. I have a MEMO field of an Access DB… I want to update it in case there is new information or leave it empty…

rows.EditRow
if TextField10.Text="" then    
  rows.Column("Note").StringValue=""
else
  rows.Column("Note").StringValue=TextField10.Text.ConvertEncoding(Encodings.WindowsANSI)
end if
rows.SaveRow

The error is:
[Microsoft][Driver ODBC Microsoft Access] Errore di sintassi nell’istruzione UPDATE.

WHY ?

2

Inglese

the problem is that you have christened your column “Notes”. This is a reserved word of SQL… access makes you create the column, but if you run SQL query it gives you error… DAYS TO FIND THIS THING YEARS AGO! :slight_smile: since then I’ve been programming using my (I think our) language, Italian, so I call a “note” field “appunti” :slight_smile: joking aside, you can simply call it “note1”, you see…

3

Thanks Ant…I’ll change the name of the column…

mi stavo a ricongli… :slight_smile:

1 Like