Hi all.
I have a very simple Windows form.
This contains one textbox and a Datagridview. This will be using ODBC to an AS400 table which is already set up.
I want to add an SQL where statement where it brings only the record based on the textbox.
I can do this very easily in .Net just not sure how to go about this in Windows forms?
The SQL statement this is what I am trying to create.
SELECT AMFLIB.MOMASTLB.ORDRMY as Order, AMFLIB.MOMASTLB.FITMMY as Item, AMFLIB.ITEMASA.ITDSC as Description
FROM AMFLIB.MOMASTLB INNER JOIN AMFLIB.ITEMASA ON AMFLIB.MOMASTLB.FITMMY = AMFLIB.ITEMASA.ITNBR
WHERE (((AMFLIB.MOMASTLB.ORDRMY)=?))