This topic is locked

Show On Filter Panel not working in Asprunner 9.7

6/20/2017 2:29:11 PM
ASPRunnerPro General questions
B
blalor author

Had project created in ASPRunner 9.5 and now opening it in ASPRunner 9.7 and trying to add field to "Show on Filter Panel".
Am getting the error message:
"Failed adding field to login table. The current database does not support this operation. You can create scripts manually. Please see documentation."
Have looked in the documentation and do not find anything related to this topic.
Any ideas?
Thanks, Bill

admin 6/20/2017

Here is the database structure for MySQL. Modify it for your database, change settings table name and create table manually.

CREATE TABLE `<project name>_settings`

(`ID` int NOT NULL AUTO_INCREMENT,

`TYPE` int NULL DEFAULT 1,

`NAME` mediumtext NULL,

`USERNAME` mediumtext NULL,

`COOKIE` varchar(500) NULL,

`SEARCH` mediumtext NULL,

`TABLENAME` varchar(300) NULL,

PRIMARY KEY (`ID`))

CHARACTER SET utf8;


What database do you use btw?

B
blalor author 6/21/2017

Hi Sergey... I'm using SQL Server 2014.
I reopened the project in ASPRunner 9.5 and it worked perfectly, which indicates to me the issue is not on the database side but rather in the ASPRunner 9.7 side.

admin 6/21/2017

ASPRunnerPro 9.5 didn't have the feature you trying to use in ASPRunnerPro 9.7. It is very strange though ASPRunnerPro doesn't recognize SQL Server database.