I am new to Delphi but it is great for knocking out a quick query from Paradox.
I attach the code on a button which pulls data from 2 tables; Orders and dates.
You will note that the SQL WHERE command is month = 8.
I would like to change this to read the value of an Edit field on the form, so a user can select a month. So month = (Edit1.value).
I have looked at Tparams but my head hurts.
Could anybody point me the way forward, please? Note the month is an accounting month, not calender month so I cannot play with a date field.