Re: SQL Server Unclosed Quotes Error Message


I'm not 100% sure that I have an answer for you because the question leaves a lot to the imagination, but if your stored proc requires parameters and one or more of them is a string AND you are populating the parameters at runtime, are you enclosing them in two single quotes?? Delphi will interpret a single quote as a string delimiter... you must use multiples of the single quote to have the (one) single quote passed to your parameter (e.g. MyString := '''Parm1''';) This will result in Delphi assigning 'Parm1' to MyString and that can be used to assign your parameter.

If I have missed (not understood) your issue, please respond with a little more detail so someone can help you.

Regards

"Shekar" <shekar@xxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Hi,
> I am accessing SQL Server 2000 through ADO using D5.
>Executing certain stored procedures randomly generate exception with
>following message:
>
>Unclosed quotation mark before the character string ''
>
>Sometimes '' is replaced by junk chars. But if i execute the same procedure
>call statement thru Query Analyser, it goes thru.
>
>Can someone tell me what could the problem?
>
>Regards
>Shekar
>
>
>

.

Relevant Pages

  • Re: error executing sprocedure
    ... >SQL Server MVP ... >executing this procedure sql reports one error. ... >input paramenter to the stored procedure but if the number ... >Best regards ...
    (microsoft.public.sqlserver.server)
  • Re:
    ... I am executing a file in Directory C which is importing a file f' in directory ... >> Regards, ... >> Jatinder Singh ... >>> Tiago S Daitx ...
    (comp.lang.python)
  • Re: [PHP] keyword search syntax
    ... > like a primitive search engine. ... > best regards ... FULLTEXT index and executing a MATCH... ...
    (php.general)
  • Re: Closing methods
    ... then your code executing after the select is odd? ... I have a funny problem when closing files from a macro outside the file ... I have in my Personal.xls a macro called Close_files. ...
    (microsoft.public.excel.programming)
  • Re: How to configure Log shipping on SQL server 2000 developer edi
    ... I am getting problem in executing the following commands. ... > I have now successfully configure Log shipping on developer edition. ... > getting some error on executing the stored procedure on the secondary server. ... > With regards, ...
    (microsoft.public.sqlserver.replication)
Loading