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?