Inconsistent results in simple script
johnpatten at me.com
Wed Nov 16 15:43:28 EST 2016
I have about 1000 students that are in a library system showing them as having checked out an iPad. In the library system it uses the student username and the barcode as the item identifier.
I have another list that shows our iPads by barcode and serial number.
Unfortunately there is no way for me to pull a report that shows the student username and the device serial number in one report. So I was essentially searching for the barcode in both lists and then combining the username from one and the serial number from the other. Ultimately ending up with a list that consists of student username and device serial number.
I hope that is a little clearer.
> On Nov 16, 2016, at 12:22 PM, dunbarx <dunbarx at aol.com> wrote:
> So, a single list. What is the relationship between the fact that a
> particular barcode refers both to a student and a serial number? In other
> words, if you had a single list, how would "12345" relate to both "john doe"
> and "SDTKNY12345"?
> Would you simply have two lines:
> Also, I do not understand what you mean when you said:
> "I have cut my username list down to about 30."
> Does that mean that in your 1000 line first list, the usernames appear with
> multiple barcodes? Or are those lines empty? Or is that list now only 30
> lines long?
> It looks like this begs for an array, but I am missing what you expect as
> output. Whatever it is, the procedure will be simple. But I cannot even
> start to advise about that procedure until I know what the answer is.
> View this message in context: http://runtime-revolution.278305.n4.nabble.com/Inconsistent-results-in-simple-script-tp4710376p4710377.html
> Sent from the Revolution - User mailing list archive at Nabble.com.
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode