[mv] Bug report Interchange UI --- mysql table update doesn't work always

[Ton Verhagen <ton@verhagen.net>]

******    message to minivend-users from Ton Verhagen <ton@verhagen.net>     ******

Hi All,

While testing the Interchange UI I encountered something that looks like a bug.

Updating the info in the (mysql) tables works for some tables but not for all.

I have defined a couple of Mysql tables (first field shown below),

This WILL work
Definition: Table 1
Database  courses  COLUMN_DEF   "code=char(3) NOT NULL PRIMARY KEY"
Database ...etc

This WON'T work
Definition: Table 2
Database  books  KEY          id
Database  books  COLUMN_DEF   "id=INT NOT NULL AUTO_INCREMENT PRIMARY KEY"
Database ...etc

The definition for table 1 works okay, however, the definition for table 2 
won't do the trick (won't update info while using the UI). It seems to me 
that the Interchange UI (direct table edit) doesn't handle an integer key 
properly. Is this indeed a bug or am I missing something here?

Kind regards,

Ton Verhagen

-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list