SQL Assistant 2.1.0.0 announce
From: Denis V. Berdnikov <doc_at_takthq.lipetsk.su>
Date: Mon, 14 Sep 1998 13:12:46 +0400
Message-ID: <6timjr$5fv_at_news.lipetsk.su>
Hi, All
SQL Assistant - program, which can facilitate a daily transactions the developer of applications for the Oracle server. She allows to execute main DML, DDL of sentence, interrupt long query immediatly. The outcome of execution is represented as the table, which allows navigate to edit selected data and to output them in the file or on the printer. In the given version of the program it is not enough new, especially revolutionary ideas. She is constructed on a principle
"all best for convenience".
In it the advantages of such produced programs both are assembled SQL*Plus (c) Oracle Corp., Database Explorer (c) Inprise Corp.
The server: Oracle 7.1 also is higher (SQL*Net 2 server part) The client - Windows 95 (SQL*Net 2 client part, large fonts optional)
Copy sqlassistant.exe to your local catalog and run it
<Shift> - <Enter> to execute SQL-sentence
<Ctrl> - <Break> to interrupt execution
<Tab> to proceed in the table " an outcome of execution "
<F8> to enter new SQL-sentence
<Ctrl> - <Up> to select the previous sentence in the stack
<Ctrl> - <Down> to select the following sentence in the stack
<Ctrl> - <Enter> to proceed to the following string(line)
of editing of SQL-sentence
<Ctrl> - <Tab> to enter character of tabulation
<Insert> insert new record
<Ctrl>-<Delete> delete record
<Ctrl> - {<c> | <v> | <z> | <a>} as is usual
LeftClick on header of a column - saving column attributes (width,order,...)
In the present version of the program the demo-components are used DOA (c) Allroundautomations, therefore she cannot be the goods!
I shall be glad to accept the remarks and sentences on operation of the program.
E-mail: doc_at_takthq.lipetsk.su
Tel: (0742) 47-0960 (employ)
(0742) 74-1884 (home).
Date: Mon, 14 Sep 1998 13:12:46 +0400
Message-ID: <6timjr$5fv_at_news.lipetsk.su>
Hi, All
cut Readme
Readme SQL Assistant (c) 1998 Denis Berdnikov
The description
SQL Assistant - program, which can facilitate a daily transactions the developer of applications for the Oracle server. She allows to execute main DML, DDL of sentence, interrupt long query immediatly. The outcome of execution is represented as the table, which allows navigate to edit selected data and to output them in the file or on the printer. In the given version of the program it is not enough new, especially revolutionary ideas. She is constructed on a principle
"all best for convenience".
In it the advantages of such produced programs both are assembled SQL*Plus (c) Oracle Corp., Database Explorer (c) Inprise Corp.
The requirements
The server: Oracle 7.1 also is higher (SQL*Net 2 server part) The client - Windows 95 (SQL*Net 2 client part, large fonts optional)
Installation
Copy sqlassistant.exe to your local catalog and run it
Hot keys
<Shift> - <Enter> to execute SQL-sentence
<Ctrl> - <Break> to interrupt execution
<Tab> to proceed in the table " an outcome of execution "
<F8> to enter new SQL-sentence
<Ctrl> - <Up> to select the previous sentence in the stack
<Ctrl> - <Down> to select the following sentence in the stack
<Ctrl> - <Enter> to proceed to the following string(line)
of editing of SQL-sentence
<Ctrl> - <Tab> to enter character of tabulation
<Insert> insert new record
<Ctrl>-<Delete> delete record
<Ctrl> - {<c> | <v> | <z> | <a>} as is usual
LeftClick on header of a column - saving column attributes (width,order,...)
Limitations
- With execution of simplis or external connection
SELECT
Tab1.field1,
Tab2.field1
FROM tab1, tab2
WHERE tab1.id = tab2.id (+)
the fields by first indicated in a phrase FROM can be subject to upgrade the tables, i.e. tab1. If you want to update fields tab2 - put it on the first place.
- The excessive use of blanks can reduce to nonupdatable query
In the following version will be included
- Help on F1
- Compilation of the comments of sort /* hints */ and --
- Saving the "last" name and connect string
- Possibility of use of blanks in any place of sentence
The note
In the present version of the program the demo-components are used DOA (c) Allroundautomations, therefore she cannot be the goods!
The conclusion
I shall be glad to accept the remarks and sentences on operation of the program.
E-mail: doc_at_takthq.lipetsk.su
Tel: (0742) 47-0960 (employ)
(0742) 74-1884 (home).
Doc.
Download from
ftp://ftp.lipetsk.ru/pub/windows/Oracle/SQLAssistant/sqlassist.zip
end cut Readme Received on Mon Sep 14 1998 - 11:12:46 CEST