[mv] Q: UserDB table functionality doesn't work properly

[Eugene Apanasenko <janzen@iol.cz>]

Hi All!

I use MiniVend V3.14-4 and have decided to store users information in SQL-table. I add the following
lines in my
catalog.cfg:
#Database            userdb       userdb.asc        TAB
Database            userdb       userdb.asc        dbi:Oracle:ORCL
Database            userdb ChopBlanks   1
Database            userdb UPPERCASE    1
Database            userdb USER   evlap
Database            userdb PASS   mypwd
NoImport  userdb

I created a table Userdb with the structure of Userdb.asc, erased userdb.db file and cleaned
userdb.asc out. Now when I create a new user, a new record seems to be added to the table. But when
I enter an extra info (such as Name, Address etc) in ord/checkout.html page (I use this one from
simple demo) and press "Update info, don't place order" button, Minivend updates the table with
__empty__ values, though I have theese fields not blanked (series of queries like this one are
produced:
 update userdb SET ADDRESS = '' where CODE = 'testuser').
I haven't got a clue why values from the form are ommited.

Thanks in advance, Eugene