Alaska Software Inc. - Re: COPY FROM IN SQL WITH Sql Statement.
Username: Password:
AuthorTopic: Re: COPY FROM IN SQL WITH Sql Statement.
Andreas Gehrs-Pahl

View the complete thread for this message in:

Re: COPY FROM IN SQL WITH Sql Statement.
on Fri, 11 Nov 2016 16:12:32 -0500
César,

You have a double quote character inside your literal string that is 
delimited by in double quotes. Use this instead:

cSql := "COPY ALBARANES FROM 'D:\PRUEBA3.csv' WITH DELIMITER ';' QUOTE '" + chr(34) + "';"

or possibly this:

cSql := [COPY ALBARANES FROM 'D:\PRUEBA3.csv' WITH DELIMITER ';' QUOTE '"';]

Hope that helps,

Andreas
Andreas Gehrs-Pahl
Absolute Software, LLC

phone: (989) 723-9927
email: Andreas@AbsoluteSoftwareLLC.com
web:   http://www.AbsoluteSoftwareLLC.com
[F]:   https://www.facebook.com/AbsoluteSoftwareLLC