How to Avoid Data Corruption

[sudip]

Hello Roberto,

Roberto wrote:
I've not tested yet (I've read the thread about it in Harbour developers list and took a brief look at the sources) but I guess that the performance depends on the recordset that you use.

The 'easy way' will be always use 'SELECT *...' in your USE command (my preferred way ) but maybe, that under certain conditions we must 'refine' our query to obtain acceptable results (Remember: I've not tested yet).

Note: I've had a PAINFUL experience with VFP too

Thank you very much for your message. I shall use "use 'SELECT *...'" in my USE command

I just ran HbSqlDD using MiniGui Extended (with the help of Mitja Podgornik from Minigui Group). It's really excellent!!!

But, how long we have to wait???

Hello Gregory,

I tested HbSqlDD sample with MiniGui Extended. I ran other samples of MySql given in Minigui\Samples\Basic even before I joined this forum. But I never ran HbSqlDD.

Thank you again. I don't know whether it is possible or allowed to use HbSqlDD with HMG. (it may sound childish, but I can't resist myself ).

With best regards to all.

Sudip

[sudip]

Hello Grigory,

Thank you so much! Finally I ran the sample!!!

Excellent!!! Now, our old programs can run on MySql "efficiantly"

Please don't mind. Actually I had a very bad experience about VFP RemoteView, so I was skeptic about it before testing.

I don't know how long I have to wait to get this included in HMG?

Thank you very much.

With my deepest regards.

Sudip

[esgici]

Hi Sudip

A late answer to your question in the tittle of this topic:

- Every electric/electronic device stored into valuable data, MUST supplied by a UPS ( Uninterrupted Power Supply ) device.

- For valuable data, adequate backing-up is always unavoidable. Users / clients are always negligent and unreliable for this duty. Moreover, they are always blaming you. So, you need build and implement your backup strategy by yourself.

- Use COMMIT command after every disk-write operation.

I hope that this humble advices will help you.

Regards

--

Esgici

[Rathinagiri]

Thanq Esgici.

[sudip]

Hi Esgici,

A late answer to your question in the tittle of this topic:

- Every electric/electronic device stored into valuable data, MUST supplied by a UPS ( Uninterrupted Power Supply ) device.

- For valuable data, adequate backing-up is always unavoidable. Users / clients are always negligent and unreliable for this duty. Moreover, they are always blaming you. So, you need build and implement your backup strategy by yourself.

- Use COMMIT command after every disk-write operation.

I hope that this humble advices will help you.

Thanks for coming to original topics.
Your advices are not "humble" to me. They are very precious.
After reading you message I must say that clients are same in all countries!!!

Thanks a lot!

Sudip

[esgici]

... clients are same in all countries!!!

Yes, fools too

Regards

--

Esgici

[hugohidalgoc]

Hi

anybody using hbsqldd in xharbour
i run the tests of hbsqldd in harbour using HMG EXTENDED
all test run nice
but i am using xharbour,
i try to generate the lib to xharbour and obtain a lot of errors

how can i have the lib hbsqldd

best regards hugo hidalgo c...

[jayadevu]

Hi All,

MySQL+HMG is a good combination. May I add OTC Mediator also to the list.

This product is free for MYSQL connections and frees us programmers from the hassles of changing our database commands for use with SQL. Most of the commands work as it is. Mediator also provides recno() function which is absent in RDMS environment.

Mediator also has a very good support system. I had earlier used the product for query with MS Sql 7.

Now I am experimenting with MYSQL+xHarbour+HMG Extended.

In the HMG Extended group, I have found the many have actually used the combination well.

Just my two cents.

Warm regards,

Jayadev

[swapan]

Thanks Jayadev for the info.

[swapan]

I was not aware of OTC Mediator. Interesting!