Jump to content
RockWare Support Forum
RMichaelis

Dataset not in edit or insert mode

Recommended Posts

Good Morning,

Every time I try to convert my decimal latitude and Longitude to Easting and Northing I get the following message:

qLocData: Dataset not in edit or insert mode.

What do I need to do in order for my lats and longs to be converted?

regards,

Raechel

Share this post


Link to post
Share on other sites

Hi Raechel,

We had another customer who ran into this problem when trying to enter data on the Location table in the Borehole Manager.

The solution is to complete all the required fields, including Easting, Northing, Elevation, Collar Elevation, and Total Depth, enter zeros as placeholders for unknown data, then click on a different borehole to save the changes. After the borehole is saved, click back to the original borehole and do the lat/long conversion.

The Borehole Manager uses an Access database, so there are some operations like data entry and saving that are different than many people are used to handling. To work with a more familiar data entry interface, enter the data in the Utilities datasheet or Excel, then transfer or import the data into the Borehole Manager.

Thanks,

Tom B

RockWare Inc

Share this post


Link to post
Share on other sites

Thank you Tom.

I have done what you suggested and I am still running in to an issue.

I have been importing my data as follows: File > Import > Excel > Multiple Tables.

All the data including Lat and long populate the correct fields. Again, my only problem is when I try to convert them to eastings and northings I get the following message as soon as I click the "To Eastings/Northing" button:

qLocData: Dataset not in edit or insert mode.

I noticed that if I copy and paste my lat and long, hand type it, or simple erase and retype a digit at the end - the program will convert them to eastings and northings just fine. I am working with very large data sets so I would like to be as time efficient as possible.

Do you have any other suggestions?

Thanks again,

Raechel

Share this post


Link to post
Share on other sites

Hi Raechel,

Thanks for the additional information about the steps you perform to display the error message. I can duplicate the problem and I have passed it to programming for further action.

To work around the problem, use the Edit | Coordinate Converter (to Easting/Northing) menu command in the Borehole Manager to convert 1 or more boreholes.

Thanks,

Tom B

RockWare Inc

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×