Problem with v4 and TableAdapter
Problem with v4 and TableAdapter
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.
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.
Hey
Here is the create Statement for the two tables:
THX
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`);
Problem with installation
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
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