Has anyone been successful at using compound INSERTS with SQLite.
Just cant get it work.

I tried a single long query with multiple INSERT tags, but cant get that to work when coming from AS3. If i copy the long query straight into SQLite Admin and run the query there, it works perfect.

Right now i have to loop thru each insert with a new sql class and connection per one.
Unfortunately, after about 430 records, it stops.

All my other SQLite tags are working fine (single INSERT, DELETE, CREATE, SELECT, etc)
Any help would be greatly appreciated.

Is there a way to load a file (ie: doc, pdf, etc) in its native application?

Right now i am able to load a word doc file in word using navigateToUrl in an AIR applicaiton.
But this uses a web browser to load the file before a popup then asks if you want to load the file in Word.

Isnt there a way to open documents using whatever application they are derived from. (doc, pdf, excel, etc)

Can someone point me to a good demo of item renderers being used with pure mvc. (ie: mxml with datagrid using any number of item renderers, all being controlled/referenced with a datagrid mediator)
I find a bunch of samples with just Flex, but none with the second layer of a mediator.

I am trying to make a administration mode of a datagrid (add, edit, delete) and was trying to use a new column of checkboxes to select the record. (say to select all the records you wish to delete)

please help, i have been trying many different things, but none seem to offer a clean way of using itemrenderer and referencing the data set by it.

I am using the superPanel utility with an associated mediator to handle some sizing issues.
When I add an instance of superPanel via mxml, everything work fine:

:

xmlns:sh="shell.view.components.*"...
<sh:SuperPanel id="superPanel" title="SuperPanel 01"
x="0" y="0" width="345" height="180"
layout="absolute" showControls="true" enableResize="true" >
<mx:Label text="asfd" />
</sh:SuperPanel>
When I add instances dynamically:

:

var newPanel:SuperPanel = new SuperPanel;
container.addChild(newPanel)... the class is instantiated, I can visually see the new instance of SuperPanel, and the SuperPanelMediator loads..... however, although the mediator loads, it doesn't run the "onRegister" method, or "listNotificationInterests" etc.

Without this, the mediator functionality (ie: notifications regarding the sizing functionality) does not work.
Please help.

First off, Fabrication looks awsome!
I was struggling at fully understanding the piping utility. And while i hadn't fully grasped it yet, it appeared a manager could be written to simply it. ENTER FABRICATION. So thanks!

I am trying to use fabricaiton with AIR.
The pdf reguarding fabrication says to change the "fab:FlexApplicaiton" to "fab:AirApplication".
When I do this, it immediately breaks.

Is there something else i need to do to use fabrication and AIR together???

My ultimate goal is to have multi-module based application that use AIR to access SQLite databases. Is this possible?

Which is better?
Pipes or Fabrication?
or is the Fabrication utitility a manager of the pipes utility that is easier to use?
Is there any loss of functionality or downside of Fabrication vs straight Pipes?

I have made a simple test application using AIR & SQLite.
After I had it working I tried to port it over to Multicore as a module.

In order to have the 'shell' load the module correctly I was required change the <mx:WindowedApplication> tag of the base mxml file to <mx:module>.
In doing this, I lose any functionality requarding SQLite. I assume this is b/c 'WindowedApplication' is AIR compatible while 'module' is not.

Is there a way to have my module access the SQLite database directly (as it did when it was a standalone application (not as a piped module) which would allow me to keep the module more encapsulated) or do I have to use the 'shell' to connect to the database and then send the data to the module?