Home > Archive > Programming with dBASE > October 2005 > Detach an MDX









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Detach an MDX
Bob Buchanan

2005-10-20, 8:26 pm

How do I programmatically open a DBF without the MDX?

If the MDX becomes corrupted (and keeps the DBF from opening), I want to
rebuild it for the user in my Clean Up utility. However, I don't want the
user to have to deal with the Corrupt index dialog - and have to manually
open the file without the MDX so my utilitity can rebuild it.

If I recall the 28th or so byte in the DBF header set to zero will
disconnect the MDX. Is there an easier way -- and if not, can someone assist
me with the low level code to do that?

TIA

Bob Buchanan
http://www.rvspacemanager.com


Roland Wingerter

2005-10-20, 8:26 pm

Bob Buchanan wrote

> How do I programmatically open a DBF without the MDX?
>
> If I recall the 28th or so byte in the DBF header set to zero will
> disconnect the MDX. Is there an easier way -- and if not, can someone
> assist me with the low level code to do that?

-------
Check out setMDXFlag() in :dUFLP:dbf7file.cc.

Roland


Ivar B. Jessen

2005-10-20, 8:26 pm

On Mon, 17 Oct 2005 22:26:24 -0700, "Bob Buchanan" <rlbuch@compuserve.com>
wrote:

>How do I programmatically open a DBF without the MDX?
>
>If the MDX becomes corrupted (and keeps the DBF from opening), I want to
>rebuild it for the user in my Clean Up utility. However, I don't want the
>user to have to deal with the Corrupt index dialog - and have to manually
>open the file without the MDX so my utilitity can rebuild it.
>
>If I recall the 28th or so byte in the DBF header set to zero will
>disconnect the MDX. Is there an easier way -- and if not, can someone assist
>me with the low level code to do that?


Use :duflp:CreateReindex
.prg to recreate indexes in case of index
corruption.


Ivar B. Jessen
Bob Buchanan

2005-10-20, 8:26 pm

Roland, that's exactly what I needed.

Thank you -- I apprciate the help.

Bob Buchanan
www.rvspacemanager.com

"Roland Wingerter" <ich@hier.de> wrote in message
news:p%23kCB360FHA.1044@news-server...
> Bob Buchanan wrote
> -------
> Check out setMDXFlag() in :dUFLP:dbf7file.cc.
>
> Roland
>



Bob Buchanan

2005-10-20, 8:26 pm

Thank you, Ivar. That would have helped a lot in rewriting a ton of tags.
Will now use it in my Clean Up utility on all my tables.

Bob Buchanan
www.rvspacemanager.com

"Ivar B. Jessen" <bergishagen@it.notthis.dk> wrote in message
news:oei9l15uack301r
ko7k3qvatf8eg53gm2c@
4ax.com...
> On Mon, 17 Oct 2005 22:26:24 -0700, "Bob Buchanan" <rlbuch@compuserve.com>
> wrote:
>
>
> Use :duflp:CreateReindex
.prg to recreate indexes in case of index
> corruption.
>
>
> Ivar B. Jessen



Roland Wingerter

2005-10-20, 8:26 pm

Bob Buchanan wrote

> Thank you -- I apprciate the help.

-------
You're welcome.

Roland


Ivar B. Jessen

2005-10-20, 8:26 pm

On Wed, 19 Oct 2005 18:02:15 -0700, "Bob Buchanan" <rlbuch@compuserve.com>
wrote:

>Thank you, Ivar. That would have helped a lot in rewriting a ton of tags.
>Will now use it in my Clean Up utility on all my tables.


You are welcome.

Ivar B. Jessen
David Kleinman

2005-10-24, 8:24 pm

When I try to disable the MDX flag on an encrypted table using setMDXFlag(), and then try to open file table, I get an "Invalid Password" error message.

I'm using version 7 table structures.
dBASE Plus Version 2.5

The password is valid in the appliaction before trying to set the MDX flag - I can open and close the table immediately before setting the flag.

Has setMDXFlag() been used successfully with encrypted tables?
Is the header structure of an encrypted table different?

David
Ken Mayer [dBVIPS]

2005-10-24, 8:24 pm

David Kleinman wrote:
> When I try to disable the MDX flag on an encrypted table using setMDXFlag(), and then try to open file table, I get an "Invalid Password" error message.
>
> I'm using version 7 table structures.
> dBASE Plus Version 2.5
>
> The password is valid in the appliaction before trying to set the MDX flag - I can open and close the table immediately before setting the flag.
>
> Has setMDXFlag() been used successfully with encrypted tables?
> Is the header structure of an encrypted table different?


To modify an encrypted table, you have to decrypt it.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
David Kleinman

2005-10-24, 8:24 pm

I can do that if I am running in interpretive mode. The problem is in an appliaction, if the MDX is corrupted or missing I cannot open the table to decrypt it without detaching it first. That would be the purpose of the setMDXFlag() function.

Nice book by the way.

David

Ken Mayer [dBVIPS]

2005-10-24, 8:24 pm

David Kleinman wrote:
> I can do that if I am running in interpretive mode. The problem is in an appliaction, if the MDX is corrupted or missing I cannot open the table to decrypt it without detaching it first. That would be the purpose of the setMDXFlag() function.


That's one of the problems with encrypting tables. In general, it's not
a great idea ... <g>

> Nice book by the way.


Thanks ... hope you find it useful!

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com