PC SOFT

PROFESSIONAL NEWSGROUPS
WINDEV, WEBDEV and WINDEV Mobile

Home | Recent messages | Connect |  | English US
Home → WINDEV 2024 → MYsql combined databases
MYsql combined databases
Started by Jelte, Jun., 16 2004 1:25 PM - 4 replies
#1
Posted on June, 16 2004 - 1:25 PM
Hello everyone,
As you probably geussed i have a little problem.
I want to retrieve data from 2 differend databases and differend tables. This isnt a problem for mySQL but apperently this is a problem for WinDev 8.0.
What i do is this.
I have a query that goes like this.
Select plaats.plaatsID as PlaatsID,
Straat.straatID as StraatID
>From plaats, stratenboek.Straat
Where Straat.straatID = plaats.straatID
Now in mySQL control center this works fine. I get a list of the ID's i want. But in windev i just get an error saying that straatID cant be found in the Database Plaatsnamen.
Does anyone know a workaround. this is a major problem for us. since its correct SQL language, i thought it would work in WinDev but apperently not.
If you have any idea for a solution please respond.
Thanks
Jelte
#2
Posted on June, 16 2004 - 4:13 PM
try this
HExecuteQuery(queryname,hQueryWithoutHFCorrection,parma1,param2...)

"hQueryWithoutHFCorrection" is the key word
joe
#3
Posted on June, 16 2004 - 4:48 PM
try this
HExecuteQuery(queryname,hQueryWithoutHFCorrection,parma1,param2...)

"hQueryWithoutHFCorrection" is the key word
joe


Good idea,
doesnt work though
Still have the same error, i tried the "hQuerywithoutHFcorrection and the HquerywithoutCorrection. Both with the same result.
any other idea's what could help?
#4
Posted on June, 17 2004 - 4:00 AM
Try this if you haven't
double check to make sure the analysis matches the sql dictionary
delete the file and reimport the file from the analysis
copy the sql code that works into a query editor and use it directly like you
hand coded it
keep me posted
joe
#5
Posted on June, 17 2004 - 11:17 AM
Try this if you haven't
double check to make sure the analysis matches the sql dictionary
delete the file and reimport the file from the analysis
copy the sql code that works into a query editor and use it directly like you
hand coded it
keep me posted
joe


I tried the code in a sql editor, worked fine. It just doesnt work when i try it in WinDev.
The actual code is a bit bigger then the bit i pasted here. But it works fine when i run it out of windev.
I Checked all the caps on the analysis but that wasnt it either.
When i read either of the tables seperate it works fine. its just when i use an combined search that it doesnt work.
In the error message provided by WinDev, it pasted a piece of the SQL code. In that code it removed all the links to the differend databases.
So instead of this:
"From streetbook.StreetID, ZipcodeID"
It pasted this
"From StreetID, ZipcodeID"
ERROR CANNOT FIND zipcodes.StreetID.
So i'm geussing that this is a bug in Windev. since it cannot handle searches in multiple databases on the Native MySQL driver
→ Go back to WINDEV 2024