Hi All
I am quite new to Delphi and finding my way round I have an MS Access database which I need to run on individual machines so I have started rewriting this in delphi.
How do I limit the data displayed I have looked through help and can find no assistance on Queries what I have is a table through an ADO connection this is called Jobtable a DBGrid that displays Jobtable through a datasource, the Information I get is all of the information in Jobtable one of the columns in Jobtable is Customers, customers names can be spelt differently ie they are not on a lookup table as that would reduce data input speed and I do not need any other customer info, I need to display in db grid all those customers whose name begins with H or h and at runtime be able to change that to limit the returned records further, by additional chars i.e. Her, in access the query just used H* or Her*.
Also When I get the records I Need to format the display by colours to individual cells ie in jobtable I have a column called WindQty and a columm called WindProd for each row I need to format the Cell where WindQty > WinProd I want to colour the WindQty cell Red but if WindQty < WindProd colour it Green, I have found info in the forum on formatting the row but have been unable to limit this to individual cells.
A bit of code or other assistance would be greatly appreciated.
Thanks
Graham
I am quite new to Delphi and finding my way round I have an MS Access database which I need to run on individual machines so I have started rewriting this in delphi.
How do I limit the data displayed I have looked through help and can find no assistance on Queries what I have is a table through an ADO connection this is called Jobtable a DBGrid that displays Jobtable through a datasource, the Information I get is all of the information in Jobtable one of the columns in Jobtable is Customers, customers names can be spelt differently ie they are not on a lookup table as that would reduce data input speed and I do not need any other customer info, I need to display in db grid all those customers whose name begins with H or h and at runtime be able to change that to limit the returned records further, by additional chars i.e. Her, in access the query just used H* or Her*.
Also When I get the records I Need to format the display by colours to individual cells ie in jobtable I have a column called WindQty and a columm called WindProd for each row I need to format the Cell where WindQty > WinProd I want to colour the WindQty cell Red but if WindQty < WindProd colour it Green, I have found info in the forum on formatting the row but have been unable to limit this to individual cells.
A bit of code or other assistance would be greatly appreciated.
Thanks
Graham