Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
7
Erster Beitrag:
vor 4 Jahren, 5 Monaten
Letzter Beitrag:
vor 4 Jahren, 5 Monaten
Beteiligte Autoren:
Yogi Yang, Markus K., Stefan Bentvelsen, Paulo Oliveira

Query not working

Startbeitrag von Yogi Yang am 21.06.2013 13:21

I have built this query with parameter by hand as I could not get the Query editor to build a query with Join.

SELECT
DhwajajiSlotMaster.DhwajajiSlotNum AS DhwajajiSlotNum,
DhwajajiBooking.DhwajajiBookingID AS DhwajajiBookingID,
DhwajajiBooking.DhwajajiBookingDate AS DhwajajiBookingDate,
DhwajajiBooking.DhwajajiBookerName AS DhwajajiBookerName,
DhwajajiBooking.DhwajajiDepositAmount AS DhwajajiDepositAmount,
DhwajajiBooking.DhwajajiLagoAmount AS DhwajajiLagoAmount,
DhwajajiBooking.DhwajajiPaymentMode AS DhwajajiPaymentMode,
DhwajajiBooking.DhwajajiBankName AS DhwajajiBankName
FROM
DhwajajiBooking
INNER JOIN DhwajajiSlotMaster ON(DhwajajiBooking.DhwajajiSlotID = DhwajajiSlotMaster.DhwajajiSlotMasterID)
WHERE
DhwajajiBooking.DhwajajiBookingDate = {Param1}

This query work when the software is run but it returns all the rows and it does not run in the IDE.

Here is the partial screen shot of Analysis...
[attachment 442 2013-06-21_184653.jpg]

I keep getting this error when I try to run this query directly in WD by pressing F9
[attachment 443 2013-06-21_184839.jpg]
[attachment 444 2013-06-21_184928.jpg]

What must be the problem?

Any help will be appreciated.

TIA

Yogi Yang

Antworten:

Hi Yogi Yang,

what had you expected as result of the query ?

Are there records in the resultset with a wrong date or with wrong DhwajajiSlotMaster.DhwajajiSlotMasterID ?

von Stefan Bentvelsen - am 21.06.2013 18:00
What is the value in the {Param1}when you run the query in your program?
if you don't set it to anything null it will return all the rows.

von Paulo Oliveira - am 21.06.2013 18:19
Quote
Yogi Yang
I have built this query with parameter by hand as I could not get the Query editor to build a query with Join.


You can configure the joins after closing the window in which you choose the files and conditions. In the graphical view of the query you can select the little box named join and configure them.

von Markus K. - am 22.06.2013 10:25
Sorry I cannot find Join Box.

Can you upload a screen shot of it please.

Regards,

Yogi Yang

von Yogi Yang - am 24.06.2013 06:24


Rightclick on the little box opens the options.

von Markus K. - am 24.06.2013 08:16
@Markus,

Thanks for the info. I never knew one can modify join from here!

Thanks for this tip.

On playing feature with this I observed that WD seems to create only outer type of Left and Right Joins.

I cannot get it to create inner type of joins.

But anyways at lease I learned something new!

Regards,

von Yogi Yang - am 25.06.2013 12:58
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.