I tried Transactions last night but was doing it wrong.
Per your suggestion, I tried it again and got it work.
Thanks a bunch.

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.

Thanks.
"evt.target.cb.selected" worked.

I must have tried everything but that. not sure how i missed it.

Sorry, I did not write that very clearly. I did not intend a mediator for each record.

I am currently using a bubbled event on a checkbox item renderer. In doing so, i can catch the event and retrieve the associated data with that record.

What i can't seem to do is, get the 'selected' status of the checkbox, b/c i cant seem to get a reference to the checkbox itself.

:

datagrid.mxml
....
<mx: Component id="CheckboxRenderer">
   <mx: VBox>
       <mx: CheckBox id="cb" selected="false" click="dispatchEvent(newEvent("evt", true))" />
   </mx: VBox>
</mx: Component>
 
....
<mx: DataGridColumn .... itemRenderer = "{CheckboxRenderer}"
In the datagrid mediator, i catch the event and can get the data via "evt.target.data"
But how do i get the selected status of the checkbox itself?
I get an error when i try to reference 'cb' (either via datagrid.cb, datagrid.CheckboxRenderer, etc)

 

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.

Like I said, Wietse's it is a good component. Not trying to step on anyones toes.
Just saying the other one seems to be closer to being a completed comp.

I am using: SuperPanel version : 1.5 author  : Wietse Veenstra

It is a good utility, but had some limitations. I was altering the code to increase some of its functionality.

Your SuperPanel 1.3 look great and appears to be a bit further along.
I think when your panel is in maximized mode, it should auto expand with it wrapper. (one of the things i added to the one i am working with)
Also, i agree that a taskbar or tabbed bar should manage all the opened taskbars when minimized or in maximized mode. That was going to be one of my next tasks.
Your "TODOs" look like they will add some nice functionality to the panel.
Maybe after I get some time, I will rework my project to use your SuperPanel, especially if you add your updates.
Thanks.

Wow, thanks!
That was giving me all sorts of grief!!!

Quick question. Does it matter where I register the new instance of SuperPanel. Right now i have it in my "AddPanelCommand.as", which creates a new instance, sets its properties, registers it, then send it out with a notification. is that right?

:

var panel:SuperPanel = createSuperPanel(note.getBody().url);
registerMediator(new SuperPanelMediator(panel));
sendNotification(PANEL_CREATED, panel);

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?

Sorry.  I just found other posts on this forum regarding fabrication.

http://forums.puremvc.org/index.php?topic=681.0

http://www.codedrunks.com/index.php/2008/09/12/fabrication-simplified-puremvc-multicore-modules/

nevermind, i found the information i was looking for, thanks.

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?