LiveCode Forums.

Code: Select all

## Connect to the current open DB. This goes into a preOpen or open stack script
   put specialFolderPath("documents") & “/MyDatabase.sqlite" into tDatabasePath
   put revOpenDatabase("sqlite", tDatabasePath, "binary,extensions") into tDatabaseID
   set the uDatabaseID of this stack to tDatabaseID

## This is code for calling the Db ID. See the second line
      put "SELECT FigureID, Condition, theDescription, bCodeNum FROM " & theCollection into tSQLStatement
      put revDataFromQuery(tab,cr, (the uDatabaseID of this stack) ,tSQLStatement) into tData

Code: Select all

 put gDatabaseID into gApplicationnameV01["gDatabaseID"]

Code: Select all

// This code comes from a button, the function is an existing script from livecode tutorials. it could be simplified for this purpose.
global gApplicationnameV01
on mouseUp
  answer displayArrayData (gApplicationnameV01)
end mouseUp
 
 function displayArrayData pArray, pIndent
    # create the variable that loops through the keys in the array
    local tKey
    if pArray is an array then
        # print information to indicate that we are entering a new nested level of the array
        get "Array" & return
        # print full stops that allow the reader to track the depth of an element
        put "." after pIndent
        # create the indentation
        put tab after pIndent
        repeat for each key tKey in pArray
            # call displayArrayData with a nested array
            put format("%s[%s] => %s\n", pIndent, tKey, displayArrayData (pArray[tKey], pIndent)) after it
        end repeat
        delete the last char of it
        return it
    else
        return pArray
    end if 
end displayArrayData

Code: Select all

set the cMyGlobalVar of this stack to "InfoInMyGlobalVar" 

Code: Select all

   put the cMyGlobalVar of this stack into testvar
   answer "cMyGlobalVar = " & testvar

Code: Select all

put the someProperty of stack notThisStack...