I've now tried with 2 other databases:MySQL works perfectly.MSSQL fails with the error "The Java type java.util.Date isnot a supported type."So this might be a question of whether a specific JDBC drivercan map Java's date object to a field correctly.EDIT:I tried experimenting with another JDBC drive...

I'm just wondering if anyone has had any luck using date/timefields with SQLAssembler, as I'm having a few problems.My update query declaration looks like this:<update-item> <sql>UPDATE Timesheet SET person=#person#,<sniiiiip, lots of fields>, date=#date# WHERE id=#_PREV.id#</sql></update-item> I'm ...

Have a look at Shared Objects, I think these are the sort ofthing you are after. I think the "Specifying a path" subtopicshould be particularly relevant for sharing the variables/objectsbetween the two swf files.Livedocs- Shared Objects

I think the best way is to make a label function somethinglike this (just off the top of my head, not tested):public function rate_label(item:Object,column:DataGridColumn):String { return "GBP"+item.prdt_rate;}Then in the DataGridColumn add a property:labelFunction="rate_label"

That seems like the best way to go about things, thanks.I don't think normal triggers are supported from straight MDBfiles under the Jet engine, but there are afterUpdate events whichcan be fired from forms, so I'll write the code to modify thechanges table there, and tell people not to tweak the ta...

Thanks for the reply Ed.This is for an internal project which only uses a MDB file,which may be updated by Flex or directly through Access itself, andI'd like any changes made in Access to reflect in Flex fairlyrapidly. I can to switch to MSSQL Standard or Enterprise if it is 100%necessary, but I'd ...

I've been using the SQLAssembler quite successfully so far,but I've hit a small snag.I'd like to poll for changes to the result of the DB queriesand update the clients when a change occurs. Before I'd got intothe javadocs in detail I'd assumed that triggering a refreshFillwould do what I wanted, and...