Support - dBaseWinner

This program is designed for developers who use dBase tables, know Delphi and SQL and have installed Borland BDE.

Trial version has no limits in 30 days.

Supported 4-char's substrings (replace -> repl, set filter -> set filt ... etc)

All functions are fully compatible with Delphi Pascal.

Don’t use DBase logical expressions like as ".and.", ".not." etc., instead use just "and", "not" etc.

Evaluation order can be made explicit by using brackets.

All logical operations must be separated with brackets
e.g. replace field1 with 1000 for (field2<=1000) and (field3=strtodate(‘01.01.2015’)) while not eof()

Before print, adjust column widths in the grid, and try preview.

Click "AutoFit" to set optimal width for every column.
Click "Save Grid" to save grids view.

Use "Restore last session" to continue work from yesterday.
All commands, tables and folders will be reloaded.

Old Dbase function "round" has been replaced with "tround"
e.g. tround(123.567,2)=123.57

Eof() and Bof() brackets are allowed only because of unrecoverable nostalgia.
Red colored functions are under construction.

Supported functions :

replace

	[replace]fieldname[with]expression
	[replace][all]fieldname[with]expression
	[replace][all]fieldname[with]expression[for]condition
	[replace]fieldname[with]expression[for]condition[while][not][eof()]
	[replace]fieldname[with]expression[for]condition[while][not][bof()]
	[replace]fieldname[with]expression[while][not][eof()]
	[replace]fieldname[with]expression[while][not][bof()]

delete

	[delete]
	[delete][selected]
	[delete][all]
	[delete][all][for]condition
	[delete][for]condition[while][not][eof()]
	[delete][for]condition[while][not][bof()]
	[delete][while][not][eof()]
	[delete][while][not][bof()]

recall

	[recall]
	[recall][selected]
	[recall][all]
	[recall][all][for]condition
	[recall][for]condition[while][not][eof()]
	[recall][for]condition[while][not][bof()
	[recall][while][not][eof()]
	[recall][while][not][bof()]

set filter

	[set][filter][to]
	[set][filter][off]
	[set][filt][to] expression

	click on "Filter" green led to switch off filter

set delete

	[set][delete][on]
	[set][delete][off] to view deleted records

index

	[index] open form to manipulate with indexes
	[index][off] cancel index

	or click "Index setting" button
	click on "Index" green led to switch off index

range

	[set][range] open input form to set range
	[set][range][to] cancel range
	[set][range][off] cancel range

	or click "Range setting" button
	click on "Range" green led to switch off range

set relation

	[set][relation][on]fieldname[into]tablename, indexname (no quotes in indexname!)
	[set][relation][on] cancel relation

searching

	[findkey] indexed value
	[findnearest]indexed value
	[locate][for]expression
	[continue] locate for next located expression

	or click "Continue" button

sum

	[sum] display sum for selected numeric fields
	[sum][all] display sum for all numeric fields
	[sum][all][for]condition display sum for all numeric fields for condition
	[sum][while][not][eof()]
	[sum][while][not][bof()]
	[sum]expression
	[sum]expression[while][not][eof()]
	[sum]expression[while][not][bof()]
	[sum]expression[for]condition
	[sum]expression[for]condition[while][not][eof()]
	[sum]expression[for]condition[while][not][bof()]

copy

	[copy][to]newdbasetable
	[copy][structure][to]newdbasetable

sql

open SQL designer

other

	[append][from]table
	[append] or click Append button
	[edit] or click Edit button
	[excel] or click Excel button
	[pack] or click Pack button
	[zap] or click Zap button
	[print] or click Print button
	[fields] or click Fields button to open fields designer form
	[export][to]myfile,delimiter char export to ".csv" file
	[import][from]myfile,delimiter char import from ".csv" file
	[set][format]numformat numeric fields display format
	[create] newdbasetable
	[modify][structure]
	[display][structure]
	[convert][437to852] conversion old cp 437 to 852 for opened table
	[convert](all)[437to852] conversion old cp 437 to 852 for all tables into folder
	[?]expression returns expression result
	[?]range returns range definition
	[?]index returns active index expression

move,skip,goto

	[goto]record
	[goto][top]
	[goto][bottom]
	[skip] n records
	[quit] close application change two records positions (select two record and press "Change row" button) move record to another position (right click and drag it on another position). Confirm with Ctrl+mouse click

not supported Delphi functions (old Dbase functions)

	(not supported in sql section!)
	ctod strtodate
	dtoc datetostr
	month month of date
	year year of date
	at pos(substr,string)
	val(string) strtofloat(string)
	str(float) floattostr(float)

other functions

	UpperFirstLetter capitalize first letter of any word into string
	Reverse reverse all letters into string
	ReverseWords reverse all words into string
	tround(x,y) round float x to y decimals
	texp(x,y) x exp y (x float, y integer)
	factorial(x) x (integer) >=0
	fnpi 3.1415926535897932384626433
	fne = exp(1) 2.718281828459045

Write your own functions library. Just create function and add it into file functions.pas

and special appendix

	Write your own program in Delphi pascal click "Delphi prog." button
	Join more commands and execute them click "Multilines" button

This file, named Help.rtf, is not read only. Add your own functions and describe them.
Share your functions and suggestions with other users on http://www.dbasewinner.eu

For all other informations, or new versions, click on