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
>>
>
>
------------------------------------------------------------------------------
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
