Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet

[Luis R. <lr...@gm...>]

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 <lr...@gm...> 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 <lr...@gm...> 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 <di...@ci...> wrote:
>>
>>> On Mon, Aug 2, 2010 at 20:44, Luis Rizo <lr...@gm...> 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
>>> Fir...@li...
>>> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>>>
>>
>>
>