Sounds like a refresh issue. Bob
On Jan 7, 2011, at 4:10 AM, Ian McKnight wrote: > A click on the target field made the list appear as it should! While my > table only contains 90 lines of 3 items I'm at a loss to explain this. > However, it is working as it should. > > Thanks > > On 7 January 2011 10:46, Ian McKnight <[email protected]> wrote: > >> Hi >> >> I have a table of data held in a table in EXCEL and I want to import it >> into a field in a LC stack. >> I saved the file from EXECL as a tab delimited text file >> and used the following handler >> >> * >> >> on >> *mouseUp >> >> *answer* file "choose" with *type* "text|txt|TXT" >> >> *if* it is empty or it is *cancel* *then* *exit* mouseup >> >> *put* "file:"&it into fName >> >> *put* URL fName into fld "display" >> * >> >> end >> *mouseUp >> The stange thing is that this doesnt appear to work - I get a blank field. >> However if I open and save the text file in NotePad or WordPad and then run >> the handler I get the data displayed in the field correctly. >> >> So how do I get the text file to be recognised without putting it through >> Notepad? What does EXCEL do to the file that NotePad doesn't? I'm using LC >> 4.5.1 and have also tested this on Rev Enterprise 4.0 both on Windows (Win 7 >> and XP) >> >> -- >> Regards >> >> >> Ian McKnight >> >> [email protected] >> ======================= >> > > > > -- > Regards > > > Ian McKnight > > [email protected] > ======================= > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
