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

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