Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
4
Erster Beitrag:
vor 8 Monaten, 2 Wochen
Letzter Beitrag:
vor 8 Monaten, 2 Wochen
Beteiligte Autoren:
Michael Rug, Tor-Bjarne, Peter Holemans

Creating tables in PostgreSQL from Windev

Startbeitrag von Michael Rug am 05.09.2017 04:27

Hello All:

I have an application working with HFSQL classic files and I need to switch to PostgreSQL.
Since the analysis is already created and all tables are defined; is there a way to create those tables in PostgreSQL from Windev? Or any way of generating the SQL to run in the database and create the tables?

Thanks
Michael

Antworten:

Hi Michael,

In the Analysis from one of the menus you can generate the SQL generation script for specific databases.

Note that for some databases you may need to alter the generated script a bit. Don't recall what exactly was the issue (might have been unicode or constraints or so). At least that used to be the case in older WX versions (V18/V19) for MS SQL Server.
Raised a call for that back in the days and if I recall correctly it was more or less solved in later releases (no patch).

Don't have WX at hand here but you should be able to find it in the Analysis menu/ribbon somewhere under the generation options.

Cheers,

Peter

von Peter Holemans - am 05.09.2017 07:35
Hi,

Usually if the (empty) database is created and is connected you can do a HCreationIfNotFound("*") and all your tables shuld be created in Postgre/MS-SQL etc.

Cheers
Tor-Bjarne

von Tor-Bjarne - am 05.09.2017 11:15
Hello Peter:

Thanks. I couldn't find those scripts...

Tor-Bjarne:
Thanks. This worked well.

Regards;
Michael

von Michael Rug - am 05.09.2017 17:30
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.