Problem with v4 and TableAdapter

Zero-G. · Post by **Zero-G.** » Mon 21 May 2007 12:13

Hey

There is another problem too in the version 4 and Table Adapter

After creating a DataSet with the wizard(1 MasterTable & one ChildTable with a relation)the new DataSet in the DataSource looks like:

-{} Project Name
+ DataSet Name

After Drag/Drop a column out of the DataSet, I get 7 errors:

Error 1
Type 'mySQL_Testvb.mySQL_Testvb.DataSet2' is not defined.
Error 2 Type 'mySQL_Testvb.mySQL_Testvb.DataSet2TableAdapters.auftragbrilleTableAdapter' is not defined.
Error 3
Type 'mySQL_Testvb.mySQL_Testvb.DataSet2TableAdapters.aerzteTableAdapter' is not defined.
Error 4
Type 'mySQL_Testvb.mySQL_Testvb.DataSet3' is not defined.
Error 5
Type 'mySQL_Testvb.mySQL_Testvb.DataSet3TableAdapters.aerzteTableAdapter' is not defined.
Error 6
Type 'mySQL_Testvb.mySQL_Testvb.DataSet3' is not defined.
Error 7
Type 'mySQL_Testvb.mySQL_Testvb.DataSet3TableAdapters.aerzteTableAdapter' is not defined.

The problem is, that your product generates the 'mySQL_Textvb' twice. - When I delete the first, everything works fine. - But I don't think, that this is normal

Using VS2005 + Vista Business with the v4 of your product.

Alexey · Post by **Alexey** » Mon 21 May 2007 13:51

Please provide me with your database objects definitions to create appropriate dataset.

Zero-G. · Post by **Zero-G.** » Mon 21 May 2007 14:38

Hey

Here is the create Statement for the two tables:

Code: Select all

-- Table: aerzte

-- DROP TABLE `aerzte`;

CREATE TABLE `aerzte` (
  ID          bigint AUTO_INCREMENT NOT NULL,
  `VPNr`      int NOT NULL DEFAULT '0',
  `akadGrad`  varchar(15) NOT NULL,
  `NName`     varchar(50) NOT NULL,
  `VName`     varchar(50) NOT NULL,
  `Strasse`   varchar(30) NOT NULL,
  PLZ         int NOT NULL DEFAULT '0',
  `Ort`       varchar(20) NOT NULL,
  /* Keys */
  PRIMARY KEY (ID)
) ENGINE = MyISAM;

CREATE INDEX `SuchKey`
  ON `aerzte`
  (`NName`, `VPNr`);

-- Table: auftragbrille

-- DROP TABLE `auftragbrille`;

CREATE TABLE `auftragbrille` (
  `AuftragBrilleID`  bigint AUTO_INCREMENT NOT NULL,
  `KundenID`         bigint NOT NULL DEFAULT '0',
  `Bewegung`         int(1) NOT NULL DEFAULT '0',
  `BrillenArt`       varchar(20) NOT NULL,
  `sph_re`           varchar(6) NOT NULL,
  `cyl_re`           varchar(5) NOT NULL DEFAULT '0',
  `achse_re`         char(3) NOT NULL DEFAULT '0',
  `pd_re`            char(2) NOT NULL DEFAULT '0',
  `nth_re`           char(2) NOT NULL DEFAULT '0',
  `add_re`           varchar(4) NOT NULL DEFAULT '0',
  `prisma_re`        varchar(9) NOT NULL,
  `Visus_re`         varchar(4) NOT NULL,
  `sph_li`           varchar(6) NOT NULL DEFAULT '0',
  `cyl_li`           varchar(5) NOT NULL DEFAULT '0',
  `achse_li`         char(3) NOT NULL DEFAULT '0',
  `pd_li`            char(2) NOT NULL DEFAULT '0',
  `nth_li`           char(2) NOT NULL DEFAULT '0',
  `add_li`           varchar(4) NOT NULL DEFAULT '0',
  `prisma_li`        varchar(9) NOT NULL,
  `Visus_li`         varchar(4) NOT NULL,
  `ArtikelID_re`     double(11,0) NOT NULL DEFAULT '0',
  `invnr_re`         char(2) NOT NULL,
  `lieferant_re`     char(2) NOT NULL,
  `artnr_re`         varchar(6) NOT NULL,
  `groesse_re`       varchar(4) NOT NULL,
  `farbe_re`         varchar(5) NOT NULL,
  `artbez_re`        varchar(30) NOT NULL,
  `preis_re`         double(10,2) NOT NULL DEFAULT '0',
  `ArtikelID_li`     varchar(100) NOT NULL,
  `invnr_li`         char(2) NOT NULL,
  `lieferant_li`     char(2) NOT NULL,
  `artnr_li`         varchar(6) NOT NULL,
  `groesse_li`       varchar(4) NOT NULL,
  `farbe_li`         varchar(5) NOT NULL,
  `artbez_li`        varchar(30) NOT NULL,
  `preis_li`         double(10,2) NOT NULL DEFAULT '0',
  `ArtikelID_fas`    double(10,2) NOT NULL DEFAULT '0',
  `ICode_fas`        double(10,2) NOT NULL DEFAULT '0',
  `invnr_fas`        char(2) NOT NULL,
  `lieferant_fas`    char(2) NOT NULL,
  `artnr_fas`        varchar(6) NOT NULL,
  `groesse_fas`      varchar(4) NOT NULL,
  `farbe_fas`        varchar(5) NOT NULL,
  `artbez_fas`       varchar(30) NOT NULL,
  `preis_fas`        double(10,2) NOT NULL DEFAULT '0',
  VK                 char(2) NOT NULL,
  `Werkstatt`        char(2) NOT NULL,
  `AerzteKurz`       char(2) NOT NULL,
  `AerzteID`         bigint NOT NULL DEFAULT '0',
  `Refraktionist`    char(2) NOT NULL,
  `KrankenKassa`     char(3) NOT NULL DEFAULT '0',
  `Pos1`             char(2) NOT NULL DEFAULT '0',
  `Pos2`             char(3) NOT NULL DEFAULT '0',
  `Pos3`             char(3) NOT NULL DEFAULT '0',
  `Pos4`             char(3) NOT NULL DEFAULT '0',
  `Pos5`             char(3) NOT NULL DEFAULT '0',
  KV                 double(10,2) NOT NULL DEFAULT '0',
  `preis_KK`         double(10,2) NOT NULL DEFAULT '0',
  `preis_SB`         double(10,2) NOT NULL DEFAULT '0',
  `Info`             varchar(250) NOT NULL,
  `AufDat`           date NOT NULL DEFAULT '0000-00-00',
  `BezDat`           date,
  `BezBetrag`        double(10,2) NOT NULL DEFAULT '0',
  `BezArt`           char NOT NULL,
  `Glasliste`        int NOT NULL DEFAULT '0',
  `ReNummer`         int NOT NULL DEFAULT '0',
  /* Keys */
  PRIMARY KEY (`AuftragBrilleID`)
) ENGINE = MyISAM;

CREATE INDEX `SuchID`
  ON `auftragbrille`
  (`KundenID`);

THX

Alexey · Post by **Alexey** » Mon 21 May 2007 15:45

Do you create the relation using our Dataset Wizard? What are the child and parent columns? Are you dragging a column from our dataset manager?

Zero-G. · Post by **Zero-G.** » Mon 21 May 2007 15:52

Hey

Yes, I create the relation through the wizard. - It is called Relation1
The Master is auftragbrille.AerzteID-> The Child aerzte.ID
Yes, I drag/drop the column through your DataSet Manager

Yours faithfully

Alexey · Post by **Alexey** » Mon 21 May 2007 16:51

I've also encountered some problems with our dataset generator. Seemingly our problems are related. We will investigate them detailed. Look forward to hearing from me again.

Zero-G. · Post by **Zero-G.** » Tue 22 May 2007 07:20

Hey

Thank you - I hope you will find and fix the problems fast, because my project stands still without your product.

Thank you & I am waiting for an answer

Alexey · Post by **Alexey** » Fri 01 Jun 2007 12:00

Please try new build of MySQLDirect .NET which is available for download now.

Zero-G. · Post by **Zero-G.** » Sat 02 Jun 2007 08:56

Hey Alexey

I do use Windows Vista Business.
While I try to install the latest building of your product, I get an error from the Installer:

Internal Error 2738

Can you please check this out?

THX

Alexey · Post by **Alexey** » Mon 04 Jun 2007 07:14

Run the following command from the command line:
'regsvr32 vbscript.dll'
Then try to install MySQLDirect .NET as administrator.

Devart Forums

Problem with v4 and TableAdapter

Problem with v4 and TableAdapter

Problem with installation