Question about SQL Console ?

[Joey]

 Posted by:  Joey <J_nospa...@moultriega.net> 

Hi everyone,

I'm using SQL Base 1-User Server on my local Windows XP Pro workstation.
I can connect to the local database using SQL Talk. When I try to
connect using SQL Console I see the databases but can't do anything with
them. My goal is to view the tables and data.

Am I doing something wrong or is it just impossible to use SQL Console
with the 1-User Server ? Any suggestions will be greatly appreciated.

Joey

[Team Developer (Jos)]

 Posted by:  Team Developer <jdv...@hetnet.nl> 

Hi Joey,

I've tried it and to me it seems as if it's not possible to view the
tables and data with SQL Console. However, you can try to use report
builder for that.

Jos

[Hans-Dieter Dreier]

 Posted by:  Hans-Dieter Dreier <sp...@spam.de> 

SQLConsole is for administration purposes only. It cannot be used to view
data. Use SqlTalk / WinTalk (which can execute arbitrary SQL commands and
display the result in a console window) to view tables and data.

--


Greetings,

Hans-Dieter Dreier

[Joey]

 Posted by:  Joey <J_nos...@moultriega.net> 

Do they make such a program or is this possible ????

Microsoft SQL7 uses enterprise manager to connect to the database
and you can view the tables in cell form and even modify the data
in a cell. You can use SQL to link tables and filter and view
the results in cell form and yet make changes to the data there.

I'm using Centura SQL Base 7.01 on a Novell server. Do they make
such a product for Centura SQLBase ??

What I'm wanting to accomplish is to explore the database and
discover what linking needs to be done and possibly make some
changes to the data both here and there and in bulk using SQL.

Any thoughts and ideas for a novice with SQLBase will be greatly
appreciated.

Joey

[Jack Miller]

 Posted by:  Jack Miller <j...@asdfaf.com> 

Joey,

There are third party products available. My favorite one is WinSQL
(http://www.synametrics.com/winsql)