Kirix Strata Help Manual
Contents
| Index
- A -
abs()
accessing data
acos()
activating the software
add fields
add new records
aggregate functions
api
append records
application video
asin()
atan()
atom
avg()
- B -
back
back up projects
bookmarks
bookmarks toolbar
boolean expressions
browsing the web
- C -
calculated fields
calculations
ceiling()
cell editing
characters
child tables
chr()
column views
columns
add
add breaks
colors
datasheet
delete
edit views
hiding
inserting
moving
combine tables
compact project
connections
console panel
contains()
conversion functions
convert to fixed fields
copying records
cos()
create calculations
create connections
creating a new table
creating formulas
csv
curdate()
currentDate()
- D -
data
exporting
importing
protect
read-only
data links
data menu
data operations
adding data
append
calculate
copy
delete
filter
group
mark
order
overview
query
removing data
replace
sort
update
data transformation
databases
date time functions
date()
dates
day()
dayname()
dayofweek()
db2
decimals
default project
delete fields
deleting records
demonstration video
desiging reports
design view
divide tables
dynamic fields
- E -
ebcdic format
ecmascript
edit calculated fields
edit column views
edit indexes
edit menu
editing data
empty count
empty()
end user licensing agreement
example video
existing projects
exp()
expired license
exporting
expressions
extensions
external databases
- F -
favorites
feeds
field name
field type
field width
fields
add
delete
move
file menu
files
csv
ebcdic
fixed-length
text-delimited
txt
filter groups
filter records
filter related records
find data
find text
fixed fields
fixed-length files
floor()
fonts
format reports
format toolbar
formula builder
formula functions
formula rules
formulas
forward
functions
abs()
acos()
aggregate
asin()
atan()
avg()
ceiling()
chr()
contains()
conversion
cos()
curdate()
currentDate()
date time
date()
day()
dayname()
dayofweek()
empty()
exp()
floor()
hour()
iif()
index
instr()
isnull()
left()
length()
lfind()
list
ln()
log()
lower()
lpad()
ltrim()
max()
min()
minute()
mod()
month()
monthname()
numeric
other
pageCount()
pageNumber()
pi()
power()
proper()
rand()
recid()
recno()
regexp()
repeat()
replace()
reverse()
rfind()
right()
round()
rpad()
rtrim()
second()
sign()
sin()
soundex()
str()
strpart()
substr()
sum()
tableName()
tan()
text
translate()
trim()
trunc()
upper()
val()
week()
year()
functions in formulas
- G -
go to
group breaks
group filter
group footer
group header
grouping data
- H -
help menu
highlight records
home
horizontal tiling
hotkeys
hour()
html tables
- I -
iif()
importing
importing data
include detail records
index of functions
indexes
insert calculated fields
insert group breaks
installing extensions
instr()
internet settings
introduction
invalid characters
isnull()
- J -
javascript
jobs
- K -
keyboard shortcuts
keywords, reserved
- L -
layout view
left()
length()
lfind()
license manager
licensing agreement
links
list functions
ln()
local data
local files
log()
logical expressions
lower()
lpad()
ltrim()
- M -
manage projects
mark records
max()
menu
tools
menus
data
edit
file
help
overview
view
merge tables
merge text
microsoft access
microsoft excel
microsoft foxpro
min()
minute()
mod()
month()
monthname()
move projects
multi-user
mysql
- N -
navigating the web
navigation toolbar
nested calculations
network drive
new project
new records
new table
numbers
numeric functions
- O -
odbc
opening files
options
datasheet
internet
privacy
proxy
report
script
oracle
order records
other functions
- P -
page layout
pageCount()
pageNumber()
panel
console
fields
marks
project
relationships
parent tables
pdf
pi()
power()
preferences
internet
privacy
project
report
script
print preview
printing reports
privacy settings
project manager
project panel
project preferences
project tree
projects
add existing
backing up
collaborating
compact
manage
move
new
overview
sharing
proper()
protect data
proxy settings
- Q -
queries
quick filter
quick find
quick report
quick sum
- R -
rand()
read-only
recid()
recno()
refresh
regexp()
relationship panel
remove group breaks
repeat()
replace records
replace text
replace()
replacing data
report settings
reports
add fields
add text
columns and rows
design view
footers
formatting
formulas
groups
headers
layout view
overview
page layout
pdf
printing
saving
sections
settings
sharing
template
reserved keywords
reverse()
rfind()
right()
round()
row colors
rpad()
rss
rtrim()
rules for formulas
- S -
save
save as
save as external
saving bookmarks
saving column views
saving data
saving reports
scheduling jobs
scheduling queries
scheduling scripts
scripts
search data in tables
second()
settings
internet
privacy
proxy
report
script
shared projects
sharing reports
shortcuts
sign()
sin()
software activation
sort orders
sort records
soundex()
source table
spaces in field names
split tables
sql
sql server
sql statement
sql view
stop
str()
strings
strpart()
structure
structured query language
substr()
sum()
summarize tables
summarizing data
- T -
table
add new records
append records
delete records
edit cells
new
replace records
update records
table views
tableName()
tables
calculations
copying records
divide
filter records
group breaks
group data
links
mark records
merge
order records
query
quick sum
relationships
sort records
split
summarize
tabs
tan()
template view
text files (txt)
text functions
text justification
text-delimited files
tiling
toolbar
bookmarks
format
navigation
tools menu
translate()
trim()
trunc()
tsv
tutorial video
txt
type
- U -
update records
upper()
URL bar
- V -
val()
vertical tiling
video tutorials
view menu
viewing jobs
views
design
source
table
- W -
web
navigation
overview
web browsing
web data
week()
welcome
width
working with formulas
wrap text
- Y -
year()
