Hi i made an application in BCB6 for save records in database
I have one field pSize and i made the above query:
ADODataSet1->CommandText= "SELECT * FROM Pictures WHERE pSize>="+Edit1->Text;
With this query user type a size in Edit1->Text and in DBgrid gets all the records that have bigger size from Edit1->Text
Now i have 2 questions
1)How i can do the above by using 2 Edit1->Text and Edit2->Text so the user can find records between 2 sizes
2)How i can return in DBGrid the record with MAX size and MIN size
All i ask is the syntax in my two questions in Command->Text
Thanks