Hi Jiri and Company, Is there anything else I need to do to document this issue? Any hints on a workaround or a possible fix?
Thanks, -Luis On Tue, Aug 3, 2010 at 7:45 AM, Luis Rizo <lriz...@gmail.com> wrote: > I have pin pointed the issue. After I sent out the e-mail, I dropped the > OPENING table in my test database, I then tweaked to the create script for > the OPENING Table by removing the following line: > > ALTER TABLE OPENING ADD CONSTRAINT FK_OPENING FOREIGN KEY (PROJECT_ID) > REFERENCES PROJECT(PROJECT_ID) ON DELETE CASCADE ON UPDATE CASCADE; > > I re-executed the script (without the above FK definition) and then > reattempted to add the tables to my DataSet and had no problems, everything > worked fine. It definitely seems like the DDEX has trouble handling with > this Foreign Key. > > I hope this helps in fixing this issue or finding a workaround for the time > being. > > Thanks again! > > -Luis > > > On Tue, Aug 3, 2010 at 7:41 AM, Luis Rizo <lriz...@gmail.com> wrote: > >> I've set one up by creating an empty database with two of the tables the >> give me issues. >> >> My feeling is that it has something to do with the Foreign Key that one >> table has to the other. >> >> The following assumes that DDEX has been configured and setup with Visual >> Studio 2010: >> >> Attached are 3 scripts: >> 1. A Domain Create script >> 2. A PROJECT Table Create Script >> 3. An OPENING Table Create Script >> >> Steps are as follows: >> 1. Create empty database with following parameters: >> -Path: C:\Temp\TestDB.FDB >> -UserName: SYSDBA // Password: masterkey >> -Page Size: 8192 >> -CharSet: ASCII >> -SQL Dialect: 3 >> -Single File Database >> >> 2. Run the DOMAIN create script, followed by the PROJECT create script, >> followed by the OPENING create Script >> >> 3. Add the Database to Visual Studio's (2010) Server Explorer using the >> DDEX .NET Provider >> >> 4. Add a DataSet to a project >> >> 5. Add PROJECT table to the DataSet (drag and drop). -- This will work >> fine >> >> 6. Add OPENING table to the DataSet (drag and drop). -- This will throw >> the error: "Failed to merge object(s). Object reference not set to an >> instance of an object." >> >> Note that the order in which you add the tables does not matter, it throws >> the error either way. >> >> Let me know if you need anything else. >> >> Thanks for your help, >> -Luis >> >> >> On Tue, Aug 3, 2010 at 6:55 AM, Jiri Cincura <disk...@cincura.net> wrote: >> >>> On Mon, Aug 2, 2010 at 20:44, Luis Rizo <lriz...@gmail.com> wrote: >>> > Anyone have any input or feedback on this issue I'm having? >>> >>> Do you have any reproducible testcase? >>> >>> -- >>> Jiri {x2} Cincura (x2develop.com founder) >>> http://blog.cincura.net/ | http://www.ID3renamer.com >>> >>> >>> ------------------------------------------------------------------------------ >>> The Palm PDK Hot Apps Program offers developers who use the >>> Plug-In Development Kit to bring their C/C++ apps to Palm for a share >>> of $1 Million in cash or HP Products. Visit us here for more details: >>> http://p.sf.net/sfu/dev2dev-palm >>> _______________________________________________ >>> Firebird-net-provider mailing list >>> Firebird-net-provider@lists.sourceforge.net >>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider >>> >> >> >
------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider