PC SOFT

FORUMS PROFESSIONNELS
WINDEV, WEBDEV et WINDEV Mobile

Accueil  |  Messages récents  | Connexion  |   | Français  FR
Accueil → WINDEV 2024 → HyperFile equalent to MySQL ENUM or SET datatypes?
HyperFile equalent to MySQL ENUM or SET datatypes?
Débuté par Dalen, 21 fév. 2008 16:42 - Aucune réponse
#1
Posté le 21 février 2008 - 16:42
Hi,

I just started using WinDev and wonder about ...<please look at the subject>.

For those who don't know/not sure what ENUM and SET datatypes are:
From the MySQL help: "An ENUM is a string object with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at table creation time."

A SET is like ENUM except that it accepts more than one value.

F.ex. like this SQL statement:

CREATE TABLE Customer (
Id bigint(20),
Allowed_level enum('Level 1','Level 2','Level 3'),
Allowed_numbers set('One','Two','Three','Four','Five')
)

Allowed_level only accepts one of the given values, Allowed_numbers accepts any of the given values. If any value is not in the given list, an error occour.

Thanks for any reply.

Dalen
→ Revenir à WINDEV 2024