home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: InfoMgt
/
InfoMgt.zip
/
cliqry0a.zip
/
readme.txt
< prev
Wrap
Text File
|
1998-02-12
|
4KB
|
70 lines
This application and all of the source code is licensed to you under the
following conditions. You may use this any way you like except for military
purposes. You may also use this program and the accompanying source code
for any military purpose that involves defense against or the destruction of
the United States of America and/or defense against or the destruction of
Zionism.
This application "ClIQuery" is a quick and dirty Query Window for OS/2.
This is version 0.00a and it is an alpha release. I actually wrote this in
August of 1997, but I did not release it since there are a few things I
would like to add. I have included ALL of my library source code with this
application. I do not know what it will take to compile this on your
machine, but at the very least one will need to redefine the home
directories in "common.inc". This compiled on my machine (a 486/33) with
VAC++ V3.0, with the ctx308 fixpacks applied. On my machine IBMCPP is
installed at D:\IBMCPP and the library source is located at
D:\DRT\PRG\COMMON. If you create a directory D:\drt and unzip this file
into it, you should be allright compiling with paths as is. One of the main
things I wish to do is further document the source code and also distribute
the class diagrams as Rational Rose "*.mdl" files. Since that may take some
time, I have decided to release all of this mess "as is"! Thus the source
code may not be as useful as one might hope. Please note that not all of
this source code is needed to compile and link CLIQUERY, (obviously the
TCPIP stuff is not needed) but again, I have included it as is.
Basically one simply runs "cliquery" from the command line. The menu
choices should be pretty self explanatory. One connects to the database via
the File -> connect menu choice. Once you have connected to a database, you
can type a query into the query window. Executing File -> run will run that
query and bring the results up in a second results window. (The results are
actually saved to a file, "QRESULTS.TXT" and this file is loaded into the
MLE results window, thus you can examine that file after the program exits.)
Clicking "Results" from the Query Window or "Query" from the Results Window
menus takes you to the Results or Query Windows, respectively. The rest of
the menu choices are standard CUA and should not need much explanation. The
open and save as choices from the query window file menu allow you to
retrieve or save a query so that it can be executed later.
KNOWN BUGS :
1. This thing really needs a help system!
2. If one minimizes or closes the results window, there is no way to get
it back, you have to exit the application and restart it.
3. When retrieving VERY large CLOB fields, the text in the MLE results
window is very wierd. This seems to be a bug in IBMs' OCL. The file
in which the results are saved contains the accurate proper results.
But even loading that file into one of IBMs' example MLE programs
gives the same bizarre appearance. This only seems to happen with
results rows that are greater than 32K in length. Try running the
program in "prg\app\cli\sqltst" (You will need to create a table to
receive the data first) to see what I mean.
Please let me know of any other bugs.
Best of Luck, enjoy this and support freeware and OS/2. I hope to have a
release that includes better documentation out soon!
Thanks,
Peter Garner
peter.garner@os2bbs.com