Skip to main content



      Home
Home » Eclipse Projects » DTP » How to get the content of a Table
How to get the content of a Table [message #17129] Fri, 16 June 2006 15:00 Go to next message
Eclipse UserFriend
Originally posted by: zkoppany.gmx.de

Hi,

I use mysql-4.1.19 with eclipse-3.2-RC7 and dtp-sdk_0.9RC5_N061506. How can
I get the content of a table?

Zsolt
Re: How to get the content of a Table [message #17187 is a reply to message #17129] Tue, 20 June 2006 10:52 Go to previous message
Eclipse UserFriend
Originally posted by: jograham.sybase.com

Zsolt Koppany wrote:

> Hi,

> I use mysql-4.1.19 with eclipse-3.2-RC7 and dtp-sdk_0.9RC5_N061506. How can
> I get the content of a table?

> Zsolt

Hi Zsolt,

The first thing you'll want to do is move up to DTP 0.9RC5, since the 6/15
build has a bug which will prevent the following from working.

DTP 0.9 does not have any direct way to get table contents, though we are
looking at this feature for future versions. For now, the best thing to do
is create a .sql file (New-->SQL Development-->SQL File), set the
connection information (right click context in the editor) to your MySQL
connection profile (make sure you have already connected first), and then
do a

select * from.....

and right click "Execute All." The data will then appear in the SQL
Results view ("Database Development" perspective).

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Re: How to get the content of a Table [message #579745 is a reply to message #17129] Tue, 20 June 2006 10:52 Go to previous message
Eclipse UserFriend
Zsolt Koppany wrote:

> Hi,

> I use mysql-4.1.19 with eclipse-3.2-RC7 and dtp-sdk_0.9RC5_N061506. How can
> I get the content of a table?

> Zsolt

Hi Zsolt,

The first thing you'll want to do is move up to DTP 0.9RC5, since the 6/15
build has a bug which will prevent the following from working.

DTP 0.9 does not have any direct way to get table contents, though we are
looking at this feature for future versions. For now, the best thing to do
is create a .sql file (New-->SQL Development-->SQL File), set the
connection information (right click context in the editor) to your MySQL
connection profile (make sure you have already connected first), and then
do a

select * from.....

and right click "Execute All." The data will then appear in the SQL
Results view ("Database Development" perspective).

Regards,
John Graham
Eclipse Data Tools Platform PMC Chair
Previous Topic:Database Explorer vs. Data Source Explorer, other starting questions...
Next Topic:can't access db connection in "set connection info"
Goto Forum:
  


Current Time: Sat May 10 13:47:59 EDT 2025

Powered by FUDForum. Page generated in 0.05908 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top