Franco Fornari wrote:
Hi Fernand,
you sent me complicated suggestions.
I saw you used already some "complicated macro's , make a dialog, fill
the fields with the data from a sql statement , play around with the
data in the fields, send them back with a other SQL statement to your
tables...
Why using a query as source for a subform is a mistake?
OK: see a Query as a temporary "view" on data stored in one or more
tables but you can not store data in "query" only in a "table"
see a Form as support to "view" and/or to "store" data in "tables" ,
"querys ,views or resultsets from a SQL command". can only been used to
"view" this data. When based on a table then the database engine can
send new or altered data to this table. When using a query, view or SQL
command as datasource you need some macro code (SQL stements) to send
the data to a table.
Without calculated fields it works fine. And why, without any
calculated fields in subform,
the calculated fields are comming from a "query" and you try to enter it
in a table where there is simply no field for it
I cannot use some default values in columns? Default values are there
by design.
Yes you can use simple default values but I think you try to enter a
formula or a range
If the program has some limits,
Yes, but the wrong use has also his limits :-)
hope it helps
Fernand
they should be pointed out. A workaround is not the best way to go, in
my opinion. At the most it can be a temporary solution.
Best,
Franco
Fernand Vanrie ha scritto:
Franco, Frank
I just checked (out of curiosity how others use OO-base) the
db_sample_franco dbase.
I only can reproduce the Calculated field error, who is no error but
a mistake from Franco who uses a query as a datasource for a subForm.
Franco: change the datasource to the table where the Form-data must
been inserted and forgot the calculated field.
If you want to uses calculated fields then you are better off using a
Dialog and a macro to collect the data and then using a macro to
pass the data to the tables.
With a Dialog and some macro's you can check (Default values) and
manipulate all the data without restrictions, as soon all data is
checked then pass them to the Table
Hope it helps
Fernand
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
------------------------------------------------------------------------
Nessun virus nel messaggio in arrivo.
Controllato da AVG - www.avg.com Versione: 8.5.387 / Database dei
virus: 270.13.65/2324 - Data di rilascio: 08/24/09 12:55:00
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
