firebird-net-provider

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

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

I should note that while trying to debug this, I created a new DataSet
object, and I was able to add that CODE table with no issues. But when I
tried to add the other table that I had in my real DataSet, I got the same
error. So it looks like there's some kind of conflict between certain
tables. I tried to add additional tables to the new DataSet, some worked,
some did not.

Any thoughts on this?

Thanks,
-Luis

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

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

Anyone have any input or feedback on this issue I'm having?

Thanks,
-Luis

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

[Jiri C. <di...@ci...>]

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

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

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

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

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

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

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

Hi Jiri,

Did you get a chance to try to reproduce the test case I described? Any
thoughts would be greatly appreciated.

Thanks,
-Luis

On Fri, Aug 6, 2010 at 7:21 AM, Luis Rizo <lr...@gm...> wrote:

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

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

[Jiri C. <di...@ci...>]

On Tue, Aug 10, 2010 at 15:11, Luis Rizo <lr...@gm...> wrote:
> to try to reproduce the test case I described

Not yet.

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com

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

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

Hi Jiri,

Any chance you've taken a look at this?

I could try to take a look at it for you and maybe trace the code if you
could give me a bit of guidance on where to start looking for the issue.

Thanks,
-Luis



On Tue, Aug 10, 2010 at 9:58 AM, Jiri Cincura <di...@ci...> wrote:

> On Tue, Aug 10, 2010 at 15:11, Luis Rizo <lr...@gm...> wrote:
> > to try to reproduce the test case I described
>
> Not yet.
>
> --
> Jiri {x2} Cincura (x2develop.com founder)
> http://blog.cincura.net/ | http://www.ID3renamer.com
>
>
> ------------------------------------------------------------------------------
> 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
> Fir...@li...
> https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
>

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

[Jiri C. <di...@ci...>]

http://tracker.firebirdsql.org/browse/DNET-442

-- 
Jiri {x2} Cincura (x2develop.com founder)
http://blog.cincura.net/ | http://www.ID3renamer.com