From koffice-devel  Sat Jul 26 12:33:30 2003
From: Lucijan Busch <lucijan () kde ! org>
Date: Sat, 26 Jul 2003 12:33:30 +0000
To: koffice-devel
Subject: Re: [Patch] A little patch for kexi
X-MARC-Message: https://marc.info/?l=koffice-devel&m=105922291218796

hi,

On Friday 25 July 2003 11:05, Malte Starostik wrote:
> On Wednesday 23 July 2003 21:47, Adam Pigg wrote:
> > Hi
> >
> > seeing as you kexi developers are living in mysql land i thought better
> > let you have this patch.
> >
> > It may be incomplete, but ive searched the sources for lines that need
> > changed so it shouldnt be too bad, and it wont affect anything for you
> > anyway, but it will halp me in postgresql land :o)
> >
> > What it does:
> > Adds a virtual function to kexidb.h - escapeName - this returns a quoted
> > version of a table name, currently it is hardcoded to a ` character, but
> > postgresql uses a " and thus all queries fail.
>
> I haven't used mysql nor postgresql for some time, so this is rather
> theoretical. Isn't " the standard quote character for delimited names per
> ANSI  SQL? " is for object names, ' for string literals AFAIR (yes I do
> know that many RDBMS don't care too much about ANSI). Still, wouldn't mysql
> understand " just as well?
nope it doesn't

btw thanks adam will apply the patch now...

> Cheers,
> -Malte

-- 
kexi -- http://www.koffice.org/kexi
_______________________________________________
koffice-devel mailing list
koffice-devel@mail.kde.org
http://mail.kde.org/mailman/listinfo/koffice-devel