mysql to valentina

Robert Mann robmann at gp-racing.com
Tue Dec 26 19:06:51 CST 2006


I trie this but I get an error

  put VDatabase_Constructor() into mDatabase

  get the effective filename of this stack

  set the itemdel to slash

  put the (item 1 to -2 of it) & slash & "snspringcalc" into dbPath

  get VDatabase_Open( mDatabase, dbPAth )

  put VDatabase_Table( mDatabase, "wt_brands" ) into curID

  put revDatabaseColumnCount(curID) into colNum

  put empty into fld "Select"

  put revDatabaseColumnNames(curID) into colNames

  replace comma with tab in colNames

--  put colNames into fld "Select headers"

  replace tab with cr in colNames

--  put colNames into fld "New headers"

--  put empty into fld "New record"



  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 revDatabaseColumnNamed(curID, line c of colNames) & tab after
tRec

        put revDatabaseColumnNumbered(curID, c) & tab after tRec

      END REPEAT

      put tRec & cr after fld "Select"

      --put tRec & cr after fld "Select springcalc"

      -- revMoveToPreviousRecord curID_

      revMoveToNextRecord curID

      IF the result = false THEN exit REPEAT

    END REPEAT

  END IF

  delete last char of fld "Select"




Robert Mann


-----Original Message-----
From: valentina-bounces at lists.macserve.net
[mailto:valentina-bounces at lists.macserve.net]On Behalf Of Ruslan
Zasukhin
Sent: Tuesday, December 26, 2006 6:17 PM
To: valentina at lists.macserve.net
Subject: Re: mysql to valentina


On 06/27/12 1:05 AM, "Robert Mann" <robmann at gp-racing.com> wrote:

Hi Robert,

> Looking to convert this mysql script to valentina

In fact this is RevDB API, right?

Do you know that V4REV also support it?

Although yes using of Native Valentina API can be more powerful.


--
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]


_______________________________________________
Valentina mailing list
Valentina at lists.macserve.net
http://lists.macserve.net/mailman/listinfo/valentina



More information about the Valentina mailing list