Drew Jensen wrote:
It is possible that you are constructing your form/sub-form improperly.
The select statement you show above is using a replaceable named
parameter ":link_from_idfield" which is proper if you want to have the
system prompt you for a value interactively. It is incorrect for use as
a sub-form data source.
When building the form you would need only this select statement:
SELECT * FROM "mydatabase"."datailtable"
Then in the form designer you would define the link between the main -
sub forms. I take it that in your case the link is something akin to:
"mastertable"."idfield" --> "detailtable"."idfield"
I do not construct any SQL by hand. I do exactly as you are describing
above. I link the forms from the form properties window. This strange
error appears also with old forms that used to work fine with MySQL ODBC
3.51 driver and with the JDBC driver.
--
Manolis Christodoulou MD
[EMAIL PROTECTED]
http://mobi-doc.com
http://palmpowereddoctor.blogspot.com
For document attachments...
PREFER: ODF, PDF, PDF/A.
AVOID: DOC, RTF, OOXML.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
