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

2012-06-21 Thread Jiri Cincura
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

2010-08-25 Thread Luis Rizo
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

2010-08-10 Thread Luis Rizo
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

2010-08-10 Thread Jiri Cincura
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

2010-08-06 Thread Luis Rizo
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

2010-08-03 Thread Jiri Cincura
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

2010-08-03 Thread Luis Rizo
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

2010-08-03 Thread Luis Rizo
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

2010-08-02 Thread Luis Rizo
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

2010-07-29 Thread Luis Rizo
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

2010-07-28 Thread Luis Rizo
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