[Gambas-user] Problem with datacombo
Fabien Bodard
gambas.fr at ...626...
Fri Oct 26 16:01:38 CEST 2007
Le Friday 26 October 2007 13:33:11 Benoit Minisini, vous avez écrit :
> On vendredi 26 octobre 2007, Fabien Bodard wrote:
> > in a database i have :
> > Table Produce
> > idProd
> > Prodname
> > idFamilly
> > idCategory
> > idType
> >
> > Table Familly:
> > idFamilly
> > Name
> >
> > TableCategory
> >
> > idCategory
> > Name
> > idFamilly
> >
> > Table Type:
> > idType
> > Name
> > idFamilly
> > idCategory
> >
> >
> >
> > in a form
> > i add a datasource linked to Produce table
> > on it i add a data broswer
> >
> > with Table idprod, prodname
> >
> > then i add a panel with contain these datacontrol
> >
> > prodName
> > and
> > datacombo
> > on Familly
> > on Category
> > on Type
> >
> > But i've a stack overflow :(
> >
> >
> > Help !
> >
> > Fabien
>
> Please send the project, and a SQL dump of your database (with the
> metadata).
>
> Regards,
This is the project and the db dump...
Another thing i've seen in the datacombo src, The datacombo can't use string
reference to communicate with a table...
product.familly = "alcool" i prefer use string index as integer one as it
allow to securize the database... (one entry lost... the database can be read
by eyes and corrected more quikly)
Fabien
-------------- next part --------------
-- MySQL dump 10.11
--
-- Host: localhost Database: Stock
-- ------------------------------------------------------
-- Server version 5.0.45-Debian_1ubuntu3-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `Inventaire`
--
DROP TABLE IF EXISTS `Inventaire`;
CREATE TABLE `Inventaire` (
`id` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `Inventaire`
--
LOCK TABLES `Inventaire` WRITE;
/*!40000 ALTER TABLE `Inventaire` DISABLE KEYS */;
/*!40000 ALTER TABLE `Inventaire` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `categorie`
--
DROP TABLE IF EXISTS `categorie`;
CREATE TABLE `categorie` (
`idcategorie` bigint(20) unsigned NOT NULL auto_increment,
`famille` varchar(10) default NULL,
`categorie` varchar(10) default NULL,
`note` text,
PRIMARY KEY (`idcategorie`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `categorie`
--
LOCK TABLES `categorie` WRITE;
/*!40000 ALTER TABLE `categorie` DISABLE KEYS */;
INSERT INTO `categorie` VALUES (1,'Alcool','Pineau',NULL);
/*!40000 ALTER TABLE `categorie` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `famille`
--
DROP TABLE IF EXISTS `famille`;
CREATE TABLE `famille` (
`idfamille` bigint(20) unsigned NOT NULL auto_increment,
`famille` varchar(10) default NULL,
`note` text,
PRIMARY KEY (`idfamille`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `famille`
--
LOCK TABLES `famille` WRITE;
/*!40000 ALTER TABLE `famille` DISABLE KEYS */;
INSERT INTO `famille` VALUES (1,'alcool','Produits contenants de l\'alcool');
/*!40000 ALTER TABLE `famille` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `produit`
--
DROP TABLE IF EXISTS `produit`;
CREATE TABLE `produit` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`reference` varchar(10) default NULL,
`nom` varchar(32) default NULL,
`capacite` double default NULL,
`idunite` int(11) default NULL,
`idcategorie` varchar(10) default NULL,
`idfamille` int(11) default NULL,
`idtype` int(11) default NULL,
`pub` int(11) default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=302 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `produit`
--
LOCK TABLES `produit` WRITE;
/*!40000 ALTER TABLE `produit` DISABLE KEYS */;
INSERT INTO `produit` VALUES (1,'MIGN','Mignonnette PR',20,NULL,NULL,NULL,NULL,-1),(2,NULL,NULL,NULL,1,'1',1,1,NULL),(3,NULL,NULL,NULL,1,'1',1,1,NULL),(4,NULL,NULL,NULL,1,'1',1,1,NULL),(5,NULL,NULL,NULL,1,'1',1,1,NULL),(6,NULL,NULL,NULL,1,'1',1,1,NULL),(7,NULL,NULL,NULL,1,'1',1,1,NULL),(8,NULL,NULL,NULL,1,'1',1,1,NULL),(9,NULL,NULL,NULL,1,'1',1,1,NULL),(10,NULL,NULL,NULL,1,'1',1,1,NULL),(11,NULL,NULL,NULL,1,'1',1,1,NULL),(12,NULL,NULL,NULL,1,'1',1,1,NULL),(13,NULL,NULL,NULL,1,'1',1,1,NULL),(14,NULL,NULL,NULL,1,'1',1,1,NULL),(15,NULL,NULL,NULL,1,'1',1,1,NULL),(16,NULL,NULL,NULL,1,'1',1,1,NULL),(17,NULL,NULL,NULL,1,'1',1,1,NULL),(18,NULL,NULL,NULL,1,'1',1,1,NULL),(19,NULL,NULL,NULL,1,'1',1,1,NULL),(20,NULL,NULL,NULL,1,'1',1,1,NULL),(21,NULL,NULL,NULL,1,'1',1,1,NULL),(22,NULL,NULL,NULL,1,'1',1,1,NULL),(23,NULL,NULL,NULL,1,'1',1,1,NULL),(24,NULL,NULL,NULL,1,'1',1,1,NULL),(25,NULL,NULL,NULL,1,'1',1,1,NULL),(26,NULL,NULL,NULL,1,'1',1,1,NULL),(27,NULL,NULL,NULL,1,'1',1,1,NULL),(28,NULL,NULL,NULL,1,'1',1,1,NULL),(29,NULL,NULL,NULL,1,'1',1,1,NULL),(30,NULL,NULL,NULL,1,'1',1,1,NULL),(31,NULL,NULL,NULL,1,'1',1,1,NULL),(32,NULL,NULL,NULL,1,'1',1,1,NULL),(33,NULL,NULL,NULL,1,'1',1,1,NULL),(34,NULL,NULL,NULL,1,'1',1,1,NULL),(35,NULL,NULL,NULL,1,'1',1,1,NULL),(36,NULL,NULL,NULL,1,'1',1,1,NULL),(37,NULL,NULL,NULL,1,'1',1,1,NULL),(38,NULL,NULL,NULL,1,'1',1,1,NULL),(39,NULL,NULL,NULL,1,'1',1,1,NULL),(40,NULL,NULL,NULL,1,'1',1,1,NULL),(41,NULL,NULL,NULL,1,'1',1,1,NULL),(42,NULL,NULL,NULL,1,'1',1,1,NULL),(43,NULL,NULL,NULL,1,'1',1,1,NULL),(44,NULL,NULL,NULL,1,'1',1,1,NULL),(45,NULL,NULL,NULL,1,'1',1,1,NULL),(46,NULL,NULL,NULL,1,'1',1,1,NULL),(47,NULL,NULL,NULL,1,'1',1,1,NULL),(48,NULL,NULL,NULL,1,'1',1,1,NULL),(49,NULL,NULL,NULL,1,'1',1,1,NULL),(50,NULL,NULL,NULL,1,'1',1,1,NULL),(51,NULL,NULL,NULL,1,'1',1,1,NULL),(52,NULL,NULL,NULL,1,'1',1,1,NULL),(53,NULL,NULL,NULL,1,'1',1,1,NULL),(54,NULL,NULL,NULL,1,'1',1,1,NULL),(55,NULL,NULL,NULL,1,'1',1,1,NULL),(56,NULL,NULL,NULL,1,'1',1,1,NULL),(57,NULL,NULL,NULL,1,'1',1,1,NULL),(58,NULL,NULL,NULL,1,'1',1,1,NULL),(59,NULL,NULL,NULL,1,'1',1,1,NULL),(60,NULL,NULL,NULL,1,'1',1,1,NULL),(61,NULL,NULL,NULL,1,'1',1,1,NULL),(62,NULL,NULL,NULL,1,'1',1,1,NULL),(63,NULL,NULL,NULL,1,'1',1,1,NULL),(64,NULL,NULL,NULL,1,'1',1,1,NULL),(65,NULL,NULL,NULL,1,'1',1,1,NULL),(66,NULL,NULL,NULL,1,'1',1,1,NULL),(67,NULL,NULL,NULL,1,'1',1,1,NULL),(68,NULL,NULL,NULL,1,'1',1,1,NULL),(69,NULL,NULL,NULL,1,'1',1,1,NULL),(70,NULL,NULL,NULL,1,'1',1,1,NULL),(71,NULL,NULL,NULL,1,'1',1,1,NULL),(72,NULL,NULL,NULL,1,'1',1,1,NULL),(73,NULL,NULL,NULL,1,'1',1,1,NULL),(74,NULL,NULL,NULL,1,'1',1,1,NULL),(75,NULL,NULL,NULL,1,'1',1,1,NULL),(76,NULL,NULL,NULL,1,'1',1,1,NULL),(77,NULL,NULL,NULL,1,'1',1,1,NULL),(78,NULL,NULL,NULL,1,'1',1,1,NULL),(79,NULL,NULL,NULL,1,'1',1,1,NULL),(80,NULL,NULL,NULL,1,'1',1,1,NULL),(81,NULL,NULL,NULL,1,'1',1,1,NULL),(82,NULL,NULL,NULL,1,'1',1,1,NULL),(83,NULL,NULL,NULL,1,'1',1,1,NULL),(84,NULL,NULL,NULL,1,'1',1,1,NULL),(85,NULL,NULL,NULL,1,'1',1,1,NULL),(86,NULL,NULL,NULL,1,'1',1,1,NULL),(87,NULL,NULL,NULL,1,'1',1,1,NULL),(88,NULL,NULL,NULL,1,'1',1,1,NULL),(89,NULL,NULL,NULL,1,'1',1,1,NULL),(90,NULL,NULL,NULL,1,'1',1,1,NULL),(91,NULL,NULL,NULL,1,'1',1,1,NULL),(92,NULL,NULL,NULL,1,'1',1,1,NULL),(93,NULL,NULL,NULL,1,'1',1,1,NULL),(94,NULL,NULL,NULL,1,'1',1,1,NULL),(95,NULL,NULL,NULL,1,'1',1,1,NULL),(96,NULL,NULL,NULL,1,'1',1,1,NULL),(97,NULL,NULL,NULL,1,'1',1,1,NULL),(98,NULL,NULL,NULL,1,'1',1,1,NULL),(99,NULL,NULL,NULL,1,'1',1,1,NULL),(100,NULL,NULL,NULL,1,'1',1,1,NULL),(101,NULL,NULL,NULL,1,'1',1,1,NULL),(102,NULL,NULL,NULL,1,'1',1,1,NULL),(103,NULL,NULL,NULL,1,'1',1,1,NULL),(104,NULL,NULL,NULL,1,'1',1,1,NULL),(105,NULL,NULL,NULL,1,'1',1,1,NULL),(106,NULL,NULL,NULL,1,'1',1,1,NULL),(107,NULL,NULL,NULL,1,'1',1,1,NULL),(108,NULL,NULL,NULL,1,'1',1,1,NULL),(109,NULL,NULL,NULL,1,'1',1,1,NULL),(110,NULL,NULL,NULL,1,'1',1,1,NULL),(111,NULL,NULL,NULL,1,'1',1,1,NULL),(112,NULL,NULL,NULL,1,'1',1,1,NULL),(113,NULL,NULL,NULL,1,'1',1,1,NULL),(114,NULL,NULL,NULL,1,'1',1,1,NULL),(115,NULL,NULL,NULL,1,'1',1,1,NULL),(116,NULL,NULL,NULL,1,'1',1,1,NULL),(117,NULL,NULL,NULL,1,'1',1,1,NULL),(118,NULL,NULL,NULL,1,'1',1,1,NULL),(119,NULL,NULL,NULL,1,'1',1,1,NULL),(120,NULL,NULL,NULL,1,'1',1,1,NULL),(121,NULL,NULL,NULL,1,'1',1,1,NULL),(122,NULL,NULL,NULL,1,'1',1,1,NULL),(123,NULL,NULL,NULL,1,'1',1,1,NULL),(124,NULL,NULL,NULL,1,'1',1,1,NULL),(125,NULL,NULL,NULL,1,'1',1,1,NULL),(126,NULL,NULL,NULL,1,'1',1,1,NULL),(127,NULL,NULL,NULL,1,'1',1,1,NULL),(128,NULL,NULL,NULL,1,'1',1,1,NULL),(129,NULL,NULL,NULL,1,'1',1,1,NULL),(130,NULL,NULL,NULL,1,'1',1,1,NULL),(131,NULL,NULL,NULL,1,'1',1,1,NULL),(132,NULL,NULL,NULL,1,'1',1,1,NULL),(133,NULL,NULL,NULL,1,'1',1,1,NULL),(134,NULL,NULL,NULL,1,'1',1,1,NULL),(135,NULL,NULL,NULL,1,'1',1,1,NULL),(136,NULL,NULL,NULL,1,'1',1,1,NULL),(137,NULL,NULL,NULL,1,'1',1,1,NULL),(138,NULL,NULL,NULL,1,'1',1,1,NULL),(139,NULL,NULL,NULL,1,'1',1,1,NULL),(140,NULL,NULL,NULL,1,'1',1,1,NULL),(141,NULL,NULL,NULL,1,'1',1,1,NULL),(142,NULL,NULL,NULL,1,'1',1,1,NULL),(143,NULL,NULL,NULL,1,'1',1,1,NULL),(144,NULL,NULL,NULL,1,'1',1,1,NULL),(145,NULL,NULL,NULL,1,'1',1,1,NULL),(146,NULL,NULL,NULL,1,'1',1,1,NULL),(147,NULL,NULL,NULL,1,'1',1,1,NULL),(148,NULL,NULL,NULL,1,'1',1,1,NULL),(149,NULL,NULL,NULL,1,'1',1,1,NULL),(150,NULL,NULL,NULL,1,'1',1,1,NULL),(151,NULL,NULL,NULL,1,'1',1,1,NULL),(152,NULL,NULL,NULL,1,'1',1,1,NULL),(153,NULL,NULL,NULL,1,'1',1,1,NULL),(154,NULL,NULL,NULL,1,'1',1,1,NULL),(155,NULL,NULL,NULL,1,'1',1,1,NULL),(156,NULL,NULL,NULL,1,'1',1,1,NULL),(157,NULL,NULL,NULL,1,'1',1,1,NULL),(158,NULL,NULL,NULL,1,'1',1,1,NULL),(159,NULL,NULL,NULL,1,'1',1,1,NULL),(160,NULL,NULL,NULL,1,'1',1,1,NULL),(161,NULL,NULL,NULL,1,'1',1,1,NULL),(162,NULL,NULL,NULL,1,'1',1,1,NULL),(163,NULL,NULL,NULL,1,'1',1,1,NULL),(164,NULL,NULL,NULL,1,'1',1,1,NULL),(165,NULL,NULL,NULL,1,'1',1,1,NULL),(166,NULL,NULL,NULL,1,'1',1,1,NULL),(167,NULL,NULL,NULL,1,'1',1,1,NULL),(168,NULL,NULL,NULL,1,'1',1,1,NULL),(169,NULL,NULL,NULL,1,'1',1,1,NULL),(170,NULL,NULL,NULL,1,'1',1,1,NULL),(171,NULL,NULL,NULL,1,'1',1,1,NULL),(172,NULL,NULL,NULL,1,'1',1,1,NULL),(173,NULL,NULL,NULL,1,'1',1,1,NULL),(174,NULL,NULL,NULL,1,'1',1,1,NULL),(175,NULL,NULL,NULL,1,'1',1,1,NULL),(176,NULL,NULL,NULL,1,'1',1,1,NULL),(177,NULL,NULL,NULL,1,'1',1,1,NULL),(178,NULL,NULL,NULL,1,'1',1,1,NULL),(179,NULL,NULL,NULL,1,'1',1,1,NULL),(180,NULL,NULL,NULL,1,'1',1,1,NULL),(181,NULL,NULL,NULL,1,'1',1,1,NULL),(182,NULL,NULL,NULL,1,'1',1,1,NULL),(183,NULL,NULL,NULL,1,'1',1,1,NULL),(184,NULL,NULL,NULL,1,'1',1,1,NULL),(185,NULL,NULL,NULL,1,'1',1,1,NULL),(186,NULL,NULL,NULL,1,'1',1,1,NULL),(187,NULL,NULL,NULL,1,'1',1,1,NULL),(188,NULL,NULL,NULL,1,'1',1,1,NULL),(189,NULL,NULL,NULL,1,'1',1,1,NULL),(190,NULL,NULL,NULL,1,'1',1,1,NULL),(191,NULL,NULL,NULL,1,'1',1,1,NULL),(192,NULL,NULL,NULL,1,'1',1,1,NULL),(193,NULL,NULL,NULL,1,'1',1,1,NULL),(194,NULL,NULL,NULL,1,'1',1,1,NULL),(195,NULL,NULL,NULL,1,'1',1,1,NULL),(196,NULL,NULL,NULL,1,'1',1,1,NULL),(197,NULL,NULL,NULL,1,'1',1,1,NULL),(198,NULL,NULL,NULL,1,'1',1,1,NULL),(199,NULL,NULL,NULL,1,'1',1,1,NULL),(200,NULL,NULL,NULL,1,'1',1,1,NULL),(201,NULL,NULL,NULL,1,'1',1,1,NULL),(202,NULL,NULL,NULL,1,'1',1,1,NULL),(203,NULL,NULL,NULL,1,'1',1,1,NULL),(204,NULL,NULL,NULL,1,'1',1,1,NULL),(205,NULL,NULL,NULL,1,'1',1,1,NULL),(206,NULL,NULL,NULL,1,'1',1,1,NULL),(207,NULL,NULL,NULL,1,'1',1,1,NULL),(208,NULL,NULL,NULL,1,'1',1,1,NULL),(209,NULL,NULL,NULL,1,'1',1,1,NULL),(210,NULL,NULL,NULL,1,'1',1,1,NULL),(211,NULL,NULL,NULL,1,'1',1,1,NULL),(212,NULL,NULL,NULL,1,'1',1,1,NULL),(213,NULL,NULL,NULL,1,'1',1,1,NULL),(214,NULL,NULL,NULL,1,'1',1,1,NULL),(215,NULL,NULL,NULL,1,'1',1,1,NULL),(216,NULL,NULL,NULL,1,'1',1,1,NULL),(217,NULL,NULL,NULL,1,'1',1,1,NULL),(218,NULL,NULL,NULL,1,'1',1,1,NULL),(219,NULL,NULL,NULL,1,'1',1,1,NULL),(220,NULL,NULL,NULL,1,'1',1,1,NULL),(221,NULL,NULL,NULL,1,'1',1,1,NULL),(222,NULL,NULL,NULL,1,'1',1,1,NULL),(223,NULL,NULL,NULL,1,'1',1,1,NULL),(224,NULL,NULL,NULL,1,'1',1,1,NULL),(225,NULL,NULL,NULL,1,'1',1,1,NULL),(226,NULL,NULL,NULL,1,'1',1,1,NULL),(227,NULL,NULL,NULL,1,'1',1,1,NULL),(228,NULL,NULL,NULL,1,'1',1,1,NULL),(229,NULL,NULL,NULL,1,'1',1,1,NULL),(230,NULL,NULL,NULL,1,'1',1,1,NULL),(231,NULL,NULL,NULL,1,'1',1,1,NULL),(232,NULL,NULL,NULL,1,'1',1,1,NULL),(233,NULL,NULL,NULL,1,'1',1,1,NULL),(234,NULL,NULL,NULL,1,'1',1,1,NULL),(235,NULL,NULL,NULL,1,'1',1,1,NULL),(236,NULL,NULL,NULL,1,'1',1,1,NULL),(237,NULL,NULL,NULL,1,'1',1,1,NULL),(238,NULL,NULL,NULL,1,'1',1,1,NULL),(239,NULL,NULL,NULL,1,'1',1,1,NULL),(240,NULL,NULL,NULL,1,'1',1,1,NULL),(241,NULL,NULL,NULL,1,'1',1,1,NULL),(242,NULL,NULL,NULL,1,'1',1,1,NULL),(243,NULL,NULL,NULL,1,'1',1,1,NULL),(244,NULL,NULL,NULL,1,'1',1,1,NULL),(245,NULL,NULL,NULL,1,'1',1,1,NULL),(246,NULL,NULL,NULL,1,'1',1,1,NULL),(247,NULL,NULL,NULL,1,'1',1,1,NULL),(248,NULL,NULL,NULL,1,'1',1,1,NULL),(249,NULL,NULL,NULL,1,'1',1,1,NULL),(250,NULL,NULL,NULL,1,'1',1,1,NULL),(251,NULL,NULL,NULL,1,'1',1,1,NULL),(252,NULL,NULL,NULL,1,'1',1,1,NULL),(253,NULL,NULL,NULL,1,'1',1,1,NULL),(254,NULL,NULL,NULL,1,'1',1,1,NULL),(255,NULL,NULL,NULL,1,'1',1,1,NULL),(256,NULL,NULL,NULL,1,'1',1,1,NULL),(257,NULL,NULL,NULL,1,'1',1,1,NULL),(258,NULL,NULL,NULL,1,'1',1,1,NULL),(259,NULL,NULL,NULL,1,'1',1,1,NULL),(260,NULL,NULL,NULL,1,'1',1,1,NULL),(261,NULL,NULL,NULL,1,'1',1,1,NULL),(262,NULL,NULL,NULL,1,'1',1,1,NULL),(263,NULL,NULL,NULL,1,'1',1,1,NULL),(264,NULL,NULL,NULL,1,'1',1,1,NULL),(265,NULL,NULL,NULL,1,'1',1,1,NULL),(266,NULL,NULL,NULL,1,'1',1,1,NULL),(267,NULL,NULL,NULL,1,'1',1,1,NULL),(268,NULL,NULL,NULL,1,'1',1,1,NULL),(269,NULL,NULL,NULL,1,'1',1,1,NULL),(270,NULL,NULL,NULL,1,'1',1,1,NULL),(271,NULL,NULL,NULL,1,'1',1,1,NULL),(272,'','',NULL,1,'1',1,1,NULL),(273,'','',NULL,1,'1',1,1,NULL),(274,'','',NULL,1,'1',1,1,NULL),(275,'','',NULL,1,'1',1,1,NULL),(276,'','',NULL,1,'1',1,1,NULL),(277,'','',NULL,1,'1',1,1,NULL),(278,'','',NULL,1,'1',1,1,NULL),(279,'','',NULL,1,'1',1,1,NULL),(280,'','',NULL,1,'1',1,1,NULL),(281,'','',NULL,1,'1',1,1,NULL),(282,'','',NULL,1,'1',1,1,NULL),(283,'','',NULL,1,'1',1,1,NULL),(284,'','',NULL,1,'1',1,1,NULL),(285,'','',NULL,1,'1',1,1,NULL),(286,'','',NULL,1,'1',1,1,NULL),(287,'','',NULL,1,'1',1,1,NULL),(288,'','',NULL,1,'1',1,1,NULL),(289,'','',NULL,1,'1',1,1,NULL),(290,'','',NULL,1,'1',1,1,NULL),(291,'','',NULL,1,'1',1,1,NULL),(292,'','',NULL,1,'1',1,1,NULL),(293,'','',NULL,1,'1',1,1,NULL),(294,'','',NULL,1,'1',1,1,NULL),(295,'','',NULL,1,'1',1,1,NULL),(296,'','',NULL,1,'1',1,1,NULL),(297,'','',NULL,1,'1',1,1,NULL),(298,'','',NULL,1,'1',1,1,NULL),(299,'','',NULL,1,'1',1,1,NULL),(300,'','',NULL,1,'1',1,1,NULL),(301,'','',NULL,1,'1',1,1,NULL);
/*!40000 ALTER TABLE `produit` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `type`
--
DROP TABLE IF EXISTS `type`;
CREATE TABLE `type` (
`idtype` bigint(20) unsigned NOT NULL auto_increment,
`type` varchar(10) default NULL,
`famille` varchar(10) default NULL,
`categorie` varchar(10) default NULL,
`note` text,
PRIMARY KEY (`idtype`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `type`
--
LOCK TABLES `type` WRITE;
/*!40000 ALTER TABLE `type` DISABLE KEYS */;
INSERT INTO `type` VALUES (1,'PR','Alcool','Pineau',NULL);
/*!40000 ALTER TABLE `type` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `unite`
--
DROP TABLE IF EXISTS `unite`;
CREATE TABLE `unite` (
`idunite` bigint(20) unsigned NOT NULL auto_increment,
`unite` varchar(3) default NULL,
`label` varchar(12) default NULL,
`coef` double default NULL,
`pub` tinyint(1) default NULL,
PRIMARY KEY (`idunite`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
--
-- Dumping data for table `unite`
--
LOCK TABLES `unite` WRITE;
/*!40000 ALTER TABLE `unite` DISABLE KEYS */;
INSERT INTO `unite` VALUES (1,'ml','Millilitre',0.001,1),(2,'cl','Centilitre',0.01,1),(3,'dl','décilitre',0.1,0),(4,'l','Litre',1,1),(5,'dal','Décalitre',10,0),(6,'hl','Hectolitre',100,1),(7,'mg','Milligramme',0.001,0),(8,'cg','centigramme',0.01,0),(9,'dg','Décigramme',0.1,0),(10,'g','Gramme',1,1),(11,'q','Quintal',100,0),(12,'t','Tonne',1000,0);
/*!40000 ALTER TABLE `unite` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
-- Dump completed on 2007-10-26 13:56:58
-------------- next part --------------
A non-text attachment was scrubbed...
Name: Stock-0.0.1.tar.gz
Type: application/x-tgz
Size: 5381 bytes
Desc: not available
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20071026/6ca54f5d/attachment.bin>
More information about the User
mailing list