Pete, Thanks on the reply. I have the XML stuff all working as this is the same data which my Adobe Air application uses on a daily basis. I am just wanting to convert it to Livecode so that I can use the same code base for desktop, tablet and mobile devices. Made some great progress today.
On 5/8/2013 12:01 PM, Peter Haworth wrote: > Can't help with the XML stuff but it doesn't seem to difficult to use the > array. > > put the keys of gAvailableMarketDataArray[AvailableMarkets] into tKeys > sort tKeys -- if you care > repeat for each line L in tKeys > <do stuff with gAvailableMarketDataArray[AvailableMarkets] [L]> > end repeat > > If you're inserting/updating stuff into an sqlite database, don;t forget to > issue a BEGIN before the repeat loop, a COMMIT after the repeat loop, and > ROLLBACK if any errors occur within the repeat loop. Everything will work > much faster that way. > > Pete > lcSQL Software <http://www.lcsql.com> > > > On Wed, May 8, 2013 at 6:38 AM, Graham Pearson <gspear...@gmail.com> wrote: > >> Array Experts >> >> In my application that I am converting from Adobe Air, I have come to a >> section where Google has let me down. I have converted my XML File to an >> Array and can see it within the Debugger and parts of the array is >> listed below. >> >> gAvailableMarketDataArray >> AvailableMarkets >> Market[1] >> BTALatitude 27-29-40.1-N >> BTALongitude 81-24-59.3-W >> CallSign WNC905 >> City Sebring >> State FL >> @attributes >> ID 1 >> Market[2] etc. >> >> >> The application pulls the XML File from a Web Service that generates it >> on the fly. The application on first run checks to make sure the >> database exists and records are within it. At this point no records are >> retrieved from the database so I am struggling with how to take this >> array and insert each record of the array into the database. >> >> >> Or is their a command/function that I can use after >> >> put revCreateXMLTree(gClientAvailableMarketsXMLData, false, true, false) >> into tAvailableMarketData >> >> that will give me just the Market part of the XML data so then I can >> create the array which will simply list the Market[1] directly under the >> gAvailableMarketDataArray which will make it easier to insert the array >> into the sqlite database. >> >> >> >> >> >> >> >> _______________________________________________ >> use-livecode mailing list >> use-livecode@lists.runrev.com >> Please visit this url to subscribe, unsubscribe and manage your >> subscription preferences: >> http://lists.runrev.com/mailman/listinfo/use-livecode >> > _______________________________________________ > use-livecode mailing list > use-livecode@lists.runrev.com > Please visit this url to subscribe, unsubscribe and manage your subscription > preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
