Array Looping to Insert into Database

[Graham Pearson]

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 <gspearson at 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 at 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 at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>