rlcc885 / aseisql Goto Github PK

Currently it is not possible:
- to delete statements stored in the history tab...
- to select more than one statements and paste them at once in the query tab...
- to save the history in a txt file...

1. Show the menu (Ctrl + Spacebar) with the shortcut (Ctrl + Enter), is
more convenient and faster for me. 

You can use the two shortcuts for that purpose? 

2. Hide the menu that is displayed with the shortcut (Ctrl + Spacebar) with
the Esc key.

3. Refresh the process view with the F5 key.



Thank you very much for considering my proposals. :)

What steps will reproduce the problem?
1. Highlight on table and view table DLL.
2.
3.

What is the expected output? What do you see instead?
Should show the create table statement

What version of the product are you using? On what operating system?
Trunk.92
Built on 2009-07-27

Please provide any additional information below.

Attempt to insert NULL value into column 'id_order', table '#tmp'; column 
does not allow nulls. Update fails.

When a connection profile is defined, it is not possible to set an alias
for this connection. As it is in my case, if you have a long list of
profiles (I have more than 20 sybase servers, productions environments,
test environments, with the same databases...) it is difficult to find the
right connection.

So... allowing the users to define alias for a connection or/and to group
them into a "Profile Group" definition, something like "Test Databases",
"Production"... it will improve the way in which the users can manage their
profiles/connection...

Thanks for this great tool...
And if it is possible I would like to be part of this...
Regards
MENTOR (Spain)
[email protected]

To include in the right click menu window an "Execute..." option. This
option will allow the user to execute the selected text...

What steps will reproduce the problem?
1. Connect with a non white icon color
2. Save workspace
3. Open new session (white icon) and load previous workspace

What is the expected output? What do you see instead?
=> icon color stays white instead of the chosen color

What version of the product are you using? On what operating system?
=> trunk.123 / XP

Please provide any additional information below.

There is the possibility to include comments folding in the editor?

- /*   + /*
|  ...   */
|  ... 
|  ...
  */

What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?
 ss

What version of the product are you using? On what operating system?
 Sybase ASE ODBC Driver  Version 4.20.00.67 ( I guss this is called 12.5)

Please provide any additional information below.
Previous used sybase 11.5 driver.

Is is possible to implement a more convential cut and paste mechanism?
Cntrl-C for copy
Cntrl-X for cut
Cntrl-V for paste
Cntrl-A to select all

When press "Ctrl + space" after the table name, display the columns of the
table with its type, size and requirement (null/not null), the same infos
of columns that are showed on table DDL. It would be the same when you
press ctrl + space in the query tab, but to columns after <TABLE>.

Is is possible to allow for more than one query window?

Close tabs with middle button of the mouse.

It's a shortcut.

What steps will reproduce the problem?
1. select a table in the object browser
2. right click and select table ddl
3. repeat, it sometimes takes a few times until the error occurs

What is the expected output? What do you see instead?
Expect output is the table ddl

Actual output is 
------------------------ Execute ------------------------
Attempt to insert duplicate key row in object '#tmp00000130017331117' with 
unique index '_tmp_6986082971'
Command has been aborted.
----------------- Done ( 1 errors ) ------------------

What version of the product are you using? On what operating system?
Product version is 2007-11-19
Sybase dbms is 15.2.0 and 12.5.0 on Solaris 10 and 8 respectively

Please provide any additional information below.

You could add the functionality to move the tabs?

To have better control.

Is it possible to have a graphical execution plan of the sybase, and if 
its performing nested loop joins data > MaxConfigureRows then would it do 
any sugessions like could replace this inner join with a hash join or 
Merge Join sugessions for performece. 

Having a graphical plan of the IO and what its doing like index seek/scan 
or table scan would realy benifit.

** What steps will reproduce the problem?
1. try to log in to a sybase iq server  (I know this was made with ASE in
mind but sybase iq can also connect via sybase open client)

** What is the expected output? 
Login success  (.. and begin working)

** What do you see instead?
a messagebox saying:
ASA error -265: Procedure 'sp_server_info' not found


** What version of the product are you using? 
AseIsql Trunk.92 with the revision #97 fix in stubs.sql

** On what operating system?
Windows vista x86 32bit SP1


** Please provide any additional information below.
In the 2007-11-19 version it works just fine. 

This also happens when connecting to a replication server.

Is the trunk version executing 'sp_server_info' upon login and the 2007
version not?

You could make an option to send the resultset directly to a file without
displaying them on screen?

*** What steps will reproduce the problem?
1. Create a procedure (any name) having a select like:
   select * from table1 for xml option 'incremental=yes'
2. In the object browser locate the new stored procedure
3. Double click it > select Open procedure

*** What is the expected output? 
create procedure noname as
select * from table1 for xml option 'incremental=yes'

*** What do you see instead?
create procedure noname as
select * from table1  option 'incremental=yes'

*** What version of the product are you using? 
AseIsql (any version)

*** On what operating system?
Windows (Any), Wine (any)

*** Additional information:
the only thing missing is the "for xml" in the select statement

it is only allowed to view data of an entry of resultsets.

The icon color feature is great.  But it can be better if you could make
the color list "user defined".

Maybe the registry or an .ini file can do the job.  The content of the file
could be a list of the id of the color plus the RGB representation of the
color.

Hi!

New Macro: (stubs.sql, ustubs.sql)

%USERNAME_DB%   Current user name in the database. (dbo, ...)


Thank you for your attention.

When i run my proc on a debug mode then we see that, 250 new result 
windows open, could we have one datawindow and child datawindows inside it 
colapsable so that it all appars in one big result window.

ie., i have a cursor in which i do selects.
This causes 250 new windows.

i wanted to compare the results and i would be easy if i have two 250 
child datawindows inside the reslut datawindow.

What steps will reproduce the problem?
1. Open AseIsql and connect to some database
2. At Object Browser, right click on a procedure and select "Open Procedure"
3. Execute (F9)

What is the expected output? What do you see instead?

It's appears on log panel, and the procedure is not compiled.

Incorrect syntax near 'use'.
Incorrect syntax near '.'.


What version of the product are you using? On what operating system?
trunk 123 / win XP PRO

Please provide any additional information below.

*** What steps will reproduce the problem?
1. In the object browser, double click the table
2. Select Table DDL

*** What is the expected output? 
Previous versions show the output desired:
txt
create table dbo.empresa(
   codigo   varchar(10)  null,
   nomenc   varchar(10)  null,
   nombre   varchar(50)  null,
   direccion   varchar(50)  null,
   telefono1   varchar(15)  null,
   telefono2   varchar(15)  null,
   ruc   varchar(30)  null,
   cia_alt   varchar(20)  null,
   tipo_emp   varchar(10)  null,
   ftp   bit  not null,
   existencia   bit  not null,
   exi_farma   bit  not null,
   traslado   bit  not null,
   crear   bit  not null,
   listar   bit  DEFAULT  0   not null,
   lote   bit  DEFAULT  0  not null,
   ciaappx   varchar(4)  null,
   nnomenc   varchar(4)  null
)
alter table empresa lock allpages
go
create clustered index idx_empresa on dbo.empresa ( codigo ASC)

*** What do you see instead?
Trunk version shows an error and doesn't execute
-  Attempt to insert NULL value into column 'id_order', table '#tmp';
column does not allow nulls. Update fails.


*** What version of the product are you using?
Working version: AseIsql 2007-11-29
Non Working version: AseIsql Trunk.92 Build 2009-07-27

*** On what operating system?
Windows Vista home Premium SP1 32bit


*** Aditional information:
This only happens with some tables, not all.

What steps will reproduce the problem?
1. Open a window and execute the following lines
2. select * from master..syslocks where dbid = 8
     go
   select * from master..sysprocesses
3. Now go on to Reslts tab 2 click refresh and click refresh again will 
refresh in Tab 1 

What is the expected output? What do you see instead?
To refresh in Tab 2 The Active tab should be refreshed.

What version of the product are you using? On what operating system?
trunk.92
Built on 2009-07-27

Please provide any additional information below.

What steps will reproduce the problem?
1. move the ase isql to a non primary monitor
2. perform any action that requires a right mouse click, i.e. close a tab
3.

What is the expected output? What do you see instead?
Expected output is the right click menu window to appear.
Actual output is nother occurs.

What version of the product are you using? On what operating system?
Product version is 2007-11-19

Please provide any additional information below.

What steps will reproduce the problem?
1. Open ASE Isql
2. Connect to a database
3. Run a query
4. In the Result Tab...
     4.1 click on the command menu
     4.2 click on the SQL History...
5. Nothing happens

What is the expected output? What do you see instead?
SQL History Tab

What version of the product are you using? On what operating system?
2009-05-20

Please provide any additional information below.

When we right click and say copy all on the response or error window could we 
also get the date time stamp + procname(linenumber) : text 

all the data in the list-view as text copied to clipboard.

Very good if you have print statements in stored proc and analying each proc 
inside taking how much time.

Thank you.

Why cant we see what is the clustured index what is the fragmentation on 
it and other details of stats are up to date or out of date.

Need more usability to it, its a wonderfull tool love the ctrl+click its 
the best i have seen not even in microsoft sqlserver 2008, wonderfull 
please let us know if there is any new release.

What steps will reproduce the problem?

1. Create SQL with multiple immediate inserts
2. insert into xxx values (yyy, zzz)
3. Execute all inserts
4. Check active db processes. There is none
5. Check processor usage 1 processor is 100% used.

What is the expected output? What do you see instead?

No processor usage, immediate response in log.

What version of the product are you using? On what operating system?

Trunk.92 version. I believe it does not depends on OS used.

Please provide any additional information below.

Test SQL statements is attached.

What is your opinion about this change?

--<General\Set\onoff\on>--
on
%SELB%
--<General\Set\onoff\off>--
off
%SELB%
--<General\Set\fmtonly {on | off}>--
set fmtonly on%SELB%off
--<General\Set\showplan {on | off}>--
set showplan on%SELB%off
...
...

Hi

You can enable "Tab Space" equal to two?

Thank you!

What steps will reproduce the problem?
1. In a database with a large number of objects open the object browser 
window
2. In the search box type a text string that should return a large number 
of objects
3.

What is the expected output? What do you see instead?
Expect output is all the objects that match the text string.

The actual output is only the first 15 objects, other objects that match 
the text string are not being displayed.

What version of the product are you using? On what operating system?
2009-05-20 on Windows Vista

Please provide any additional information below.

What steps will reproduce the problem?

The option "context menu -> SQL -> Copy proc exec" fails when the stored
procedure has output parameters.


What is the expected output? What do you see instead?

Output:
"Ase isql-Error"
"Syntaxis error: waiting for keyword OUT[PUT], received: INT"


What version of the product are you using? On what operating system?

Trunk 132

*** What steps will reproduce the problem?
1. perform an update to a large table (a large update so you can have time
to use the cancel feature)
2. command > cancel > suicide process

*** What is the expected output? 
execution stops normally

*** What do you see instead?
execution stops, but a messagebox says:  error initializing SQLCONTEXT


*** What version of the product are you using? On what operating system?
AseIsql Trunk.92 built 2009-07-27
Windows Vista home premium 32bit SP1

*** Please provide any additional information below.
Previous version worked just fine.

Data Cache
Database Devices
Dump Devices
ASE configuration parameters
Logins
Roles
Remote Servers
Groups
Users

Hi!

Support for "user-defined functions" in Object Browser.

Thank you.

Data types "numeric" and "decimal" has the same format.

Change in "stubs.sql":

Before:

if (@coltype = 'numeric') select @txt = @txt +
'('+convert(varchar(10),@prec)+','+convert(varchar(10),@scale)+')'

After:

if (@coltype in('numeric', 'decimal')) select @txt = @txt +
'('+convert(varchar(10),@prec)+','+convert(varchar(10),@scale)+')'

Hi!

There is possibility to show the "spid" in the "status bar".

It would be very useful.

Tks!

Changing visual.

Show indentation when the line has no spaces or tabs (' ', '\t').

You can perform this visual change?

Thank you :)

Current organization of the profiles brings a set of problems.
profiles are stored in the registry key
HKEY_CURRENT_USER\Software\FM2i\aseisql\profiles

each key=value entry contains
[email protected]/CHARSET=CRYPT(PASSWORD+ENCRYPT_KEYS)

the format is not extensible.
if server name contains dot character, then it brings problems for the key
name.

Future change offer:
The key will be formed as SERVER.DATABASE/CHARSET
but it will be just an alias that could be renamed.
all connection parameters will be stored as Multi-String value in format:
server=syblocal
database=master
...

Usability.

Icon for reconnect to the current login.

What steps will reproduce the problem?
1. Open the ASE ISQL
2. Connect to a DataBase
3. Write:
    Line 1... a
    Line 2... b
    Line 3... c
4. Select Menu Edit, Option Format SQL..
5. System error #3 has been occured...


What is the expected output? What do you see instead?
No error..

What version of the product are you using? On what operating system?
Trunck 38 - 2009-05-20
Windows XP SP3

Please provide any additional information below.

Editor's Choice.

Option to remove all the spaces(' ') and tabs('\t') that exist at the end
of line.

Support for all reserved words.
(ANSI, Transact-SQL)

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc36271.1502/html/
blocks/BEIEHICE.htm

Thanks for everything!

1 - You open aseisql 
2 - You write some queries 
3 - You want to save your queries to a sql file 
4 - You get an ugly message... 
Note that it happens when you are not connected to a database. 

Data types "numeric" and "decimal" has the same format.

Change in "stubs.sql":

Before:

if (@coltype = 'numeric') select @txt = @txt +
'('+convert(varchar(10),@prec)+','+convert(varchar(10),@scale)+')'

After:

if (@coltype in('numeric', 'decimal')) select @txt = @txt +
'('+convert(varchar(10),@prec)+','+convert(varchar(10),@scale)+')'

Currently it is not possible to save into a file (txt file) the information
that currently it is shown in the Log window. This log window is used to
show: the "query process plan", the "query time statistics", print
statements, etc...
Allowing the user to send this information to a file, it will be possible
to compare times, executions, results (print)

The option "Change case" does not work with accents.

/*

áéíóú

àèìòù

*/

What steps will reproduce the problem?
1.Create a stored procedure with cursor call 2nd proc inside the first 
proc.
2. execute the query with parameters
3. cancel the execution and cancel wont work. 

What is the expected output? What do you see instead?
Query cancelled.

What version of the product are you using? On what operating system?
XP: latest.

Please provide any additional information below.