Subject | Re: [IBO] Post on required fields |
---|---|
Author | Helen Borrie |
Post date | 2007-04-16T22:12:15Z |
At 05:51 AM 18/04/2007, you wrote:
statement includes non-nullable fields that contain no values then
the Post will fail and you get an exception.
have to do with attempting to masterlink a record to a set that has
been closed or is awaiting some action to resolve a prior
exception. Can't be more explicit without more information but,
before calling Insert on the Book_Author dataset, test to make sure
it is open.
If you are writing this intersection record "invisibly" then use the
BeforeInsert handler of the Book_Author dataset to apply the
non-nullable values. If the key value of this set is a generator
then use GeneratorLinks for that value.
Helen
> I have two questions:Post writes the new record to the database. If the underlying INSERT
> I'm working with three tables: Book, Author and Book_Author. When
>inserting a new book, I open the Author table and select the ones I want
>do associate with the book, and that will be put in the Book_Author
>table. To do that, I use this :
>
> qryBook_Author.Insert;
> qryBook_Author.FieldByName('BOOK_ID').AsInteger :=
>qryBook.FieldByName('BOOK_ID').AsInteger;
> qryBook_Author.FieldByName('AUTHOR_ID').AsInteger :=
>qryAuthor.FieldByName('AUTHOR_ID').AsInteger;
> qryBook_Author.Post;
>
> If I use this without entering all the not null fields, I get an
>error informing that the required fields cannot be null. Of course they
>can't, by I'm just using a Post, not a Commit !
statement includes non-nullable fields that contain no values then
the Post will fail and you get an exception.
>Is it necessary that all the not null fields of the master table toYes.
>be filled before I use a Post command ?
> Nevertheless, if I fill the required fields, and try to use the codeIt is about a reference to a record in an unavailable set. It may
>above, I get the error: "Problem in binding cursor". What's this about ?
have to do with attempting to masterlink a record to a set that has
been closed or is awaiting some action to resolve a prior
exception. Can't be more explicit without more information but,
before calling Insert on the Book_Author dataset, test to make sure
it is open.
If you are writing this intersection record "invisibly" then use the
BeforeInsert handler of the Book_Author dataset to apply the
non-nullable values. If the key value of this set is a generator
then use GeneratorLinks for that value.
Helen