Subject Re: [IBO] Re: How to get data into a table
> but how can I access fields which aren't fields but parameter, e.g. I
> have a select statement like this:
> Select B.BookID, P.BookPub, A.BookAuthor, B.BuyDate from tabBooks B
> join tabPub P on tabBooks.PubID=tabPub.PubID join tabAuthors on
> tabBooks.AuthorID=tabAuthors.AuthorID where BookAuthor=:BookAuthor
> and BuyDate=:BuyDate
> The table Books is the detail table of the authors table, so whatever
> is shown in my detail table depends on the author shown in the master
> table, so far not a problem, but how comes the date into play now?
> The example with the books and the select query I just made up, so
> don't try to read too much into it. My actual tables are somewhat
> more complicated but the problem remains the same.

You can't CHANGE :BookAuthor or :BuyDate in this situation
as you may change the selection results - especially is
AutoRefresh on Parameter Change is ON.

I would suggest that either you insert a record direct, or
alternatively change :BuyDate to :BuyXXX so that you can use
BuyDate as the field name. ( Same with :BookAuthor ) While
using the same name for Parameters is allowed, normal
practice is to make them different to prevent this sort of

Lester Caine
L.S.Caine Electronic Services