On Friday 04 August 2006 12:49, Frank Schönheit - Sun Microsystems Germany wrote: > Hi Tony, > > > Does anyone out there have any experience creating database forms with > > the wizard when one of the fields in the table is encrypted (MySQL using > > AES_ENCRYPT)? I seem to get stymied at every turn on this :-( > > In any case, it's worth submitting an issue, so we can look into it, and > fix it. >
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? > > I could, of course, design my own form and write all the code to fill it > > in, but the table has many columns, so that would be a bit of a PITA, so > > if anyone has crossed this problem before, I'd love to get the benefit of > > your experience. > > Don't know how many fields of this type you have, but if the number is > small enough, consider leaving only those fields out, and adding them > manually. I fear that's the only workaround I can offer. > 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? -- Cheers, TonyB --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
