PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → [WD21][HFSQL21] Query
[WD21][HFSQL21] Query
Iniciado por guest, 10,jun. 2017 14:10 - 1 respuesta
Publicado el 10,junio 2017 - 14:10
Hello,

I write a query, which gets executed in HFSQL without any trouble. When I try to create the same in Windev 21, using New - Query, [Copy & Paste], the query editor suggests a lot of option, which I just want to ignore [let my query be ineffective, just want my query to get executed]. After ignoring the suggestions, when I reopen the query, in query mode, I just see the joins are replaced with some useless one, not the one that I put when creating the query. Is this the behavior of the query editor ? Won't it accept what I write ?

Happiness Always
BKR Sivaprakash
Publicado el 10,junio 2017 - 14:56
Wow,

striked out... I don't remember I've done it.

Sure, query editor adds / replaces with its own joins, in my query. Don't know why ?

One file (x) is joined from two different files (y & z), after reverse engineering, what we see is x joined from y 2 times and the join between x and z removed ....

When there is about 10 joins, after reverse engr, I could see only 7 joins. 3 joins gone...
Don't know how to bring back those joins.....