TSQLQuery Edit Fields Delete field function and add field index error
Original Reporter info from Mantis: saburo
-
Reporter name: Francesco
Original Reporter info from Mantis: saburo
- Reporter name: Francesco
Description:
-
When multiple fields already added are selected and delete is pressed, only one is removed
-
When adding fields from the list of available to the list of the selected one, the aded field is the one before the selected, selecting the first returns an error
Steps to reproduce:
Add a for, a TSQLQuery to it, assign a sql to return some data (used mysql : select * from CONTACT).
Right click on TSQLQuery, select add fields
Add several fields and check the added field is not the one selected
In the added fields, select all of them and click delete -> only one is removed
Additional information:
tested on mysql 5.0 with the following table :
-----------------------
CREATE TABLE `CONTACT` (
`CONTACT_ID` int(11) NOT NULL AUTO_INCREMENT,
`MANAGER_CONTACT_ID` int(11) DEFAULT NULL,
`CONTACT_FIRST_NAME` varchar(100) DEFAULT NULL,
`CONTACT_LAST_NAME` varchar(100) DEFAULT NULL,
`ORG_ID` int(11) DEFAULT NULL,
`CONTACT_TITLE` varchar(250) DEFAULT NULL,
`PROJECT_ROLE_ID` int(11) DEFAULT NULL,
`EMAIL` varchar(100) DEFAULT NULL,
`PHONE` varchar(50) DEFAULT NULL,
`NOTE` text,
`UPDATE_WHEN` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`CONTACT_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=latin1
Mantis conversion info:
- Mantis ID: 16813
- OS: Linux
- OS Build: Ubuntu 10.4 64 b
- Build: 22277
- Version: 0.9.28.2