Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
13
Erster Beitrag:
vor 10 Monaten, 1 Woche
Letzter Beitrag:
vor 10 Monaten, 1 Woche
Beteiligte Autoren:
Shijo S Philip, GuenterP, Steven Sitas

[WD20] HChangeDir()

Startbeitrag von Shijo S Philip am 10.10.2016 05:20

Hi All,


Is HChangeDir() works with other databse's like PostgreSQL and oracle. I tried but no directory created in database. Currently am converting my existing HFSQL database to PostgreSQL and oracle. In HFSQL database i had several sub directories with same datafiles.

Please Suggest is there any Solution to manage this.

Thank you

Shijo S Philip

Antworten:

Hi, I explicitely warn you to use subdirectories in any database and yes, in HFSQL too. I've had some very unpleasant experiences which taught me to stay with the single directory of the database. Advice: make other databases besides the one which you're using, use a naming scheme for accessing them, but do not start to make "trees" of database directories! (I found out - the hard way - that several commands did not work as expected with subdirectories of a database directory)

von GuenterP - am 10.10.2016 06:05
Hi Guenter Predl,

Thanks for your reply.

In HFSQL am using this sub directories and its working good. There is no issue reported since from my existing customers. I done this because of heavy data. Currently i want to move PostgreSQL and Oracle. Can u please suggest any solution for this.

Thank You

Shijo S Philip

von Shijo S Philip - am 10.10.2016 06:28
Can u please suggest any solution for this.

No. Sorry. I do avoid any subdirectories in all databases ...

Hi, the only solution is to make other database directories and use proper naming conventions to connect to them. If it's impossible in Oracle or Postgresql to switch to a subdirectory then this should be a hint to you that subdirectories are not a good way there. What's so difficult in switching from \MyDatabase\MyData2015 to \MyDatabase and \MyData2015 ?

von GuenterP - am 10.10.2016 07:12
Thanks Guenter Predl for your suggestion.


Shijo S Philip

von Shijo S Philip - am 10.10.2016 07:49
Hi Shijo,

I think you have "confused" everyone with what you are asking - and probably Guenter also.
There are 2 types of HFSQL databases:
1. The Classic one - where you can use HChangeDir(). Everything here is BASED on directories etc ..
2. The C/S one - where you DON'T use HChangeDir etc. Everything is CONTROLLED by the HFSQL C/S Engine - you just POINT to a DATABASE.
Where these DATABASEs are stored is NOT of ANY VALUE to our program logic.

Now with ANY type of C/S Engine (like ORACLE or PostgreSQL) it works the same as [2] - HFSQL C/S

I thing it is better for you to first do a HFSQL C/S implementation of your HFSQL Classic implementation - to see how things work - and then MOVE to Oracle etc

Steven Sitas
www.alpha360.biz
The Open Source ERP

von Steven Sitas - am 10.10.2016 08:14
Hi Steven Sitas,

Am already working in HFSQL C/S and that work good. The problem is when i move to other databases HChangeDir() is not working.Cant create Directory in other databases and Cant change Directory. I need solution for this.

Thank You

Shijo S Philip

von Shijo S Philip - am 10.10.2016 08:24
Hi Shijo,

totally lost you ..
Where are you using HChangeDir() with HFSQL C/S ?

Steven Sitas
www.alpha360.biz
The Open Source ERP

von Steven Sitas - am 10.10.2016 08:55
Hi Steven,

in fact it is possible to make subdirectories of a database directory. As an example, for accounting like for 2011, 2012, 2103, ..

\GenLedger

von GuenterP - am 10.10.2016 13:15
Hi Guenter Predl,

I didnt understand your solution. Can u please give a brief explanation.


Thank you

Shijo S Philip

von Shijo S Philip - am 10.10.2016 13:32
Hi Guenter,
thanks for the info.
It still looks VERY STRANGE to me, to be able to use directories this way in a Client Server Engine.

Steven Sitas
www.alpha360.biz
The Open Source ERP

von Steven Sitas - am 10.10.2016 17:01
Hi Steven,

for backup / restore purposes it seems to be the "natural" way indeed, just a single directory to save, no problems for that. In the old forum, as I remember now, I detailed the shortcomings and functional deficiences of such a setup. A few h-commands did not work correctly, so I had to change the setup and it worked fine then - as expected.

von GuenterP - am 11.10.2016 06:00
Hi Shijo,

the short explanation ist: subdirectories in a database setup do not work. Use single directories!

von GuenterP - am 11.10.2016 06:04
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.