Re: FRM-40509 Error when trying to insert a new record...

"Joshua Wellman" <meet_aquarius_at_hotmail.com> schrieb im Newsbeitrag news:c0569f20.0305310912.290900e0_at_posting.google.com...
> INSERT INTO vendor VALUES
> (
> :VENDOR_BLOCK.VENDOR_ID_TEXT,
> :VENDOR_BLOCK.VENDOR_NAME_TEXT,
> :VENDOR_BLOCK.CONTACT_NAME_TEXT,
> :VENDOR_BLOCK.PHONE_TEXT,
> :VENDOR_BLOCK.FAX_TEXT,
> :VENDOR_BLOCK.ADDRESS_TEXT,
> :VENDOR_BLOCK.CITY_TEXT,
> :VENDOR_BLOCK.STATE_TEXT,
> :VENDOR_BLOCK.ZIP_TEXT,
> :VENDOR_BLOCK.EMAIL_TEXT

...
> ...a couple of people have suggested
> making sure that all fields "database item" property is set to yes. I
> have checked all of them and they are correct.

I noticed that the forms items have not the same name like the database columns - have checked that the property Column Name for these items match. The same applies to the block: If its name does not match the table name the property Query Data Source Name must hold the table's name.

If the block is a database data block (again a property of block) Forms performs insert,update and delete automaically, you need not to write your own insert statement!

I assume that your form is something like an inventory list where you want the user to extend the list of vendors by himself. Try to make the vendor block a master of the inventory block (use relations!) and forms will take care of the rest.

Carsten Received on Sat May 31 2003 - 20:37:01 CEST