Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
http://tracker.firebirdsql.org/browse/DNET-442 -- Jiri {x2} Cincura (x2develop.com founder) http://blog.cincura.net/ | http://www.ID3renamer.com -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint security, mobile security and the latest in malware threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/ ___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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 disk...@cincura.net wrote: On Tue, Aug 10, 2010 at 15:11, Luis Rizo lriz...@gmail.com 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider -- Sell apps to millions through the Intel(R) Atom(Tm) Developer Program Be part of this innovative community and reach millions of netbook users worldwide. Take advantage of special opportunities to increase revenue and speed time-to-market. Join now, and jumpstart your future. http://p.sf.net/sfu/intel-atom-d2d___ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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.netwrote: 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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
On Tue, Aug 10, 2010 at 15:11, Luis Rizo lriz...@gmail.com 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 Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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 PROJECTTableCreate.sql Description: Binary data OPENINGTableCreate.sql Description: Binary data DOMAINS_CREATE.sql Description: Binary data -- 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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
Anyone have any input or feedback on this issue I'm having? Thanks, -Luis -- 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
Re: [Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
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 -- 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
[Firebird-net-provider] DDEX Has Problems Adding *Some* TableAdapters to My Typed DataSet
I'm using the latest version of the DDEX in Visual Studio 2010. It works great for the most part. However, today I discovered that there are a few tables in my Firebird 1.5 database that I can't add TableAdapters to my DataSet to. For example, if I drag and drop one of these tables to the design space in my DataSet, I get an error message box that says Failed to merge object(s). Object reference not set to an instance of an object.. The same issue occurs if a I try to add a TableAdapter to my DataSet with either/or Fill or Get methods. I've tried to leave out certain fields while building the TableAdapter, but I get the same error. See link below for screenshot: http://i.imgur.com/Q2ekY.png See link below for screenshot of the Table fields/indexes/etc. from VS: http://imgur.com/DB1Ry.png Many thanks and keep up the great work. :) Thanks, -Luis -- 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