Hello Informix users:

I'm offering DBStudio for Informix as a Free application in trail mode (you can't save or restore files, but you can do everything else.)

If anyone is interested in trying this software, please e-mail me.

DBStudio for Informix is a SQL Delphi-like Editor IDE for rapid store procedure
and query development. It is targeted for Software developers and database
administrators primarily.

The primary objective of DBStudio is to enhance and speed up SPL database
development.


--------------------------------------------------------------------------------
1.) INTRODUCCION
--------------------------------------------------------------------------------

This is version 1.0.9 of DBStuido for Informix.

DBStudio for Informix was/is developed completely by:

- Jose J. Sanchez Rico (jesussanchez@iteso.mx,
SanchezJose@hotmail.com,
jesussanchez@mayanresorts.com.mx,
is34704@msn.com (Messanger))

PLEASE REPORT BUGS, NEW FEATURES, PROPOSALS TO THE EMAILS ABOVE WITH DBSTUDIO AS
SUBJECT.

DBStudio for Informix is a SQL Delphi-like Editor IDE for rapid store procedure
and query development. It is targeted for Software developers and database
administrators primarily.

The primary objective of DBStudio is to enhance and speed up SPL database
development.

DBStudio is FREE, as is, without guarantees or support of any kind.
(But will be willing to add new features and fix bugs).

--------------------------------------------------------------------------------
2.) HISTORY:
--------------------------------------------------------------------------------
DBStudio was born because of my need to develop triggers, views, and
store procedures for a LARGE informix database. I never found an IDE or Editor
that could fit my needs for managing source code, the way Delphi does it for
Pascal code. So I developed this tool to help me do so.

--------------------------------------------------------------------------------
3.) INSTALATION:
--------------------------------------------------------------------------------
1. Unzip to folder and use.
2. To create a conection to an informix database you must put the values as int
Setnet32.

Example:
Connection: Name of the connection "My connection"
Instance / Server: on_informix
Database: dbmydatabase
User: informix
Password: mypassword


--------------------------------------------------------------------------------
4.) FEATURE LIST:
--------------------------------------------------------------------------------

1. Advanced Syntax Highlighting for Informix
a. Tables
b. Stored procedures
c. Reserved words
d. Data types
e. SQL Functions
2. Code Completion.
3. Code Templates. (Customizable).
4. Store procedure parameter listing
5. Bookmarks
6. Find-Go to store procedures
7. Search, Replace, go to line…
8. DB Properties Treeview with
a. Tables (Columns, Primary Keys, Foreign Keys, Indexes,
Unique Constraints and Check Constraints
b. Store procedures (and their definition)
c. Views (and their definition)
d. Triggers (and their definition)
e. Other Database types
9. Printing with syntax highlighting.
10. Save-restore sql files.
11. Multiple editor windows
12. Telnet integration (simple telnet).
13. Languages (Spanish, English)

--------------------------------------------------------------------------------
5.) KNOWN BUGS:
--------------------------------------------------------------------------------

1. Executing multiple non-query statementes (create, insert...) does not
work sometimes (Drop-create Triggers). Must be done 1 by 1.
2. Subqueries not supported completely for viewing.

DBStudio for Informix is now completely FREE!!!!

Save and restoring files has now been implemented, along with a lot of usefull features such as...

Ctrl+Click on a table/view to open the data,
Ctrl+Click on a trigger, store procedure to open its code.

Saving changes in tables in query view...

Jose Sanchez

Download from...

http://kino.iteso.mx/~caceves/DBStudio/index.html

Download the FULL FREE version of the installer at :


http://kino.iteso.mx/~caceves/DBStudio/index.html


Please email me with bug’s, wanted features...


Informix ClientSDK, and Setnet32 is needed for connectivity to Informix databases.


Thanks

http://kino.iteso.mx/~caceves/dbstudio/

http://kino.iteso.mx/~caceves/dbstudio/

-------------------------------------------------------------------------------
Version : 1.0.25
Date : 24-Nov-2006
Description: 1.) Localization corrections, some conection messages where still
in spanish.
2.) New conections now fixed. Specially if its the first connection.
3.) CLIENT_LOCALE can now be configured manualy in the conexiones.dsc
(In the connection form, using the "manual" button.
UPCOMING FEATURES:
b.) Compatibility with FreeVCS.
c.) INI file configuration menu and screens.
e.) Tool: Source code correction.
Identation, change tabs for spaces.
g.) Search form: Interaction with editor at the same time.
h.) When compiling, the editor does not maintain correctly the
scroll position.
i.) Form for short-cut configuration.
j.) Action for deleting backup files.
k.) Copy AND SELECT grid to clipboard, be it a column, row or
al grid info.
m.) Save default conection
o.) Pressing Ctrl must hyperlink the selected row if it's a word
that will open something (SP, Trigger, view, table name...)
p.) Sintax analyzer
q.) Debugger?
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.24
Date : 21-Nov-2006
Description: 1.) SynEdit component update, now using version 2.0.3, this version
is updated however.
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.23
Date : 13-Nov-2006
Description: 1.) Copy information from grid to clipboard, be it a column, row or
all grid info, as a popup menu for the grid, it currently does not
select the column or row.
-------------------------------------------------------------------------------

-------------------------------------------------------------------------------
Version : 1.0.22
Date : 27-Oct-2006
Description: 1.) Delphi database components treat ':' as a parameter calling, it
has been fixed changing it to a '::' so it can function internally.
-------------------------------------------------------------------------------