quick newline question for a noob
-
I'm starting out with database programming in C# (using System.Data.Odbc). I have an SQL command, using the UPDATE command. I'm trying to update a memo field (in an .mdb file) with contents that have multiple lines of text. However, I keep getting an error. I can see what the error is saying (that it doesn't like me starting a line without an SQL command). How do I modify the following example so that it will work? UPDATE mytable SET pagecontents = 'first line of text second line of text third line of text' WHERE id = 3 The error basically says: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "second line of text thirdline of text'
-Daniel Typing too fast fro my owngood
-
I'm starting out with database programming in C# (using System.Data.Odbc). I have an SQL command, using the UPDATE command. I'm trying to update a memo field (in an .mdb file) with contents that have multiple lines of text. However, I keep getting an error. I can see what the error is saying (that it doesn't like me starting a line without an SQL command). How do I modify the following example so that it will work? UPDATE mytable SET pagecontents = 'first line of text second line of text third line of text' WHERE id = 3 The error basically says: ERROR [42000] [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression "second line of text thirdline of text'
-Daniel Typing too fast fro my owngood
Basically, I need to find out how to put multiple lines of text into a memo field. The text may or may not have apostrophes, quotes, backslashes, and other characters that usually require special treatment in other circumstances. Anyone?
-Daniel Typing too fast fro my owngood
-
Basically, I need to find out how to put multiple lines of text into a memo field. The text may or may not have apostrophes, quotes, backslashes, and other characters that usually require special treatment in other circumstances. Anyone?
-Daniel Typing too fast fro my owngood