Announcement

Collapse
No announcement yet.

Database builder issues

Collapse
X
  • 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`),
    DROP INDEX `PRIMARY`;

    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
    www.scriptcase.eu / www.scriptcase.nl

  • #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.

    Comment

    Working...
    X