Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


"Record is not locked" problem

"Record is not locked" problem

"Record is not locked" problem

I'm doing a project for a client and one of their VFP apps is a tool that moves data around between VFP tables and Informix tables. They have source code, but are not sure it's the most up-to-date and they don't want to decompile and replace the app with a new version based on that decompile. This is mostly due to proceeding with an abundance of caution. But what I'm doing is to document the app given the source we do have (which I think is up-to-date) and to document the stored procedures in various VFP databases. Part of what I'm doing is to determine what SPs are being used, how often, and how long they take to run (some are quite inefficient). To do that I have added some instrumentation code to the SPs so that we can log all that info. Before my code runs, I save the DB selected and the table selected and after adding the record to the logging table, I reselect the originally selected DB and table. Unfortunately, with the new SP code, we get a "Record is not locked" error in the program. Changing the DB and table should not change whether a record is locked or not in the originally selected table, so I'm unclear on what might be going on here and the program that's running and calls the SP has no real error trapping and logging. I don't feel my code is generating the error because I have a Try-Catch around it and any error is logged to a text file and I'm seeing no errors. I'm going to give my code another once-over and test the Try-Catch error code again (just for drill), but if you have any thoughts on this, please let me know.

RE: "Record is not locked" problem

Nevermind. I got it.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close