Author: Stephen Russell
Posted: 2013-09-27 09:06:18 Link
There is some sore of cleanup command but I didn't phrase it correctly on
Google last night at an old clients place.
What I did was take a copy of a running dbc and it's local tables to
another folder which I opened up under a different mapped drive letter.
This was an access point to SBT data for the shipping dept and the FedEx
or UPS systems. All working fine against company 1 in SBT.
Client has created company 50 and wants same thing interacting between
Company50 SO data and FedEx.
I am having problem with a dbf that records the transactions from the
carrier(s) in that it is still hooked to the former dbc. I made a new dbc
and put the views in there but reattaching the table seems to not work.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYLWxfMdranhYsNm6ROO1djqYEWJ=WsC6WA8wqOq2XHmDQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Tracy Pearson
Posted: 2013-09-27 09:18:49 Link
Stephen Russell wrote on 2013-09-27:
> There is some sore of cleanup command but I didn't phrase it correctly on
> Google last night at an old clients place.
>
> What I did was take a copy of a running dbc and it's local tables to
> another folder which I opened up under a different mapped drive letter.
> This was an access point to SBT data for the shipping dept and the FedEx
> or UPS systems. All working fine against company 1 in SBT.
>
> Client has created company 50 and wants same thing interacting between
> Company50 SO data and FedEx.
>
> I am having problem with a dbf that records the transactions from the
> carrier(s) in that it is still hooked to the former dbc. I made a new
dbc
> and put the views in there but reattaching the table seems to not work.
>
Stephen,
I have opened the old table and database. Then issued a COPY TO command with
the DATABASE clause pointing to the full path of the new DBC. Don't forget
the WITH CDX clause to keep the indexes.
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/000101cebb8c$7cbd9d60$7638d820$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Dave Crozier
Posted: 2013-09-27 09:22:14 Link
use <old Table>
Copy to <tablename> database <database Name> with cdx
Where tablename and database name are fully qualified paths
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell
Sent: 27 September 2013 15:06
To: ProFox Email List
Subject: How do you fix a dbc that opens with an error?
There is some sore of cleanup command but I didn't phrase it correctly on Google last night at an old clients place.
What I did was take a copy of a running dbc and it's local tables to another folder which I opened up under a different mapped drive letter.
This was an access point to SBT data for the shipping dept and the FedEx or UPS systems. All working fine against company 1 in SBT.
Client has created company 50 and wants same thing interacting between
Company50 SO data and FedEx.
I am having problem with a dbf that records the transactions from the
carrier(s) in that it is still hooked to the former dbc. I made a new dbc and put the views in there but reattaching the table seems to not work.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB22A3FD37E@EX2010-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2013-09-27 09:43:40 Link
On Fri, Sep 27, 2013 at 9:22 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> use <old Table>
>
> Copy to <tablename> database <database Name> with cdx
>
> Where tablename and database name are fully qualified paths
>
> -----------------
>
That first line throws the error.
Use Shipments
Error has something to do with corrupted index or dbc corruption.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYJKT2Ku0zvTvE=UGhG+C081nqMPgj5rj2hDRDp8wKOzdA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Dave Crozier
Posted: 2013-09-27 09:51:03 Link
Stephen,
In that case it is either a DBC error or a table index error.
For Table error (cdx corruption) take a backup first then copy an old CDX over the existing one. Then run open exclusive and reindex.
For DBC error you can try the "database validate" command or the same thing as above (which is extreme) but using the .dcx database index
Then do a database validate
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell
Sent: 27 September 2013 15:44
To: ProFox Email List
Subject: Re: How do you fix a dbc that opens with an error?
On Fri, Sep 27, 2013 at 9:22 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> use <old Table>
>
> Copy to <tablename> database <database Name> with cdx
>
> Where tablename and database name are fully qualified paths
>
> -----------------
>
That first line throws the error.
Use Shipments
Error has something to do with corrupted index or dbc corruption.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB22A3FD3CF@EX2010-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Dave Crozier
Posted: 2013-09-27 09:52:35 Link
Oh, and if all that fails you could remove the table from the database, but if you use long fieldnames that could cause you more grief than you really need but in extreme circumstances I have done this and manually appended the data back into a new table.
Dave
-----Original Message-----
From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen Russell
Sent: 27 September 2013 15:44
To: ProFox Email List
Subject: Re: How do you fix a dbc that opens with an error?
On Fri, Sep 27, 2013 at 9:22 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> use <old Table>
>
> Copy to <tablename> database <database Name> with cdx
>
> Where tablename and database name are fully qualified paths
>
> -----------------
>
That first line throws the error.
Use Shipments
Error has something to do with corrupted index or dbc corruption.
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/18725B8CD2D5D247873A2BAF401D4AB22A3FD3EB@EX2010-A-FPL.FPL.LOCAL
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2013-09-27 10:38:35 Link
database validate
Couldn't remember "validate."
On Fri, Sep 27, 2013 at 9:51 AM, Dave Crozier <DaveC@flexipol.co.uk> wrote:
> Stephen,
> In that case it is either a DBC error or a table index error.
>
> For Table error (cdx corruption) take a backup first then copy an old CDX
> over the existing one. Then run open exclusive and reindex.
>
> For DBC error you can try the "database validate" command or the same
> thing as above (which is extreme) but using the .dcx database index
>
> Then do a database validate
>
> Dave
>
> -----Original Message-----
> From: ProFox [mailto:profox-bounces@leafe.com] On Behalf Of Stephen
> Russell
> Sent: 27 September 2013 15:44
> To: ProFox Email List
> Subject: Re: How do you fix a dbc that opens with an error?
>
> On Fri, Sep 27, 2013 at 9:22 AM, Dave Crozier <DaveC@flexipol.co.uk>
> wrote:
>
> > use <old Table>
> >
> > Copy to <tablename> database <database Name> with cdx
> >
> > Where tablename and database name are fully qualified paths
> >
> > -----------------
> >
>
>
> That first line throws the error.
> Use Shipments
>
> Error has something to do with corrupted index or dbc corruption.
>
> --
> Stephen Russell
> Sr. Analyst
> Ring Container Technology
> Oakland TN
>
> 901.246-0159 cell
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYJJezDx47=o=vNsqA9j3jBpFDR_iP20XW9SquPxM+AmpQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Alan Bourke
Posted: 2013-09-27 10:46:57 Link
It's
validate database recover
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/1380296817.1140.27240761.4C1B5326@webmail.messagingengine.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Author: Stephen Russell
Posted: 2013-09-27 10:57:29 Link
On Fri, Sep 27, 2013 at 10:46 AM, Alan Bourke <alanpbourke@fastmail.fm>wrote:
> It's
>
> validate database recover
>
> -------------------
>
Thanks. As soon as I saw validate I googled to find it this way:
CLOSE DATABASES
SET PATH TO (HOME(2) + 'Data\') && Sets path to database
OPEN DATABASE testdata EXCLUSIVE && Open testdata database
VALIDATE DATABASE
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Oakland TN
901.246-0159 cell
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAJidMYJjRZREYbj=tpd9YtoDY9c3nCv8ittGd4bNhLouAd4D_w@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
One thing I could not get to grips with is DBC's. I hate them. I had a case
where I needed several the same tables in folders each folder had a DBC. But
when I looked the tables opened belonged to another DBC even though I set
DBC to. I don't trust them. Or see the point in them as I don't need long
field names.
Al
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Alan
Bourke
Sent: 27 September 2013 17:47
To: profoxtech@leafe.com
Subject: Re: How do you fix a dbc that opens with an error?
It's
validate database recover
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/007801cebb9a$8a982eb0$9fc88c10$@com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.