Re: [mv] SQL Import from ASCII

["A. Veenstra" <artsenev@wxs.nl>]

Hi,

If I remember rightly you should insert a non-null-character (/N) in any
empty fields of an ascii database before importing it into for example
MySQL.
example:

code            image            name                    description
price
12-000-A    phone12.jpg  Sony S-Connect         /N           235,00

Hope this will help you.

Fred.
-----Oorspronkelijk bericht-----
Van: Markus Mueller <mueller@ass-software.de>
Aan: MiniVend <minivend-users@minivend.com>
Datum: maandag 11 oktober 1999 18:12
Onderwerp: [mv] SQL Import from ASCII


>******    message to minivend-users from "Markus Mueller"
<mueller@ass-software.de>     ******
>
>
>me again ;)
>
>
>-> table cats index failed: Column 'code' is used with UNIQUE or INDEX but
>is not defined as NOT NULL
>
>How can I tell Minivend to set code NOT NULL ??
>
>-
>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
>