Syntax error in UPDATE statement while using a Memo field 
Author Message
 Syntax error in UPDATE statement while using a Memo field

Hi,

I hope that this is the correct group to post this question, however am
having a problem that I can not seem to fix.  I have been working with it
for 3 days.

The problem is that one of my fields (the field named Text ) in my Access 97
database is a memo field. When I leave out this field from my Sql statement,
all runs fine.  However, when I add it I get the message "Syntax error in
UPDATE statement" . I've tried putting the Text field at the end of my
statement, and I've tried double single quotes and all types of
combinations.  There must be a way so that I can update a memo field.  Can
anybody help me?  Thank you in advance very much.

John

SqlText = "Update PressRelease Set Title='" & Title & "',Location='" &
Location & "',Text='" & Text & "' WHERE ID=" & Session("T0ID")



Sun, 21 Apr 2002 03:00:00 GMT
 Syntax error in UPDATE statement while using a Memo field

I think it is a wrong group for you, because here we talked about MSSQL
server 7.0. There are many other groups on Access.

But do check your Access 97 documentation to see if TEXT is a keyword.

Hope this help

Anthony



Quote:
> Hi,

> I hope that this is the correct group to post this question, however
am
> having a problem that I can not seem to fix.  I have been working
with it
> for 3 days.

> The problem is that one of my fields (the field named Text ) in my
Access 97
> database is a memo field. When I leave out this field from my Sql
statement,
> all runs fine.  However, when I add it I get the message "Syntax
error in
> UPDATE statement" . I've tried putting the Text field at the end of my
> statement, and I've tried double single quotes and all types of
> combinations.  There must be a way so that I can update a memo
field.  Can
> anybody help me?  Thank you in advance very much.

> John

> SqlText = "Update PressRelease Set Title='" & Title & "',Location='" &
> Location & "',Text='" & Text & "' WHERE ID=" & Session("T0ID")

Sent via Deja.com http://www.deja.com/
Before you buy.


Mon, 22 Apr 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Syntax error when updating Memo field in a view in VFP5

2. Updating data to a memo field using SQL UPDATE

3. What is the syntax for copy a memo to a database memo field

4. Using stored query statements within a Memo field

5. (0x80040E14) Syntax error in UPDATE statement.

6. (0x80040E14) Syntax error in UPDATE statement.

7. Syntax error in UPDATE statement

8. HE: Syntax Error in UPDATE statement

9. Syntax Error in Update Statement

10. Syntax error in UPDATE statement

11. Updating Memo Fields in MS Access using ADO Parameter / Stored Procedures

12. Using VB 3.0 to Update DBase III Memo Field


 
Powered by phpBB® Forum Software