rlcc885 / aseisql Goto Github PK
View Code? Open in Web Editor NEWAutomatically exported from code.google.com/p/aseisql
Automatically exported from code.google.com/p/aseisql
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)+')'
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 11:46
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.
Original issue reported on code.google.com by [email protected]
on 27 Jul 2009 at 1:04
** 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?
Original issue reported on code.google.com by [email protected]
on 14 Aug 2009 at 4:26
Attachments:
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)
Original issue reported on code.google.com by [email protected]
on 27 May 2009 at 9:51
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.
Original issue reported on code.google.com by [email protected]
on 27 Jul 2009 at 1:09
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>.
Original issue reported on code.google.com by [email protected]
on 8 Sep 2009 at 7:27
Attachments:
Hi!
Support for "user-defined functions" in Object Browser.
Thank you.
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 7:07
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.
Original issue reported on code.google.com by [email protected]
on 2 Oct 2009 at 4:44
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.
Original issue reported on code.google.com by [email protected]
on 15 May 2009 at 6:28
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!
Original issue reported on code.google.com by [email protected]
on 8 Oct 2009 at 8:36
Attachments:
Usability.
Icon for reconnect to the current login.
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 3:30
Data Cache
Database Devices
Dump Devices
ASE configuration parameters
Logins
Roles
Remote Servers
Groups
Users
Original issue reported on code.google.com by [email protected]
on 7 May 2009 at 7:54
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.
Original issue reported on code.google.com by [email protected]
on 22 May 2009 at 8:56
Attachments:
Hi
You can enable "Tab Space" equal to two?
Thank you!
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 11:22
To include in the right click menu window an "Execute..." option. This
option will allow the user to execute the selected text...
Original issue reported on code.google.com by [email protected]
on 2 Jun 2009 at 10:15
Hi!
There is possibility to show the "spid" in the "status bar".
It would be very useful.
Tks!
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 11:13
The option "Change case" does not work with accents.
/*
áéíóú
àèìòù
*/
Original issue reported on code.google.com by [email protected]
on 10 Oct 2009 at 8:42
There is the possibility to include comments folding in the editor?
- /* + /*
| ... */
| ...
| ...
*/
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 3:11
Editor's Choice.
Option to remove all the spaces(' ') and tabs('\t') that exist at the end
of line.
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 6:19
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]
Original issue reported on code.google.com by [email protected]
on 17 May 2009 at 8:49
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
...
Original issue reported on code.google.com by [email protected]
on 22 Jun 2009 at 5:30
Close tabs with middle button of the mouse.
It's a shortcut.
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 3:33
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.
Original issue reported on code.google.com by [email protected]
on 13 Aug 2009 at 4:57
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.
Original issue reported on code.google.com by [email protected]
on 11 Aug 2009 at 9:15
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.
Original issue reported on code.google.com by [email protected]
on 29 May 2009 at 10:03
*** 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.
Original issue reported on code.google.com by [email protected]
on 30 Jul 2009 at 12:49
Attachments:
You could make an option to send the resultset directly to a file without
displaying them on screen?
Original issue reported on code.google.com by [email protected]
on 12 Oct 2009 at 12:37
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.
Original issue reported on code.google.com by [email protected]
on 15 May 2009 at 6:06
*** 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.
Original issue reported on code.google.com by [email protected]
on 30 Jul 2009 at 12:31
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.
Original issue reported on code.google.com by [email protected]
on 13 Jul 2009 at 4:00
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.
Original issue reported on code.google.com by [email protected]
on 18 Aug 2009 at 3:31
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. :)
Original issue reported on code.google.com by [email protected]
on 10 Oct 2009 at 8:23
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.
Original issue reported on code.google.com by [email protected]
on 13 Aug 2009 at 5:40
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
...
...
Original issue reported on code.google.com by [email protected]
on 10 Oct 2009 at 8:10
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.
Original issue reported on code.google.com by [email protected]
on 31 Jul 2009 at 8:00
Attachments:
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)+')'
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 11:46
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.
Original issue reported on code.google.com by [email protected]
on 10 Aug 2009 at 9:31
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.
Original issue reported on code.google.com by [email protected]
on 1 Oct 2009 at 5:04
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...
Original issue reported on code.google.com by [email protected]
on 22 May 2009 at 8:46
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.
Original issue reported on code.google.com by [email protected]
on 2 Jun 2009 at 10:12
Is is possible to allow for more than one query window?
Original issue reported on code.google.com by [email protected]
on 7 May 2009 at 7:51
Changing visual.
Show indentation when the line has no spaces or tabs (' ', '\t').
You can perform this visual change?
Thank you :)
Original issue reported on code.google.com by [email protected]
on 9 Oct 2009 at 6:05
Attachments:
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
Original issue reported on code.google.com by [email protected]
on 7 May 2009 at 7:50
it is only allowed to view data of an entry of resultsets.
Original issue reported on code.google.com by [email protected]
on 1 Sep 2009 at 1:04
Attachments:
You could add the functionality to move the tabs?
To have better control.
Original issue reported on code.google.com by [email protected]
on 12 Oct 2009 at 12:23
Hi!
New Macro: (stubs.sql, ustubs.sql)
%USERNAME_DB% Current user name in the database. (dbo, ...)
Thank you for your attention.
Original issue reported on code.google.com by [email protected]
on 7 Oct 2009 at 8:30
*** 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
Original issue reported on code.google.com by [email protected]
on 30 Jul 2009 at 12:39
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.
Original issue reported on code.google.com by [email protected]
on 22 Sep 2009 at 2:05
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.
Original issue reported on code.google.com by [email protected]
on 22 May 2009 at 1:43
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
Original issue reported on code.google.com by [email protected]
on 8 Oct 2009 at 10:09
Attachments:
A declarative, efficient, and flexible JavaScript library for building user interfaces.
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
An Open Source Machine Learning Framework for Everyone
The Web framework for perfectionists with deadlines.
A PHP framework for web artisans
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
Some thing interesting about web. New door for the world.
A server is a program made to process requests and deliver data to clients.
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
Some thing interesting about visualization, use data art
Some thing interesting about game, make everyone happy.
We are working to build community through open source technology. NB: members must have two-factor auth.
Open source projects and samples from Microsoft.
Google ❤️ Open Source for everyone.
Alibaba Open Source for everyone
Data-Driven Documents codes.
China tencent open source team.