SQL Anywhere database

Author

sql tool

Eric ten Westenend

2005-10-27, 7:41 am

Hello,

Is there any other sql tool with sql support than Sybase central?

Eric

Joshua Savill

2005-10-27, 7:41 am

There is Interactive SQL (dbisql and dbisqlc). There are also some sample
applications provided in the Samples folder of the SQL Anywhere install.
What are you attempting to accomplish?

--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"Eric ten Westenend" <e.ten.westenend@[nospam]zonnet.nl> wrote in message
news:435e70a3@forums
-2-dub...
> Hello,
>
> Is there any other sql tool with sql support than Sybase central?
>
> Eric
>

E. ten Westenend

2005-10-27, 7:41 am

Hello Joshua,

Some tools on the market (like database workbench) have sql support in the
sql edit window.
So if you enter "select * from" a list of tables is how to pick from.
If you enter " select * from employee e where e." you get a list of the
fields in employee.

Eric

"Joshua Savill" <jsavill@ianywhere.com> schreef in bericht
news:435e7820@forums
-2-dub...
> There is Interactive SQL (dbisql and dbisqlc). There are also some sample
> applications provided in the Samples folder of the SQL Anywhere install.
> What are you attempting to accomplish?
>
> --
> Joshua Savill
> iAnywhere Solutions - Product Support Analyst
>
> "Eric ten Westenend" <e.ten.westenend@[nospam]zonnet.nl> wrote in message
> news:435e70a3@forums
-2-dub...
>
>

Joshua Savill

2005-10-27, 7:41 am

Eric,

Sounds like it could be a neat enhancement to our product. I suggest you
post the suggestion to sybase.public.sqlanywhere. product_futures_disc
ussion
and see what feedback you get from our engineering group.

Cheers,
--
Joshua Savill
iAnywhere Solutions - Product Support Analyst

"E. ten Westenend" <ewestenend@bcsbv.nl> wrote in message
news:435f25ca@forums
-1-dub...
> Hello Joshua,
>
> Some tools on the market (like database workbench) have sql support in
> the
> sql edit window.
> So if you enter "select * from" a list of tables is how to pick from.
> If you enter " select * from employee e where e." you get a list of the
> fields in employee.
>
> Eric
>
> "Joshua Savill" <jsavill@ianywhere.com> schreef in bericht
> news:435e7820@forums
-2-dub...
>
>

Greg Fenton

2005-10-27, 7:41 am

E. ten Westenend wrote:
> So if you enter "select * from" a list of tables is how to pick from.
> If you enter " select * from employee e where e." you get a list of the
> fields in employee.
>

BTW: please always post the version and build number of SQLAnywhere that
you are using (e.g. use the command "dbeng9 -v" for SQLAnywhere 9.x).

DBISQL (Interactive SQL) has this. Press F7 or Tools->Lookup Table
Name. There is also the GUI-ified query editor (Tools->Query Editor).

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links