I am using advantage data architect it is very diffifult to use it does not provide table design and how to modify the column data type i have given a data type of Blod whcih i want to change boolean
how to do when i do it says
"
poQuery: Error 7200: AQE Error: State = 42000; NativeError = 2115; [iAnywhere Solutions][Advantage SQL Engine]Expected lexical element not found: Expecting either "ADD", "ALTER", or "DROP". -- Location of error
in the SQL statement is: 13
"
below my query
ALTER TABLE UsersDetails MODIFY IsNever BOOLEAN