79120572

Date: 2024-10-24 06:17:34
Score: 0.5
Natty:
Report link

I finally got this solution. It works. And yes, it is for Indusoft o Aveva Edge.

Function getColumnNames(tableName)
    Dim sql, numCur, numRows, row, txt
    sql ="Select name FROM sys.columns WHERE object_id = OBJECT_ID('" & tableName & "') ORDER BY column_id Asc"
    numCur = $DBCursorOpenSQL("sqlExpress", sql)
    numRows = $DBCursorRowCount(numCur)

    For row=1 To numRows
      $namesInDB[row-1] =  $DBCursorGetValue(numCur,"name")
      $DBCursorNext(numCur)
    Next

    $variablesInDB = numRows
    $DBCursorClose(numCur)
   
End Function
Reasons:
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: user27926789