Double Quotes (") is not working with PB7.0.3/MS- SQL 2000

[Abdul Muthalef]

Hi,

In my project, we're using PB 7.0.3 with backend MS- SQL 2000, In that,Datawindow
SQL values is not supporting double quotes(")

(It is working fine with PB6.5 with older version of MSSQL)

for example:

SELECT emp_id,Name from emp where emp_name = "Abdul"

Its giving invalid column name error. but if we change "Abdul" to 'Abdul'
then it is allow me to save.


Here we've 1000s of Datawindows to change like this.

Is there any to overcome this problem

Regards

Abdul Muthalef SM

[Joe \Nuke Me Xemu\ Foster]

"Abdul Muthalef" <abdulmajal@rediffmail.com> wrote in message <news:3e8c2345$1@tnews.web.devx.com>...

> In my project, we're using PB 7.0.3 with backend MS- SQL 2000, In that,Datawindow
> SQL values is not supporting double quotes(")
>
> (It is working fine with PB6.5 with older version of MSSQL)
>
> for example:
>
> SELECT emp_id,Name from emp where emp_name = "Abdul"
>
> Its giving invalid column name error. but if we change "Abdul" to 'Abdul'
> then it is allow me to save.
>
>
> Here we've 1000s of Datawindows to change like this.
>
> Is there any to overcome this problem

As a last resort, you could export the datawindows to text files,
write a small utility to convert strings delimited with " to ',
and then re-import the datawindows. Hey, it beats tweaking them
all by hand!

--
Joe Foster <mailto:jlfoster%40znet.com> Auditine Addict <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!

[David Satz]

SET QUOTED_IDENTIFIER OFF

"Joe "Nuke Me Xemu" Foster" <joe@bftsi0.UUCP> wrote in message
news:3e8c49f6@tnews.web.devx.com...
> "Abdul Muthalef" <abdulmajal@rediffmail.com> wrote in message
<news:3e8c2345$1@tnews.web.devx.com>...
>
> > In my project, we're using PB 7.0.3 with backend MS- SQL 2000, In
that,Datawindow
> > SQL values is not supporting double quotes(")
> >
> > (It is working fine with PB6.5 with older version of MSSQL)
> >
> > for example:
> >
> > SELECT emp_id,Name from emp where emp_name = "Abdul"
> >
> > Its giving invalid column name error. but if we change "Abdul" to
'Abdul'
> > then it is allow me to save.
> >
> >
> > Here we've 1000s of Datawindows to change like this.
> >
> > Is there any to overcome this problem
>
> As a last resort, you could export the datawindows to text files,
> write a small utility to convert strings delimited with " to ',
> and then re-import the datawindows. Hey, it beats tweaking them
> all by hand!
>
> --
> Joe Foster <mailto:jlfoster%40znet.com> Auditine Addict
<http://www.xenu.net/>
> WARNING: I cannot be held responsible for the above They're
coming to
> because my cats have apparently learned to type. take me away,
ha ha!
>
>