Re: KEY directive

[mike@minivend.com]

******    message to minivend-users from mike@minivend.com     ******

Quoting Derek Simkowiak (dereks@kd-dev.com):
> 
>     From the documentation:
> 
> ----------------------------------
> KEY 
>     You can change the keying default of "code" in the first column of the 
> database with the KEY directive.
>     
>     Don't use this unless you know exactly what you are doing and are
> prepared to alter all searches, imports, and exports accordingly. It is
> best to just accept the default and make the first column the key for any
> MiniVend database. 
> ----------------------------------
> 
> 	I'm going to use an MySQL table for the products listing.  Does
> the first field have to have the name 'code' (that is, 'c', 'o', 'd', 'e')
> or can it have a different name (such as "product_id") where the field
> field is simply the Primary Key of the database?
> 
> 	Does the first field need to literally be "code", or just the
> Primary Key?
> 

You can name it whatever you want, though there may be one or
two functions in 3.11 that will hiccup (perhaps form update of the
database). MiniVend does remember the value of the first column and use
that for the key in SELECT statements when accessing database entries.

-- 
Mike Heins                          http://www.minivend.com/  ___ 
                                    Internet Robotics        |_ _|____
Fast, reliable, cheap.              131 Willow Lane, Floor 2  | ||  _ \
Pick two and we'll talk.            Oxford, OH  45056         | || |_) |
 -- unknown                         <mikeh@minivend.com>     |___|  _ <
                                    513.523.7621 FAX 7501        |_| \_\
-
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