Hi guys,
I'm hoping you can help here with a problem I am having with regards to filling a Dataset.
It was working fine but have had to amend the code to read a different data set and structure.
Basics are 2 tables.. one customers, 1 orders. Joined on there Account Reference. SQL seems to be working correctly.
See below:
SELECT cashID, cashQTY, cashDescription, cashSupplier, cashDate, cashCost, cashSell, CashAccountRef_FKID from cashOrders INNER JOIN CashCustomers ON cashOrders.CashAccRef_FKID=cashCustomers.CashAccRef WHERE cashCustomers.CashAccRefID = @HOME
But I get "No value given for one or more required parameters."
DB table layout seems correct. I'm sure Im just having a "Moment" but can anyone spot what I'm doing wrong.
Attached some screenshots as well
Thanks for any help in advance.
Regards
Mark.