Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
12
Erster Beitrag:
vor 3 Monaten
Letzter Beitrag:
vor 3 Monaten
Beteiligte Autoren:
Robert Willis, Fabrice Harari, Mark Crichton, GuenterP, Erik Schwarz, steve erts, Piet van Zanten, ccc2

WD V22 Edit Join change is so bad its on par for when I left Clarion

Startbeitrag von Robert Willis am 18.07.2017 04:52

V22 show that editing joins in the query builder now ONLY supports the primary key of the table. As I'm sure most know the primary key of two tables are rarely the thing you join on. How did PCSoft think this was a good idea.

I personally feel like I completely wasted not only the money I spent for the V22 upgrades, but 21,20,19, and my initial purchase PLUS the 4 years of my life learning this.

PCSoft doesn't care about its customers or they would have said "Hey we're thinking of this is good thing right?" rather than we know better, and here you are. now pay us and fuck off.

Antworten:

Hi Robert

Just tried it out , and you are right. Something has gone wrong. I'm sure it's not by design.
Don't loose the faith... Maybe just report the bug...

von Mark Crichton - am 18.07.2017 06:39
Hi guys,

You are missing something here.
In WX22 you can still edit the join by right clicking on it.
Then you can create a selection condition for the join by choosing the files and items to join on.
Your confusion may be caused by the gui being changed into creating a selection condition instead of creating a link.

Kind regards,
Piet

von Piet van Zanten - am 18.07.2017 12:18
Hi guys,

there is a thread about that on the french forum, and, if I remember correctly, there is a temporary workaround while pcsoft is working on the problem,

So if you want to do a quick search and google translate...

Best regards

von Fabrice Harari - am 18.07.2017 13:18
Piet,

The problem is not that you can edit the join its the fact you are ONLY presented with the primary key column as a choice. No other columns are available to select.

I 100% work with SQL server and did find a HFSQL that did work correctly under v22.

von Robert Willis - am 18.07.2017 15:50
Fabrice

I don't see any work arounds rather bad news. Looks like someone claimed it would be in 71s but didn't make it. I do see how PCS are jerks when they want you to create a project and screenshots proving it doesn't work instead of believing many people reporting the same.

This is why I don't submit support tickets. I did one two weeks ago and they wanted me to do the work for them to prove it doesn't work.

https://forum.pcsoft.fr/en-US/pcsoft.fr.windev/207167-rubriques-jointures-dans-editeur-requete/read.awp

von Robert Willis - am 18.07.2017 16:01
Hi All

If just using HFSQL, then the quickest workaround, is to edit the sql directly, to correct the link, and then reverse engineer it. Thats available still via Right Click. Sometimes reverse engineering fails, so have to be careful with syntax. I copy and paste into HFSQL Control Centre for testing and that gives great error messages. HFSQL CC is an excellent tool.

von Mark Crichton - am 18.07.2017 20:57
I have purchased 22 but have not yet installed but will say that while I'm not one to spend much time beating up on WD as it works pretty well for me I'm appalled that such a bug as this could make it through to a final version of the IDE.

von steve erts - am 19.07.2017 04:57
Quote
Robert Willis
Piet,

The problem is not that you can edit the join its the fact you are ONLY presented with the primary key column as a choice. No other columns are available to select.

I 100% work with SQL server and did find a HFSQL that did work correctly under v22.


Hi Robert,

if you are using external DB like sql server / mysql/postgresql, you can just add the field as duplicate key in wd dictionary . unlike in HF , it doesn't create actual key , for external db , key in WD has very little purpose.

another method is edit the sql .

von ccc2 - am 19.07.2017 05:30
Hi Fabrice,

if I read correctly the last entry (a Little bit of French is mine) PCS offers a (French) Version 71k, where the Problem is solved.
Will this Version be available in english some time, too?

greetings

Erik

von Erik Schwarz - am 20.07.2017 10:05
Hi Erik,

outside of summer's seasonal holidays the time difference between French and English updates is about 2 weeks. Maybe, it will take three weeks now ...

von GuenterP - am 20.07.2017 11:26
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.