Pre-purchase questions: Data Bridge/DataAssist abilities...

Does DataAssist support creating complex queries visually that include?

Multiple table joins
GroupBy
Aggragate functions
SubQueries
Derived tables

If not, is it possible to paste these complex queries into DataAssist or code view and yet everything work?
Are there any query limitations that DataAssist cannot handle?
FYI, I use Flyspeed Visual Query Builder to create queries, I want to know how to incorporate queries built there into DataAssist workflow.

Also, how are transactions handled in DataAssist?
How would this example of transferring $100 to another account be handled: Confirm that I have $100 in my account; Decrease my account by $100; Verify the decrease; Increase the amount of money in your account by $100; Verify that the increase worked.

Are all parts of the transaction reversible if one part fails?

Can I update/insert/delete records in multiple tables in a single transaction; if not what is the recommended process?

I have not found much for video's or doc's that explain DataAssists abilities in depth, do they exist somewhere?

Thanks,
Brent

DataAssist creates and uses Dreamweaver Recordsets.

The DataAssist wizard will not not create the complex type of recordsets you mention, but the pages can be edited after they have been created and you can update the recordsets.

For the complex scenarios you are mentioning, I don't think you would be using the Wizards much, but would be creating your own recordsets and forms and using the individual server behaviors for inserting, updating or deleting.

There are server behaviors for single record inserts, updates and deletes as well as multiple insert updates and deletes.

There is also a manage relational table behavior for managing linking tables.

These can be put together in various ways to create complex data management applications, for example you can use 2 single record inserts on the same page to create a form that inserts to 2 tables.


The data assist behaviors do not use data transactions, they use standard inserts and updates.

Thanks...I few more questions...

I need to create a new message thread where I create (threadID ai) in table1 and insert the actual message in table2: (messageID ai, threadID, message); where threadID is relational.
...threadID must be auto created first in table1, and then the message may be inserted into table2 with the newly generated threadID from table1.
I can imagine a number of ways of doing this, but want to hear about capabilities of DataAssist and best practices for doing this?

Also, I discovered that MySQL Dreamweaver recordsets do not support queries containing BLOB's (throws 1064 error); am I correct to assume that DataAssist does not as well?
What other limitations are there? I do not like spending hours only to discover limiting surprises ;-)

Can multiple queries be sent at once with multiple recordsets returned?
MySQL stored procedures can contain multiple Select statements. How does this work with DataAssist?
Are there other DataAssist methods that may be used instead?

you would use 2 Insert behaviors.

the insert behavior will store the ID of the record it creates in a session variable. In the second insert behavior, you would bind the relational column to the session variable created by the first insert.


Data Assist uses dreamweaver recordsets for getting information out of the database to display on the page, so will have the same limitations including BLOB Fields.


you can add as many dreamweaver recordsets to a page as you need, dreamweaver recordsets can also use MySQL Stored Procedures.

Thanks Jason...I will download the tools and give them a shot.
Brent