Re: [GNUe] Rocks!

[Reinhard Mueller]

Am Montag, den 21.03.2005, 03:12 +0800 schrieb Stefan Elwesthal:
> I want to ask two stupid questions though. "requery" = "true"?
> Exactly.. what does that one do?

Please make sure that you don't mix up "requery" and "prequery".

"prequery" makes the form start up with all records loaded (instead of
no records loaded), and the first record being displayed (instead of a
new record being displayed). This makes sense especially if you have a
low number of records in that table :)

"requery" means that after saving a record, the same record is queried
again from the database. This makes sense for 2 reasons:
1. to display changes that the database did automatically on the saving
of the record, e.g. through database triggers
2. to display changes that other users have made simultaneously to the
same record

> I was thinking about experimenting with a "On form startup" to
> retrieve my first MySQL record and show, but that's not what it does
> right? (the Wizard put it there for me).

That would be "prequery" rather.

> I have so far, only two tables (not much of a cash-register now is
> it??). It's Customer which is customer_id and name, and customer_sales
> which is transaction_id, amount, and customer_id which is a foreign
> key. MySQL, s handles the constraint and won't let me add transactions
> if the id doesn't exist? Then I read about Master/Detail and got
> confused (since the amount of coffee are way to low in my body right
> now I think).

Master/Details support in Designer/Forms is for forms that contain two
tables on a single form, like general invoice data being the master,
displayed on the top half of the form, and invoice items being the
detail, displayed on the bottom half of the form. Forms will then take
care to always show the invoice items that belong to the current
invoice.

Thanks,
Reinhard

signature.asc
Description: Dies ist ein digital signierter Nachrichtenteil