Its text. I thought you were on to something there...
Can you think of any way to figure out the number of records in a
found set in a different fashion? If I can find out the number of
found records without dealing with the list command we were
discussing, I can probably work around this, but I don't know of any
other way.
More wierdness --
set my_list to cell "InvoiceID" of (every record of table "Invoices"
whose cell "Status" is equal to "Open") fails if there is one found
record (displaying the characters of the found cell as a list
{"1","0","0"}) thing, but it works OK if there are 2 or more found
records. Bizarre.
Thanks
Chris
On Jan 25, 2007, at 8:59 PM, Tim Mansour wrote:
On 26/01/2007, at 7:01 am, Chris Prew wrote:
The code Tim sent me below works (thanks!), but its having
problems -- I think its more with the data type than with Filemaker.
What field type is InvoiceID? If not Text, what happens if you
change it to Text?
