Dennis_Treacy
asked on
Sort ADO Table
How do you sort an ADO table when the field name has a gap in the name ie 'Field Name', not 'Field_Name'
I know ADOTable.Sort := 'Field_Name ASC' will sort Fleld_Name, but what about 'Field Name'?
I have tried ADOTable.Sort := '[Field Name] ASC' and a few other combinations.
Ā
I know ADOTable.Sort := 'Field_Name ASC' will sort Fleld_Name, but what about 'Field Name'?
I have tried ADOTable.Sort := '[Field Name] ASC' and a few other combinations.
Ā
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I will get back to you. I think you are right.
ASKER
Yes, you are right. I had another error my end. Your comment made me go back and check some other code.
Thanks.
Thanks.
ASKER