Page 4 of 4

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 2:08 pm
by 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

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 2:46 pm
by 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

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 3:43 pm
by 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

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 3:58 pm
by Rathinagiri
Thanq Esgici.

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 4:00 pm
by 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

Re: How to Avoid Data Corruption

Posted: Wed Apr 01, 2009 4:24 pm
by esgici
sudip wrote:
... clients are same in all countries!!! ;)
Yes, fools too :D

Regards

--

Esgici

Re: How to Avoid Data Corruption

Posted: Sun Apr 05, 2009 8:18 pm
by 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...

Re: How to Avoid Data Corruption

Posted: Sun May 24, 2009 3:24 pm
by 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

Re: How to Avoid Data Corruption

Posted: Mon May 25, 2009 4:16 am
by swapan
Thanks Jayadev for the info.

Re: How to Avoid Data Corruption

Posted: Mon May 25, 2009 6:28 am
by swapan
I was not aware of OTC Mediator. Interesting!