Products
CDBF - DBF Viewer and Editor
DBF Viewer/Editor, text-mode
DBF Viewer/Editor for Linux
DBF Viewer/Editor for DOS
DBF reanimator
CDBFlite
CDBFAPI
¤ DBF Script
CDBFinfo
CDBFShell
CDBFview
DBF to CSV Converter
CSV to DBF Converter
DBF to XLS Converter
XLS to DBF Converter
DBF to MDB Converter
MDB to DBF Converter
DBF to SQL Converter
DBF to XML Converter
DBF to DBF Converter
MDB to XLS Converter
CSV to XLS Converter
DBF to HTML Converter
DBF to PDB Converter
PDB to DBF Converter
Excel Library
Access Recovery
Excel Recovery
Online Database Converter
DBF Converters' Shell
WhiteTown Software CD

Functions

There is a rich set of standard functions which can be used in a script.

function IntToStr(i: Integer): String function FloatToStr(e: Extended): String function DateToStr(e: Extended): String function TimeToStr(e: Extended): String function DateTimeToStr(e: Extended): String function VarToStr(v: Variant): String function StrToInt(s: String): Integer function StrToFloat(s: String): Extended function StrToDate(s: String): Extended function StrToTime(s: String): Extended function StrToDateTime(s: String): Extended function Format(Fmt: String; Args: array): String function FormatFloat(Fmt: String; Value: Extended): String function FormatDateTime(Fmt: String; DateTime: TDateTime): String function FormatMaskText(EditMask: string; Value: string): string function EncodeDate(Year, Month, Day: Word): TDateTime procedure DecodeDate(Date: TDateTime; var Year, Month, Day: Word) function EncodeTime(Hour, Min, Sec, MSec: Word): TDateTime procedure DecodeTime(Time: TDateTime; var Hour, Min, Sec, MSec: Word) function Date: TDateTime function Time: TDateTime function Now: TDateTime function DayOfWeek(aDate: DateTime): Integer function IsLeapYear(Year: Word): Boolean function DaysInMonth(nYear, nMonth: Integer): Integer function Length(s: String): Integer function Copy(s: String; from, count: Integer): String function Pos(substr, s: String): Integer procedure Delete(var s: String; from, count: Integer): String procedure Insert(s: String; var s2: String; pos: Integer): String function Uppercase(s: String): String function Lowercase(s: String): String function Trim(s: String): String function NameCase(s: String): String function CompareText(s, s1: String): Integer function Chr(i: Integer): Char function Ord(ch: Char): Integer procedure SetLength(var S: String; L: Integer) function Round(e: Extended): Integer function Trunc(e: Extended): Integer function Int(e: Extended): Integer function Frac(X: Extended): Extended function Sqrt(e: Extended): Extended function Abs(e: Extended): Extended function Sin(e: Extended): Extended function Cos(e: Extended): Extended function ArcTan(X: Extended): Extended function Tan(X: Extended): Extended function Exp(X: Extended): Extended function Ln(X: Extended): Extended function Pi: Extended procedure Inc(var i: Integer; incr: Integer = 1) procedure Dec(var i: Integer; decr: Integer = 1) procedure RaiseException(Param: String) procedure ShowMessage(Msg: Variant) procedure Randomize function Random: Extended function ValidInt(cInt: String): Boolean function ValidFloat(cFlt: String): Boolean function ValidDate(cDate: String): Boolean function CreateOleObject(ClassName: String): Variant function VarArrayCreate(Bounds: Array; Typ: Integer): Variant

As you can see, some functions/procedure have default parameters. You can call it just like in Delphi: Inc(a); Inc(b, 2);

General
Overview
Main Window
Menu File
Menu View
Menu Edit
Dialog Options
Menu Script
Menu Help
How to buy
Command line
Language Reference
Script structure
Data types
Classes
Functions
Events
Enumerations, Sets and Arrays
Pascal
C++
Java Script
Visual Basic
Functions
OpenBase
CloseBase
RecCount
FieldCount
ReadRecord
WriteRecord
FieldNumber
GetStr
GetValue
IsMemoField
IsDigitalField
IsCurrentDeleted
IsDeleted
ClearRecord
ClearField
SetValue
MarkDeleted
RecallRecord
DeleteRecord
AppendRecord
InsertRecord
SortBase
RemoveSort
SetFilter
RemoveFilter
Pack
Zap
Write
Writeln
StopScript
GetFileType
GetRecordLength
GetFieldName
GetFieldType
GetFieldSize
GetFieldFloat
NewDatabase
AddField
CreateDatabase
CreateAndOpenDataBase
RecordToCSV
SetCodepage
ParamCount
ParamStr

Related Links
Help file
Screen shots
Video tutorials

Copyright © WhiteTown Software, 1996-2012 | Privacy policy | Site map