On 10/3/06, Adrian Maier <[EMAIL PROTECTED]> wrote:
On 10/3/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
>
> On Tue, 3 Oct 2006, Adrian Maier wrote:
>
> > On 10/3/06, Michael Van Canneyt <[EMAIL PROTECTED]> wrote:
> > > > Any idea how should i quote the arguments so that they would be properly
> > > > treated by TProcess?
> > >
> > > You can't. The following lines (line 107 of unix/process.inc)
> > > Result:=StringReplace(Result,'"','',[rfReplaceAll]);
> > > Result:=StringReplace(Result,'''','',[rfReplaceAll]);
> > > Will strip all quotes inside a quoted string.
> > >
> > > Obviously, this is a bug.
> >
> > It's a painful one. I was hoping to switch to TProcess instead of shell (
> > which isn't cross-platform ) ...
>
> The bug won't occur on windows :)
> I will see about fixing it. Could you please post a bug report so it won't
> be forgotten.
Hello guys,
Luckily I have discovered a workaround . It is possible to add the
simple quotes
later, inside the sql script. So, it is ok to run something like :
psql -f abc.sql -v DATE1=1-jan-2006
if I add at the beginning of the script:
\set DATE1 '\'':DATE1'\''
Chers !
Adrian Maier
_______________________________________________
fpc-pascal maillist - fpc-pascal@lists.freepascal.org
http://lists.freepascal.org/mailman/listinfo/fpc-pascal
