Re: Old VFP8 app on a Windows 7 computer suddenly fails
We ran our installer. If the file versions were the same or newer, it wouldn't have overwritten them. Thank you, I'll keep that in mind if I see this again. Tracy On February 28, 2019 9:05:28 PM EST, Philip Borkholder wrote: >I've had something similar happen in the past Tracy. > >If you don't have the client installation available to re-register the >DLLs for VFP8, then running a System Restore on the workstation to >point >when you knew the VFP8 app still worked might have fixed it. > >-Philip B. > > Vicksburg, MI > >On 2/28/2019 11:56 AM, Tracy Pearson wrote: >> It won't start. AVG is installed. >> >> Here's the details from the Event Viewer message >> >> http://schemas.microsoft.com/win/2004/08/events/event;> >> - >> >>26 >>4 >>0 >>0x80 >> >>907913 >>System >>Owner-PC >> >> >> - >>pcplus9.exe - Application Error >>The application was unable to start correctly (0xc07b). >Click OK >> to close the application. >> >> >> >> We are currently seeing if the customer will upgrade to our latest >version >> which is running VFP 9. And uninstalling AVG. >> >> Any thoughts? >> >> >> [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/8d1255e7-5384-4bcf-93af-8fbaf32d8...@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.
Re: Old VFP8 app on a Windows 7 computer suddenly fails
I've had something similar happen in the past Tracy. If you don't have the client installation available to re-register the DLLs for VFP8, then running a System Restore on the workstation to point when you knew the VFP8 app still worked might have fixed it. -Philip B. Vicksburg, MI On 2/28/2019 11:56 AM, Tracy Pearson wrote: It won't start. AVG is installed. Here's the details from the Event Viewer message http://schemas.microsoft.com/win/2004/08/events/event;> - 26 4 0 0x80 907913 System Owner-PC - pcplus9.exe - Application Error The application was unable to start correctly (0xc07b). Click OK to close the application. We are currently seeing if the customer will upgrade to our latest version which is running VFP 9. And uninstalling AVG. Any thoughts? [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/2243215e-09ba-b0aa-e662-9c363ea27...@netzero.net ** 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.
RE: Creating a copy of a database -- best practice?
I feel like the young pup still being just 52. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, February 28, 2019 5:46 PM To: profoxt...@leafe.com Subject: Re: Creating a copy of a database -- best practice? Turning 60 this year. :) On Thu, Feb 28, 2019 at 4:33 PM Tracy Pearson wrote: > You'll have trouble the same way if a user is saving the Word or Excel > file. > Writing to tables locks a portion of the table, and sometimes all of the > table which can cause copy failures.. > You've been out of the VFP for a couple of years and haven't worked with > DBFs for longer. > We'll forgive your older age and forgetfulness. > > Tracy > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, February 28, 2019 5:29 PM > To: profoxt...@leafe.com > Subject: Re: Creating a copy of a database -- best practice? > > Would the table or index not be included? I get backups of word and excel > files if they are open. > > > > > > On Thu, Feb 28, 2019 at 3:40 PM > > wrote: > > > On 2019-02-28 07:08, Stephen Russell wrote: > > > Why not make a compressed file of the entire folder where the data > > > lies? > > > After file is created move it to a different machine off the network. > > > > > > Because I think open DBFs would present a problem with that approach??? > > [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/000f01d4cfb7$cbf8c4f0$63ea4ed0$@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.
Re: Creating a copy of a database -- best practice?
Turning 60 this year. :) On Thu, Feb 28, 2019 at 4:33 PM Tracy Pearson wrote: > You'll have trouble the same way if a user is saving the Word or Excel > file. > Writing to tables locks a portion of the table, and sometimes all of the > table which can cause copy failures.. > You've been out of the VFP for a couple of years and haven't worked with > DBFs for longer. > We'll forgive your older age and forgetfulness. > > Tracy > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of > Stephen > Russell > Sent: Thursday, February 28, 2019 5:29 PM > To: profoxt...@leafe.com > Subject: Re: Creating a copy of a database -- best practice? > > Would the table or index not be included? I get backups of word and excel > files if they are open. > > > > > > On Thu, Feb 28, 2019 at 3:40 PM > > wrote: > > > On 2019-02-28 07:08, Stephen Russell wrote: > > > Why not make a compressed file of the entire folder where the data > > > lies? > > > After file is created move it to a different machine off the network. > > > > > > Because I think open DBFs would present a problem with that approach??? > > [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/cajidmylslflrkmv1zvo1eat8gtj9-bbodbtehwbixyvorxq...@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.
RE: Creating a copy of a database -- best practice?
You'll have trouble the same way if a user is saving the Word or Excel file. Writing to tables locks a portion of the table, and sometimes all of the table which can cause copy failures.. You've been out of the VFP for a couple of years and haven't worked with DBFs for longer. We'll forgive your older age and forgetfulness. Tracy -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Thursday, February 28, 2019 5:29 PM To: profoxt...@leafe.com Subject: Re: Creating a copy of a database -- best practice? Would the table or index not be included? I get backups of word and excel files if they are open. On Thu, Feb 28, 2019 at 3:40 PM wrote: > On 2019-02-28 07:08, Stephen Russell wrote: > > Why not make a compressed file of the entire folder where the data > > lies? > > After file is created move it to a different machine off the network. > > > Because I think open DBFs would present a problem with that approach??? > [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/000d01d4cfb5$9869ae80$c93d0b80$@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.
Re: Creating a copy of a database -- best practice?
Would the table or index not be included? I get backups of word and excel files if they are open. On Thu, Feb 28, 2019 at 3:40 PM wrote: > On 2019-02-28 07:08, Stephen Russell wrote: > > Why not make a compressed file of the entire folder where the data > > lies? > > After file is created move it to a different machine off the network. > > > Because I think open DBFs would present a problem with that approach??? > [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/CAJidMY+TOxSCXKWE=gd3sw8gkvcklnhy8enm47v5assexrt...@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.
Re: [NF] Learn about Stored Procedures
All you need is a case statement to fire the correct code going forward. It really sucks to bring in another back end but the customer must pay for what THEY WANT. You could really consider putting up an AWS cloud environment and getting your data from there. Or Azure. Now you get a little bit of redundancy going forward. On Thu, Feb 28, 2019 at 3:42 PM wrote: > On 2019-02-28 09:45, Stephen Russell wrote: > > I have some long stored procedures that are in the 3000 lines long > > arena > > > Jesus...that makes my head hurt just thinking about that. I get the > efficiency angle but I really enjoy breaking work up into much more > manageable/readable units in the DataObject code; plus, my approach > means I'm not stuck with SQL Server in case I want to switch out the > backends. There's varying schools of thought on that, and of course, > pros and cons to each. I recall somebody (Ted?) saying something years > ago about treating that backend as just big dumb iron in the n-tier > system approach, which is what I use. > [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/cajidmyls9oqbaxtkwx0mfur4xgy8mhfyxusennjoyi6z004...@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.
Re: [NF] Learn about Stored Procedures
On 2019-02-28 09:45, Stephen Russell wrote: I have some long stored procedures that are in the 3000 lines long arena Jesus...that makes my head hurt just thinking about that. I get the efficiency angle but I really enjoy breaking work up into much more manageable/readable units in the DataObject code; plus, my approach means I'm not stuck with SQL Server in case I want to switch out the backends. There's varying schools of thought on that, and of course, pros and cons to each. I recall somebody (Ted?) saying something years ago about treating that backend as just big dumb iron in the n-tier system approach, which is what I use. ___ 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/647e675038c84fec5a1201b5468ca...@mbsoftwaresolutions.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.
Re: Creating a copy of a database -- best practice?
On 2019-02-28 07:08, Stephen Russell wrote: Why not make a compressed file of the entire folder where the data lies? After file is created move it to a different machine off the network. Because I think open DBFs would present a problem with that approach??? ___ 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/d75f9d1d4ae9647483d5aeb68ad52...@mbsoftwaresolutions.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.
Re: Creating a copy of a database -- best practice?
On 2019-02-28 04:43, Peter Cushing wrote:
On 27/02/2019 17:22, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
I can easily do something like this:
CREATE DATABASE C:\Backup\MyDBC.dbc
OPEN DATABASE C:\Production\MyDBC.dbc
liNumTables = adbobjects(laTables,'TABLE')
for ii = 1 to liNumTables
lcFile = forceext("C:\BACKUP\" + laTables[ii],'dbf')
use laTables[ii]
copy to (lcFile) database C:\Backup\MyDBC.dbc with cdx
use
endfor
...and that would get me a copy of all of the tables with their
indexes.
Great. But what's the easiest way to get all of the DBC meta-data
into
that new Backup database copy? I can't USE the MyDBC.dbc and do a
COPY
TO as that only makes the result a DBF and FPT.
An easy way to get a copy of the data is to have a copy of all the data
in another folder, then using your loop above, zap each table and
append
from the live data. We use it here as a rough and ready backup during
the day, while people are in the system. Your copy then has all the
same meta data as the original.
Hi Peter,
I see no difference between my COPY TO versus
doing an APPEND FROM from my backup table. ???
Am I mistaken?
tia,
--Mike
___
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/57548c2cb0741015511f60d8bcfd5...@mbsoftwaresolutions.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.
RE: Old VFP8 app on a Windows 7 computer suddenly fails
Our support tech that was working with the customer installed Windows updates and restarted the computer. Problem continued. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Ted Roche Sent: Thursday, February 28, 2019 1:26 PM To: profoxt...@leafe.com Subject: Re: Old VFP8 app on a Windows 7 computer suddenly fails This is a "dependency not met" error. Did the client try turning off and turning on the machine? Often (VERY often, lately) MS Update fubars a file and rebooting fixes it. On Thu, Feb 28, 2019 at 12:24 PM Tracy Pearson wrote: > Customer upgraded to our latest version using VFP 9. So the machine is not > going to be something I look at again. > But, any input on this would be worth having in the back of my mind for > next > time. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy > Pearson > Sent: Thursday, February 28, 2019 11:56 AM > To: profoxt...@leafe.com > Subject: Old VFP8 app on a Windows 7 computer suddenly fails > > It won't start. AVG is installed. > > Here's the details from the Event Viewer message > > http://schemas.microsoft.com/win/2004/08/events/event;> > - > > 26 > 4 > 0 > 0x80 > > 907913 > System > Owner-PC > > > - > pcplus9.exe - Application Error > The application was unable to start correctly (0xc07b). Click > OK > to close the application. > > > > We are currently seeing if the customer will upgrade to our latest version > which is running VFP 9. And uninstalling AVG. > > Any thoughts? > > > [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/000c01d4cf98$c22bb550$46831ff0$@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.
Re: [NF] Learn about Stored Procedures
Holy Crap Stephen - that's a DAMN Funny comic! I love it!!! Even my son is familiar with XKCD! To make my reply even MORE Interesting - and a comment I am DAMN SURE that Ed would appreciate - truth is - my son is a bit of a computer expert now, in some way. Since, you see - he's actually a Python programmer! And, has been using Python for over 2 years - and has done a TON of programming in Python for Condensed Physics Matter research and data analysis! Although - honestly - I should make a New Thread about this. Since there is a bit of additional info I could relate about it! -K- On 2/28/2019 6:45 AM, Stephen Russell wrote: Sprocs are great because they make it much harder to hack into your backend data. Nothing new here, right? https://www.xkcd.com/327/ ___ 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/921addcb-bd24-bc81-77c0-67d668a9b...@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.
Re: Old VFP8 app on a Windows 7 computer suddenly fails
This is a "dependency not met" error. Did the client try turning off and turning on the machine? Often (VERY often, lately) MS Update fubars a file and rebooting fixes it. On Thu, Feb 28, 2019 at 12:24 PM Tracy Pearson wrote: > Customer upgraded to our latest version using VFP 9. So the machine is not > going to be something I look at again. > But, any input on this would be worth having in the back of my mind for > next > time. > > -Original Message- > From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy > Pearson > Sent: Thursday, February 28, 2019 11:56 AM > To: profoxt...@leafe.com > Subject: Old VFP8 app on a Windows 7 computer suddenly fails > > It won't start. AVG is installed. > > Here's the details from the Event Viewer message > > http://schemas.microsoft.com/win/2004/08/events/event;> > - > > 26 > 4 > 0 > 0x80 > > 907913 > System > Owner-PC > > > - > pcplus9.exe - Application Error > The application was unable to start correctly (0xc07b). Click > OK > to close the application. > > > > We are currently seeing if the customer will upgrade to our latest version > which is running VFP 9. And uninstalling AVG. > > Any thoughts? > > > [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/CACW6n4sD8z5U42zs6h_NK=phvwupzztvwjt0b4idn6swfw-...@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.
RE: Old VFP8 app on a Windows 7 computer suddenly fails
Customer upgraded to our latest version using VFP 9. So the machine is not going to be something I look at again. But, any input on this would be worth having in the back of my mind for next time. -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Tracy Pearson Sent: Thursday, February 28, 2019 11:56 AM To: profoxt...@leafe.com Subject: Old VFP8 app on a Windows 7 computer suddenly fails It won't start. AVG is installed. Here's the details from the Event Viewer message http://schemas.microsoft.com/win/2004/08/events/event;> - 26 4 0 0x80 907913 System Owner-PC - pcplus9.exe - Application Error The application was unable to start correctly (0xc07b). Click OK to close the application. We are currently seeing if the customer will upgrade to our latest version which is running VFP 9. And uninstalling AVG. Any thoughts? [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/000701d4cf8a$53e6d420$fbb47c60$@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.
Old VFP8 app on a Windows 7 computer suddenly fails
It won't start. AVG is installed. Here's the details from the Event Viewer message http://schemas.microsoft.com/win/2004/08/events/event;> - 26 4 0 0x80 907913 System Owner-PC - pcplus9.exe - Application Error The application was unable to start correctly (0xc07b). Click OK to close the application. We are currently seeing if the customer will upgrade to our latest version which is running VFP 9. And uninstalling AVG. Any thoughts? ___ 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/000601d4cf86$85ced900$916c8b00$@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.
[NF] Learn about Stored Procedures
Here is a very simplistic tutorial on how to make stored procedures in SQL SERVER. You can apply the same concept to most other RDBMS you want to use. https://www.mssqltips.com/sqlservertutorial/168/different-options-for-creating-sql-server-stored-procedures/ If you do this you can stop writing SQL CODE in VFP and pass it to the backend where that db engine has to make a plan to execute the query every time. If you have that SQL Code in a stored procedure the db engine can look it its stats to determine the best plan to execute the code. I have some long stored procedures that are in the 3000 lines long arena that are called for every Bill of Lading report we print. Granted it combines Sales data, testing data, item specifications data as well as customer and our employee system data. This generates a CofA or Certificate of Analysis report for every lot number on the truck. Sprocs are great because they make it much harder to hack into your backend data. Nothing new here, right? https://www.xkcd.com/327/ -- 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/cajidmykmoe_tgcd2pqjvqkbjcmbw_xbvd6g5e15jqu3qer7...@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.
Re: Creating a copy of a database -- best practice?
Why not make a compressed file of the entire folder where the data lies? After file is created move it to a different machine off the network. On Thu, Feb 28, 2019 at 4:17 AM Alan Bourke wrote: > Copy and rename all the data and database container files. > > For each DBF in the copied and renamed data, update the backlink so that > it points at your copied and renamed DBC. > Open the copied and renamed DBC as a table, and update the metadata > describing the tables to reflect their new names. > > This is discussed here: > > http://www.ml-consult.co.uk/foxst-47.htm > > > -- > Alan Bourke > alanpbourke (at) fastmail (dot) fm > [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/cajidmy+4ekpeqrf0p4z6u6pixx7oghyqkkdwypz5pzb1w3v...@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.
Re: Creating a copy of a database -- best practice?
Copy and rename all the data and database container files. For each DBF in the copied and renamed data, update the backlink so that it points at your copied and renamed DBC. Open the copied and renamed DBC as a table, and update the metadata describing the tables to reflect their new names. This is discussed here: http://www.ml-consult.co.uk/foxst-47.htm -- Alan Bourke alanpbourke (at) fastmail (dot) fm ___ 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/cebc2b5e-003a-4c60-a708-dbc46f11b...@www.fastmail.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.
Re: Creating a copy of a database -- best practice?
On 27/02/2019 17:22, mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
> I can easily do something like this:
>
> CREATE DATABASE C:\Backup\MyDBC.dbc
> OPEN DATABASE C:\Production\MyDBC.dbc
> liNumTables = adbobjects(laTables,'TABLE')
> for ii = 1 to liNumTables
>lcFile = forceext("C:\BACKUP\" + laTables[ii],'dbf')
>use laTables[ii]
>copy to (lcFile) database C:\Backup\MyDBC.dbc with cdx
>use
> endfor
>
>
> ...and that would get me a copy of all of the tables with their indexes.
> Great. But what's the easiest way to get all of the DBC meta-data into
> that new Backup database copy? I can't USE the MyDBC.dbc and do a COPY
> TO as that only makes the result a DBF and FPT.
>
An easy way to get a copy of the data is to have a copy of all the data
in another folder, then using your loop above, zap each table and append
from the live data. We use it here as a rough and ready backup during
the day, while people are in the system. Your copy then has all the
same meta data as the original.
Peter
This communication is intended for the person or organisation to whom it is
addressed. The contents are confidential and may be protected in law.
Unauthorised use, copying or disclosure of any of it may be unlawful. If you
have received this message in error, please notify us immediately by telephone
or email.
www.whisperingsmith.com
Whispering Smith Ltd Head Office:61 Great Ducie Street, Manchester M3 1RR.
Tel:0161 831 3700
Fax:0161 831 3715
London Office: 101 St. Martin's Lane,London, WC2N 4AZ Tel:0207 299 7960
___
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/ceec749d-28b9-1502-45bd-6796cdf6a...@whisperingsmith.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.
