<?xml version="1.0" encoding="UTF-8"?>
<rss version="2.0"><channel><category>pcsoft.us.windev</category><copyright>Copyright 2026, PC SOFT</copyright><lastBuildDate>19 Jan 2018 12:43:00 Z</lastBuildDate><pubDate>18 Jan 2018 12:06:00 Z</pubDate><description>Hi,&#13;
The last couple of years we have moved many of our users from applications developed with:&#13;
Clarion (6x) and Btrieve to WinDev (20 or 21) apps and HFSQL C/S.&#13;
Here is what we have found:&#13;
1. Performance and Program versatility -&gt; Winner is HFSQL C/S&#13;
2. "Bomb Proof" -&gt; Winner is Btrieve (C/S or Workgroup)&#13;
&#13;
Under certain conditions, various HFSQL C/S files can GET corrupted.&#13;
We have found that the files that are usually corrupted are the files inside the BDD\__TRS directory of the C/S Engine.&#13;
These are the files supporting Transactions and when they get corrupted everything is a mess.&#13;
&#13;
When does this happen?&#13;
Usually when the server has a power failure or something like that ...&#13;
Of course, we understand that a power failure is not something that should NORMALLY happen in an installation, but it will happen at some time - especially in small installations.&#13;
&#13;
What helps?&#13;
Turning off the Hard disk cache - but NOT always.&#13;
&#13;
Question?&#13;
Anything out there, as bomb-proof as Btrieve, that plays well with WINDEV?&#13;
&#13;
Regards&#13;
Steven Sitas</description><ttl>30</ttl><generator>WEBDEV</generator><language>en_US</language><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp</link><title>How Bomb Proof is HFSQL C/S ?</title><managingEditor>moderateur@pcsoft.fr (El moderador)</managingEditor><webMaster>webmaster@pcsoft.fr (El webmaster)</webMaster><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64107/read.awp</comments><pubDate>19 Jan 2018 12:43:00 Z</pubDate><description>Hm&#13;
&#13;
I always thought that transactions are to be used when more records are red -- and changed in one procedure.&#13;
&#13;
For if it …</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64107/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64107/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64103/read.awp</comments><pubDate>19 Jan 2018 11:44:00 Z</pubDate><description>Hi Steven&#13;
&#13;
&gt;&gt;&#13;
Sales example&#13;
[debit] Accounts receivable $1,050&lt;&#13;
[debit] Cost of goods sold for $650&#13;
[credit] Revenue for $…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64103/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64103/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64102/read.awp</comments><pubDate>19 Jan 2018 11:35:00 Z</pubDate><description>Hi&#13;
&#13;
actually, it's even simpler than that, as EACH local DB contains the WXReplication file. And that file is a full log of al…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64102/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64102/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64097/read.awp</comments><pubDate>19 Jan 2018 10:55:00 Z</pubDate><description>Hi Al,&#13;
what happens if a GL entry has more than 1 Debit or Credit entries, like the following example: (?)&#13;
&#13;
Sales example&#13;
[d…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64097/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64097/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64095/read.awp</comments><pubDate>18 Jan 2018 20:22:00 Z</pubDate><description>Hello Steven&#13;
&#13;
The record contains links to both the credit and debit GL accounts. This makes the system very robust as to chan…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64095/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64095/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64093/read.awp</comments><pubDate>18 Jan 2018 20:15:00 Z</pubDate><description>Hi Al,&#13;
How do you handle Double Entry Accounting without transactions?&#13;
&#13;
Regards&#13;
Steven Sitas</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64093/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64093/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64092/read.awp</comments><pubDate>18 Jan 2018 19:58:00 Z</pubDate><description>Hello All&#13;
&#13;
If it is just the transactions that are the problem then wouldn't it be easier to stop using transactions or code y…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64092/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64092/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64091/read.awp</comments><pubDate>18 Jan 2018 18:41:00 Z</pubDate><description>Hi Art,&#13;
&#13;
replication between two remote servers would do the trick in HFSQL, elegantly too. However, for big datasets and heav…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64091/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64091/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64090/read.awp</comments><pubDate>18 Jan 2018 18:35:00 Z</pubDate><description>Hi Art,&#13;
the files, that we have seen corrupted, are ALWAYS files used by the Client Server Engine to control transactions. They…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64090/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64090/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64088/read.awp</comments><pubDate>18 Jan 2018 18:09:00 Z</pubDate><description>To carry on the bullet proofing of HFSQL...&#13;
&#13;
Quote&#13;
GuenterP&#13;
&#13;
And of course, Btrieve does logging, you can directly rebuild …</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64088/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64088/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64087/read.awp</comments><pubDate>18 Jan 2018 18:03:00 Z</pubDate><description>Hi Steven,&#13;
&#13;
this price (US$ 3.000,- ) is ridiculously high, sorry, no way to further talk about the thing if the price is that…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64087/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64087/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: BTRIEVE is BACK!</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64086/read.awp</comments><pubDate>18 Jan 2018 17:52:00 Z</pubDate><description>http://www.goldstarsoftware.com/btrieve12.asp</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64086/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64086/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: BTRIEVE is BACK!</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64085/read.awp</comments><pubDate>18 Jan 2018 17:46:00 Z</pubDate><description>Hi Guenter,&#13;
If you have any ideas on how to integrate Btrieve/Pervasive (without ODBC) I would be interested ..&#13;
&#13;
Now about th…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64085/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64085/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: BTRIEVE is BACK!</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64084/read.awp</comments><pubDate>18 Jan 2018 17:07:00 Z</pubDate><description>Hi friends,&#13;
&#13;
I spoke to the local distributor of Actian products right now. Asked them to give me the price of a limited distr…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64084/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64084/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: BTRIEVE is BACK!</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64083/read.awp</comments><pubDate>18 Jan 2018 16:31:00 Z</pubDate><description>Hi friends, and now ... ta-taa!&#13;
&#13;
Btrieve 6.15 is back, made compatible with Windows 10 and has been named Btrieve 12 now&#13;
&#13;
ht…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64083/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-btrieve-back-64083/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: BTRIEVE is BACK!</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64082/read.awp</comments><pubDate>18 Jan 2018 16:01:00 Z</pubDate><description>Btrieve claimed to be fastest flat-file db in the world under Novell 4.11 from my memory but it was a painful experience to writ…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64082/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64082/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64080/read.awp</comments><pubDate>18 Jan 2018 14:00:00 Z</pubDate><description>Hi Guenter,&#13;
I can throw a hard disk with Btrieve/Pervasive files in the ocean, I can hit it with a hammer, I can do thousands o…</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64080/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64080/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item><item><author>guest</author><category>pcsoft.us.windev</category><comments>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64079/read.awp</comments><pubDate>18 Jan 2018 13:45:00 Z</pubDate><description>Hi Steven, in the past, for at least 20 years Btrieve has been my *only* database system. Still, about hundred of our customers …</description><guid isPermaLink="true">https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64079/read.awp</guid><link>https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql-64079/read.awp</link><source url="https://forum.pcsoft.fr/es-ES/pcsoft.us.windev/64078-how-bomb-proof-hfsql/read.awp">How Bomb Proof is HFSQL C/S ?</source><title>Re: How Bomb Proof is HFSQL C/S ?</title></item></channel></rss>
