Switch to Russian Home page of Alexander Kresin
Main Clipper HwGUI Five stones File utilities
Links KS Organizer My photo

Various Clipper stuff

 
TextView()

Function TextView() allow to view large files ( > 64K ) which can't be viewed by standart MEMOEDIT() function.
I usually use it for viewing reports, redirected to a file instead of printer.
Used keys:
ESC - Exit;
F10 - Print;
Shift+Arrow down, Shift+Arrow up - Block operations, requires Clipper Tools library ( NUMAND(), KBDSTAT() - for detectind Shift key )

Function call:
TextView(file_name,y1,x1,y2,x2),
where file_name - name of the file you want to view,
y1,x1,y2,x2 - coordinates of a browse window.
This file is for PUBLIC DOMAIN. You can freely use and modify it.

Calcul()

Just put a line
SET KEY 28 TO CALCUL
to your code - and your application will have a built-in calculator.
Used keys -
ESC - Quit,
F10 - Exit and place rezult to keyboard buffer,
+,-,*,/ - arithmetic operarions,
Space - clear buffer,
Ctrl+F1, Ctrl+F2, Ctrl+F3 - Store buffer to first, second, third memory item,
F1, F2, F3 - Get value from first, second, third memory item.
F9 - set number of decimal digits after '.' (default - 2).
This file is for PUBLIC DOMAIN. You can freely use and modify it.

Upgrading databases

This program will allow you to modify dbf files without using dbu like utilities. It is convenient when you need to make upgrade of your program for few or more clients. You are writing a simple script - the same for all users of your program, then send it to each client. He execute upgrade.exe with this script on his computer - and all dbf modifications are done.
The script commands are described below:
FILE filename -
open dbf file 'filename'
REPLACE fieldname WITH [formula1] [FOR formula2] -
replace field 'fieldname' with values, calculated by expression 'formula1' for records, matching expression 'formula2'
BEGIN_STRU -
the beginning of commands set for structure modification
END_STRU -
the end of commands set for structure modification
Commands for structure modification:
INSERT [AFTER fieldname] newfieldname type [len] [dec] [formula] -
insert new field 'newfieldname' after field 'fieldname' ( or to the end, if AFTER don't signed ) and to fill it with values, calculated by 'formula'
RENAME fieldname newfieldname -
rename field 'fieldname' to 'newfieldname'
CHANGE fieldname type [len] [dec] [formula] -
change options for field 'fieldname' and fill it with values, calculated by 'formula'
DELETE fieldname -
delete field 'fieldname'
This file is for PUBLIC DOMAIN. You can freely use and modify it.

Browse module

This is a browse module - a replacement for dbedit() and TBrowse. The first version of it I wrote more than six years ago for Clipper'87 because I didn't like dbedit(). I have added a lot of possibilities to it since first version, so it's much more powerful than dbedit(). What about comparison with TBrowse - no comments, because I never used TBrowse, the only thing I can say - that this module have mouse support.
This file is for PUBLIC DOMAIN. You can freely use and modify it.


[Download prcview.zip][Download calc.zip][Download upgrade.zip][Download browse.zip]
[Return to main page].
Hosted by www.Geocities.ws

1