This content has been marked as final. Show 11 replies
Just reposting. Hasn't anybody ever encountered this problem??
For at least one item in the block, set the Primary Key item property to True.
itz not necessary that u need to have a primary key item for a block, when u are using locking mode & key mode as automatic.
But if u are using the key mode as automatic u have to make sure that the datasource u are using supports "RowId" .
check whether ur datasource supports rowid... and also try to connect to a different datasource & check whether the same problem still exists ...
can u make sure that the block's data source type is TABLE itself ??
My block is based on a single table and the datasource property is set to table. I know what the workaround is for this problem. I did set the primary key property of an item to True and everything worked after that. What I want to find out is why this should be necessary even when none of the property settings of the block require a primary key in the block(as per the online help!) and the base table itself does not have a primary key.
Frank, is this a known bug or something?
I ran into this same problem cloning a block in my form.
It turns out that you get this error, "FRM-30100: Block must have at least one primary key item." when the Query Data Source Name and the DML Data Target Name specify different tables.
Set DML Data Target Name blank, and the error goes away.
I experienced the same problem. The Query Data Source Name was table and the DML Data Target Name was TABLE. As you can see, the problem was because of the "sensitiveness", I just put both in uppercase and problem solved.
Set Property of Block
Two SImple Steps
1-Open <Block> property pallet
2-SET ENFORCE PRIMARY KEY to No.
Message was edited by:
If this doesn't work , try fgil's solution from above: Make sure that the Query Data Source Name and the DML Data Target Name are the same case (On the Block Properties Pallette).
It worked for me.
Thanks a lot. Your solution is absolutely right.