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 <lriz...@gmail.com> 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 <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
