Answer Thedata not yelling all selected columns

[PeterG]

Hy Guys
My apologies for the spelling above it was meant to be "yielding all selected columns"
I am toying with converting database cursor into an array.
This is the code i want to put in an Answer dialog.

answer theDataA["DELEGATEIOD"] && theDataA["FIRSTNAME"] && theDataA["SURNAME"]

but it does not show the DelegateOID field which is part of the selection.
Kindly see the images attached.

There must be something I am doing wrong
Would appreciate any pointers

Many thanks
Peter G

[Ajm]

In the code snippet you have DELEGATEIOD and not DELEGATEOID.

[PeterG]

Hi Andy
This is what to little sleep does.
Embarrassed

Many Thanks
Peter G

[bogs]

Embarrassed

I wouldn't be, that happens to everyone. Merry Christmas all

[Ajm]

Happens to us all. Merry Christmas.

[PeterG]

Thanks guys for all your patience with my ignorance....

Many Thanks
Peter G

[quailcreek]

We haven't seen the rest of your code but here's a little function that should do the conversion you want.

Code: Select all

function turnRecordsIntoArray pData
  local tHeaders,theKey
  
  put "DELEGATEOID" & tab & "INITIALS"  & tab & "FIRSTNAME" & tab & "SURNAME" into tHeaders 
  --   replace "xmlerr, can't find element" with "" in theData
  set the itemDelimiter to tab 
  repeat with x = 1 to the number of lines in pData
    repeat with y = 1 to the number of items in tHeaders 
      put item y of line x of pData into theKey[x][item y of tHeaders] 
    end repeat 
  end repeat 
  set the itemDelimiter to comma
  return theKey
end turnRecordsIntoArray 

[PeterG]

Thank you Tom and the rest of the guys for the feedback.

Many Thanks
Peter G