mysql to valentina

[Robert Mann]

Looking to convert this mysql script to valentina



revDatabaseColumnCount(curID)

revDatabaseColumnNames(curID)

revNumberOfRecords(curID) I think this one converts to
VTable_RecordCount(curID)

revDatabaseColumnNumbered(curID, c)

revMoveToNextRecord curID



 put revDatabaseColumnCount(curID) into colNum

  put empty into fld "Select"

  put revDatabaseColumnNames(curID) into colNames

  replace comma with tab in colNames

  replace tab with cr in colNames



  put revNumberOfRecords(curID) into recNum

  put recNum into fld "Counter"



  -- revMoveToLastRecord curID

  IF recNum > 0 THEN

    REPEAT recNum times

      put empty into tRec

      REPEAT with c = 1 to colNum

        put revDatabaseColumnNumbered(curID, c) & tab after tRec

      END REPEAT

      put tRec & cr after fld "Select"

      revMoveToNextRecord curID

      IF the result = false THEN exit REPEAT

    END REPEAT

  END IF



Thanks

Rob

Robert Mann
President
GP Racing LLC