SECURITY module not working with existing tables

Scriptcase 8 Bugs
#1

This is my third attempt (after SC7) to implement security module. Unfortunately after multiple reports to NetMake this feature is still full of bugs.
I have a table with the following structure


CREATE TABLE IF NOT EXISTS `klon56_tecrep`.`sec_users` (
  `StaffID` INT(11) NOT NULL AUTO_INCREMENT,
  `login` VARCHAR(150) NULL,
  `pswd` VARCHAR(150) NULL,
  `name` TEXT NULL,
  `email` TEXT NULL,
  `usr_active` TEXT NULL,
  `activation_code` TEXT NULL,
  `priv_admin` TEXT NULL,
  `CompanyID` INT(11) NULL,
  `FirstName` VARCHAR(45) NULL,
  `LastName` VARCHAR(45) NULL,
  `Picture` BLOB NULL,
  `AdminFlag` CHAR(1) NULL DEFAULT NULL,
  `Language` VARCHAR(30) NULL DEFAULT NULL,
  `Signature` VARCHAR(255) NULL DEFAULT NULL,
  `RegistrationDate` DATE NULL,
  `Active` VARCHAR(1) NULL,
  `Continent` VARCHAR(45) NULL,
  `Country` VARCHAR(45) NULL,
  `Region` VARCHAR(45) NULL,
  `ZIP` VARCHAR(45) NULL,
  `Town` VARCHAR(45) NULL,
  `Street` VARCHAR(45) NULL,
  `HomePhone` VARCHAR(45) NULL,
  `BusinessPhone` VARCHAR(45) NULL,
  `CellPhone` VARCHAR(45) NULL,
  `Fax` VARCHAR(45) NULL,
  `EmergencyPhone` VARCHAR(45) NULL,
  `AccessLevel` INT NULL,
  `Stamper` TIMESTAMP NULL,
  `OperatorID` INT NULL,
  INDEX `OperatorIDIDXa` (`OperatorID` ASC),
  PRIMARY KEY (`StaffID`),
  CONSTRAINT `StaffID2StaffRoles_KEY`
    FOREIGN KEY (`StaffID`)
    REFERENCES `klon56_tecrep`.`S_staffroles` (`StaffID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `Stuff2Customers_KEY`
    FOREIGN KEY (`StaffID`)
    REFERENCES `klon56_tecrep`.`CRF_stuffcust` (`StaffID`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
AUTO_INCREMENT = 11

When I try to use this table the fields that are used for the Security Module aWe not visible (although they are present within physical table).
I remember similar problem about year ago. I reported this to NetMake but unfortunately looks like fixing bugs is the last thing they are willing to do.
Am I doing something wrong or this is just a bug that needs to be fixed ASAP. At this point the whole security module is useless

ARTHUR

#2

I would start with SC to generate a standard security module with tables and look if that works well. Besides a bug in the synchronize table (to be repared this week I was promissed) the module works as expected although it might not be sufficient in certain needs. Scriptcase does not generate a userid of 150 chars, so yes, there might be some fiddling involved.