No announcement yet.

Database builder issues

  • Filter
  • Time
  • Show
Clear All
new posts

  • Database builder issues

    Has something changed? If I create a table then new lines do not appear automatically any more. I can live with that. But if I want to add a primary key I can only add one field. After save I can modify the primary key, but the generated sql contains errors. I'm working with MySQL, anybody else?

    Incorrect index name 'PRIMARY' 14:28:21 SQL command

    ALTER TABLE `wfmailtemplate`
    ADD PRIMARY KEY `PRIMARY` (`herkomst`, `mailid`),

    I tried MyISAM and InnoDB, both give same results.

    I managed to create the primary index by fiddling with the menus, but this way the database builder is completely useless.
    Last edited by aducom; 01-30-2015, 02:34 PM.
    Albert Drent
    aducom software netherlands
    scriptcase partner, reseller, support and (turn-key) development /

  • #2
    Database Builder - INDEX space still allows ONLY ONE FIELD to be used as INDEX KEY - It's not possible to add more fields. SC Version 8.00.0043

    Often an index is made up of several fields. You can not create indexes with multiple fields using Scriptcase Database Builder.