| |
| Publicado el 18,julio 2017 - 06: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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 08:39 |
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... |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 14:18 |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 15: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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 17:50 |
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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 18:01 |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 21:43 |
Hi Piet,
A user from the Netherlands also.?! I was a Clarion developer for 25 years and now switched to windev. I hope I don't get disappointed.
I use MSSQL as a backend. I use no real foreign keys on part id etc in the database it self. In the clarion dictionary I defined keys but they are not really created. Do I have to add keys in the analysis or just select a join field?
Best regards
Walter |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 21:56 |
| Where to do a quick search on Fabrice . We don't know where to look for in French.. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 18,julio 2017 - 22:57 |
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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2017 - 06: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. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2017 - 07:30 |
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 . |
| |
| |
| | | |
|
| | |
| |
| Publicado el 19,julio 2017 - 14:21 |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
4 mensajes |
|
| Publicado el 19,julio 2017 - 19:44 |
First, PCSoft emailed that a fix is coming perhaps by tomorrow. I know software releases are actually hard to get out the door so I understand if the miss by a day or so.
Second, There are a couple of workarounds. The easiest is to create the Query in v21 and import it in. A possible way around it to manually edit the SQL and then try to reverse engineer it back. I find it unreliable. I have made what seemed to be simplest change and have it say it can't and then it will occasionally work. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 12:05 |
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 |
| |
| |
| | | |
|
| | |
| |
| Publicado el 20,julio 2017 - 13:26 |
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 ... |
| |
| |
| | | |
|
| | |