Announcement

Collapse
No announcement yet.

Funciones SQLServer en scriptcase

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Funciones SQLServer en scriptcase

    SELECT * FROM SCfn_compras('01/07/2013','01/08/2013')
    Genera el siguiente error:

    Error
    Se produjo un error al acceder a la base de datos
    Incorrect syntax near '01/07/2013\'.
    select count(*) from SCfn_compras(\'01/07/2013\',\'01/08/2013\')

    Igualmente si uso variables:

    SELECT * FROM SCfn_compras([fchInicial],[fchFinal])

    Error
    Se produjo un error al acceder a la base de datos
    Incorrect syntax near '01/07/2013\'.
    select count(*) from SCfn_compras(\'01/07/2013\',\'01/08/2013\')

  • #2
    Hello,

    Is this the SELECT you used on a Grid application -> SQL? Or are you calling a function through sc_lookup()?

    regards,
    Bernhard Bernsmann

    Comment


    • #3
      Originally posted by bartho View Post
      Hello,

      Is this the SELECT you used on a Grid application -> SQL? Or are you calling a function through sc_lookup()?

      regards,
      Bernhard Bernsmann
      Si, es el SELECT que se usa en la aplicación GRID en el campo de texto SQL.

      Comment


      • #4
        Hello,

        Issue reported to our bugs team.

        regards,
        Bernhard Bernsmann

        Comment

        Working...
        X