Index  Up  <<  >>  

I can't get SQL to work -- Undefined subroutine &Vend::Table::DBI::create ...

This probably means one of:

No SQL database
Minivend doesn't include a SQL database. You must select one and install it.

no DBI
You must install Perl's DBI module before using Minivend with SQL. You can see where to get it at http://www.cpan.org, or try: 

    perl -MCPAN -e 'install DBI'

no DBD
You must install the specific Perl DBD module for your database before using Minivend with SQL. You can see where to get it at http://www.cpan.org, or try: 

    perl -MCPAN -e 'install DBD::XXXXX'

where XXXX is the name of your module. Some of them are: 

    Adabas
    DB2
    Informix
    Ingres
    ODBC
    Oracle
    Pg
    Solid
    Sybase
    Unify
    XBase
    mSQL
    mysql

If you can't make this script run without error: 

    use DBI;
    use DBD::XXXXX;

then you don't have one of the above, and Minivend will never run a SQL type.

I don't like the column types that Minivend defines!
Then change them. See the simple/mysql directory for some examples under MySQL.

I change the ASCII file, but the table is not updated. Why?
Why do I even need an ASCII file?
Minivend wants some source for column names initially. If you don't want to have one, just create a TABLENAME.sql file in the products directory. For example, if you have this: 

    Database products products.txt dbi:mysql:test_minivend

then create a file products/products.sql. For 

    Database pricing pricing.txt dbi:mysql:test_minivend

create a file products/pricing.sql. Etc.

Minivend overwrites my predefined table!

Yes, it will if you don't create a file called TABLENAME.sql, where TABLENAME is the name of the Minivend table. If you want this to happen by default, then set NoImport TABLENAME.

Index  Up  <<  >>