Error in Dataset Code

[gmcordell]

Hi Guys

Ive recently made a simple amendment to my dataset in that i assigned a primary key field to my postcode column. In order to do this i needed to unassign a primary key from a column named b_dmref.

Since ive done this im getting the error on the following line of code.

If Me.PostTableAdapter.GetData(0).IsB_DMRefNull Then

The error states
'IsB_DMRefNull' is not a member of 'PostMap.DataSet1.PostRow'.

However when i check the dataset the column is still there. I have loads of these queries in my code its only this ref that causes the issue. Any ideas why it would lose the ability to check the is""null value?

[Bill Crawley]

The obvious one to me is that you have likely got a record with an empty postcode. A primary Key cannot be null.

[gmcordell]

Hi Bill

I did a check on this and the each record in the postcode column contains a value, it seems to be stating that for some reason out of around 15 columns im unable to run a isB_DMREFnull. However all the other is""null calls from the posttable work fine. Im going to try and rename my current post table and recreate in within my dataset and see what happens.