Post reply

select statement

  • March 3, 2009 at 3:08 pm

    #135138

    hi friends

    i have this :

    Execute('Select 1 as [Test],* From myTable')

    how can put a character instead 1 in column Test !?

    i try this,but has error :

    Execute('Select "A" as [Test],* From myTable')

  • March 3, 2009 at 3:11 pm

    #952742

    dr_csharp (3/3/2009)

    hi friends

    i have this :

    Execute('Select 1 as [Test],* From myTable')

    how can put a character instead 1 in column Test !?

    i try this,but has error :

    Execute('Select "A" as [Test],* From myTable')

    Double the single quotes

    Execute('Select ''A'' as [Test],* From myTable')


    * Noel

  • March 3, 2009 at 3:12 pm

    #952743

    Doubled single quotes rather than double quotes.

    [font="Courier New"]EXECUTE('Select ''A'' as [Test],* From myTable')[/font]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply