Home
Top.Mail.Ru Yandeks.Metrika
Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Down

Once again work with bases Find similar branches


set   (2001-12-05 00:08) [0]

There is a small program for working with databases. It is necessary that at its every launch it checks the presence of its bases with which it works (and their 25-35 pieces) and statistics, for example, checks are shown, say, in the Label or (it seems) in statusbare or somewhere else. And yet, if the database is not found or is damaged, so that it would ask the user for permission to restore the database from the archive. And how to make the program automatically save its database in a special archive on disk, and when needed, it could restore the database from the same archives.
If possible, the answer in the box: izak@bk.ru.
I understand that I have got everyone, but I need an exhaustive answer, but I simply don’t have enough time. I asked everywhere, but almost no one knows



Igorok   (2001-12-05 10:39) [1]

I once had to do the same in FoxPro, came out of this situation like this:
I iterate through the bases, usually they are located in the same directory, and I open each base. If the base is damaged then when you open it there will be an error that you write to the log or show on the screen in the way that suits you best.
Good luck!



panov   (2001-12-05 12:20) [2]

1. Integrity check
-------
In a database such as Paradox and DBase, you can check it only by reading each table from beginning to end.
If the header is damaged, an error will appear immediately upon opening the table.

2. Preservation.
-------
It is best (in my opinion) to keep the list of tables and indexes in a separate file and check at program start through the list.
To save, use either standard utilities (PKZIP25, ARJ, RAR, etc.) or FreeWare components, which are sufficient on Internet.
Daily we carry out procedure of archiving.
3. Recovery.
If an error is detected (see section 1), we restore all tables from the last archive.



Pages: 1 whole branch

Forum: "Bases";
Current archive: 2002.01.08;
Download: [xml.tar.bz2];

Top





Memory: 0.55 MB
Time: 0.021 c
6-22276
Lamok
2001-10-05 23:13
2002.01.08
Sending data to the Internet


3-21942
Rev
2001-12-03 12:19
2002.01.08
Good people help with the stored procedure.


4-22493
mangoost
2001-11-05 12:06
2002.01.08
How to bypass an access violation while attempting to write (+)


7-22419
Pastor
2001-09-21 10:31
2002.01.08
Do I have a Celeron 800 worth upgrading to the Pentium III 800?


14-22365
Ketmar
2001-10-16 06:22
2002.01.08
Here it is interesting: from Simferopol, am I here alone?





afrikaans albanian Arabic armenian azerbaijani basque belarusian bulgarian catalan Chinese (Simplified) Chinese (Traditional) croatian Czech danish Dutch English estonian filipino finnish French
galician georgian German greek haitian Creole hebrew Hindi hungarian icelandic Indonesian Irish italian Japanese Korean latvian lithuanian macedonian malay maltese norwegian
persian polish portuguese Romanian russian serbian slovak Slovenian Spanish swahili Swedish Thai turkish Ukrainian urdu Vietnamese welsh yiddish bengali bosnian
cebuano Esperanto gujarati hausa hmong igbo javanese kannada Khmer lao latin maori marathi mongolian nepali punjabi somali tamil telugu yoruba
zulu
English French German Italian Portuguese Russian Spanish