Hi Tony, > The SQL is 'SELECT ... AES_DECRYPT(field, password) ...'. When I create a > query of this sort, and try to base a form on it, I get an error something to > the effect 'can't retrieve field names for query'. Happens even if I give the > field an alias. So do I file an issue, or is this just unsupported > functionality?
File an issue, please - MySQL is wide-spread enough that we should be support its functionality as long as it doesn't break anything else. > I upgraded to 2.0.3 and tried some more testing. It seems my major problem is > in the timing of the various event calls. As a simple example, I would have > expected that the form's 'When loading' event would be the first thing > called, bafore any data access. However, I find that if I base the form on a > query which returns no data, the load event never seems to happen at all. But > since the documentation (at least, what I've been able to find) is rather > vague, I don't know whether this is correct or not. What would you think? Hmm. For queries which are valid, but return an empty result set, the event should be called. For queries which are invalid, i.e. not executable, the event is not called, which is intentional. So depending on whether your query is valid or not, you found a bug. In any case, I encourage you to file a bug about the vague documentation. Thanks & Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
