INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

*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.

Jobs

Rebuild a broken table

Rebuild a broken table

(OP)
Hi everybody.

I have been using Mimer for several years now and only now have a "broken" table. What happens is that when my program reads through the records by primary key order it tries to read the first record over and over. Hence the Invalid Cursor State message.

I can solve this by exporting the data via WSQL (great little tool), and importing the data again having first dropped all the relevant foreign keys, and then reapplying the foreign keys.

I was wondering if Mimer has a Rebuild tool? I cannot find it.

Regards,
Mike Gorman

RE: Rebuild a broken table

Hi,

Mimer SQL has no "rebuild tool", but you can use the DBC program to investigate if the databank file's physical structure is damaged or not.

Can you give more information on the error you're seeing? (Error codes, how, what, when etc.)


Regards,
Jarl

RE: Rebuild a broken table

(OP)
Jarl:

Thanks for getting back to me... The error was Invalid Cursor State. The way I fixed it was to export the rows with WSQL and then import them. 8 tables in all. I have no idea how the tables got broken.

What is the DBC program. Never heard of it.

Sorry there is not a magic bullet repair tool.... What I have to do is:

Execute script to drop relevant foreign keys
Export rows via WSQL
Import rows via WSQL
Execute script to Add foreign keys

Simple enough process. I was hoping for a silver bullet, however.

Regards,
Mike Gorman

RE: Rebuild a broken table

(OP)
Silver bullet has arrived.....

Paule of Mimer Tech support suggested that Mimer might NOT be setting the value of the column correctly after the Alter Table statement.

So, I modified the SQL DDL script to set all rows for the tables that have the new column to the value, '   '. That is, blank.

Problem has now gone away.

Thanks Paule....

Silver bullet had been applied.

Regards,
Mike Gorman

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!

Resources

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