LiveCode Forums.

Code: Select all

customer_id
first_name
last_name

Code: Select all

<name_day>
    <Onomastikes>
      <Month>4</Month>
      <Day>23</Day>
      <Name> George </Name>

Code: Select all

on mouseUp
 set the itemDelimiter to slash
    local tPreferencesFile
    put item 1 to -2 of the effective filename of this stack & "/birthdays.xml" into mypath
    --set the itemDelimiter to comma
    
    # Read the preferences data from the file into a variable. Always check for the result when reading files
    # as its possible that the file may have been deleted or moved.
    local tPreferencesData, tResult
    put url ("file:" & mypath) into tPreferencesData
    put the result into tResult
    if tResult is not empty then
        answer error "Failed to read preferences file at location: " & mypath
        return empty
    end if
    
put tPreferencesData into theXML
 replace cr with empty in theXML
  
  -- Convert xml to array. Store data in array as UTF8.
  put ConvertXMLToArray(theXML, "UTF-8") into theArray -- handler in RevOnline stack
  -- Convert to an array that can be assigned to the dgData of a Data Grid (numerically indexed).
  put SortArrayKeysWithXMLOrdering(theArray["birthdays"]) into theKeys -- handler in RevOnline stack
  put 0 into i
  repeat for each line theKey in theKeys
        add 1 to i
        put theArray["birthdays"][theKey] into theData[i]
  end repeat
  set the dgdata of group "datagrid1" to theData
  --breakpoint -- check values of arrays in debugger
end mouseUp

Code: Select all

on preOpenStack
  set itemDel to "/"
  set the defaultFolder to item 1 to -2 of (the effective fileName of this stack)
end preOpenStack

Code: Select all

On MouseUp
put revXMLCreateTreeFromFile("birthdays.xml",false,true,false) into XML-ID
#XML-ID is the id of a new xml tree
if the result is not empty then
        answer error "Failed to read preferences file"
         exit
    end if
#... your code
End MouseUp

Code: Select all

#create an array that KEY are names and values are dates
#all dates in array  formatted like DD-MM-YYYY or your system date
put the system date into today
put 0 into check
put false into verify
repeat for each item tempItem of myArray
   add 1 to t
   if tempItem = today then
      put true into check
      exit repeat
   end if
end repeat
if check then
   put myArray[t] into nameday
   answer "today is nameday of " & nameday
end if