Re: CRLF for memo fields in SQL statement

From: Dmitri Ivanov (divanov_NOSP_at_M_.aha.ru)
Date: 06/24/04

  • Next message: Dmitri Ivanov: "Re: SQLConnect or SQLConnectW" 
    Date: Thu, 24 Jun 2004 09:58:03 +0400

    Hello SqlJunkies,
    "SqlJunkies User" <User@-NOSPAM-SqlJunkies.com> wrote:

    SU> OK - I've moved on a little.
    SU>
    SU> I'm now building the string as follows...
    SU>
    SU> 'insert into a_table values('abc',123,'line
    SU> one'+Char(13)+Char(10)+'line two')
    SU>
    SU> Which works in SQL Server, but gives me an 'File 'char.prg' does
    SU> not exist.' error.
    SU>
    SU> Is this a Foxpro thing? Is it because I am accessing it as a free
    SU> table instead of through a DBC?
    SU>
    SU> Please help!

    It is always safer to pass such strings via parameter or cursor update
    rather than through an SQL sentence. 

    --
Sincerely,
Dmitri Ivanov
Common Lisp ODBC interface - www.ystok.ru
  • Next message: Dmitri Ivanov: "Re: SQLConnect or SQLConnectW"

    Relevant Pages

    • Re: Cannot Generate SSPI Context - help
      ... I have used the following DSN-less string: ... Microsoft OLE DB Provider for SQL Server error '80004005' ... When a connection is "trusted," it means ... > How would one connect to a remote SQL Server using Windows authen? ...
      (microsoft.public.inetserver.asp.db)
    • Re: INSERT Query problem with Quotes & Apostrophes
      ... I've got front-ends that go against both Jet and SQL Server databases. ... InputText As String, _ ... >> Delimiter, Delimiter & Delimiter) ... dDateTime, ...
      (microsoft.public.access.modulesdaovba)
    • Re: ADO.NET 2.0 saving single space to SQL?
      ... It is code someone else wrote quite some time ago and all of the string ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ...
      (microsoft.public.dotnet.framework.adonet)
    • Re: using OpenXML in T-sql?
      ... am not the most senior person in sql server programming, ... especially xml stuff. ... style string in place of an array without the additional ... >delimited strings and opts for the xml string instead. ...
      (microsoft.public.sqlserver.programming)
    • Re: Batches
      ... ExecuteNonQuery will send the string as is, ... execute the commands, but end effect is the same. ... command, and you do ExecuteNonQuery of that string, you will see one batch submitted to SQL Server. ...
      (microsoft.public.sqlserver.programming)