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


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

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

  1. #1
    Abdul Muthalef Guest

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


    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





  2. #2
    Joe \Nuke Me Xemu\ Foster Guest

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

    "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!



  3. #3
    David Satz Guest

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

    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!
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center