Welcome to MiniDB v0.2 En by Zodiaq (zodiaq@aster.pl)
Feel free to contact me or visit my web page: http://www.zodiaq.w.pl
Last program modyfication: 6 Apr 2004
REMEMBER: you use this totally free application at your own risk! |-]
Please read readme.txt for more information (and help)

No DBs in ./ directory!

Main menu:
4. Create new DB
7. End program
Your choice? 4
Please enter file name for new DB: vhs-movies
Enter DB name: vhs movies
Enter description for DB: my vhs movie collection

Main menu:
1. Show found DBs infos
2. Choose DB
3. Delete DB
4. Create new DB
7. End program
Your choice? 2

1. File name: vhs-movies.dbq, Name: vhs movies (empty)
Choose (1 to 1,0 to abort): 1

Main menu:
1. Show found DBs infos
2. Choose DB
3. Delete DB
4. Create new DB
5. Edit selected DB
6. View selected DB
7. End program
Your choice? 4
Please enter file name for new DB:

Main menu:
1. Show found DBs infos
2. Choose DB
3. Delete DB
4. Create new DB
5. Edit selected DB
6. View selected DB
7. End program
Your choice? 5

What do you want to edit?
1. Change columns
3. Change name and/or description
0. Return
Your choice? 1

Current columns configuration:
No columns!

Options:
1. Add new column at the beginning
0. Return
Your choice? 1

Choose new column type:
0. Abort
1. Text
2. Integer
3. Real
4. Date/Time
5. File size (dynamic)
6. Boolean
1
Enter column label: Movie title
Updating column configuration...New column pos: 1
done!
done!

What do you want to edit?
1. Change columns
2. Edit row values
3. Change name and/or description
0. Return
Your choice? 1

Current columns configuration:
Columns: 1
Configured columns:
Column nr: 1 Name: Movie title Type: Text

Options:
1. Add new column at the beginning
2. Add new column at the end
3. Insert new column before...
4. Remove column
5. Change column name
0. Return
Your choice? 2

Choose new column type:
0. Abort
1. Text
2. Integer
3. Real
4. Date/Time
5. File size (dynamic)
6. Boolean
1
Enter column label: Main cast
Updating column configuration...New column pos: 2
done!
done!

What do you want to edit?
1. Change columns
2. Edit row values
3. Change name and/or description
0. Return
Your choice? 1

Current columns configuration:
Columns: 2
Configured columns:
Column nr: 1 Name: Movie title Type: Text
Column nr: 2 Name: Main cast Type: Text

Options:
1. Add new column at the beginning
2. Add new column at the end
3. Insert new column before...
4. Remove column
5. Change column name
0. Return
Your choice? 2

Choose new column type:
0. Abort
1. Text
2. Integer
3. Real
4. Date/Time
5. File size (dynamic)
6. Boolean
4
Enter column label: Record date
Updating column configuration...Do you want see information about creating date column? [Y/N] y
When entering use these letter for special use (case doesn't matter):
y - year, m - month, d - day, h - hour, n - minute, s - second
You don't have to use all special letters - but not more than one of each!
Remember that entered here order will be used later when entering new values!
ANY letter different than special letter will be copied and threated as spacer.
IMPORTANT: between EACH used special letter MUST be some kind of spacer - even space will do fin
Enter syntax for new date/column column: y-m-d
Analyzing syntax from: [y-m-d]
Syntax processed, here are obtained informations:Here are set values in syntax:
Year  : Yes
Month : Yes
Day   : Yes
Hour  : No
Minute: No
Second: No
Current syntax:
YEAR<->MONTH<->DAY
New column pos: 3
done!
done!

What do you want to edit?
1. Change columns
2. Edit row values
3. Change name and/or description
0. Return
Your choice? 2

Changing data options:
1. Add new row at the end
0. Return
What is your choice? 1

   Enter value(s) for new row:
Movie title (of Text): apocalypse now
Main cast (of Text): Marlon Brando, Rober Duval, Martin Sheen, Frederic Forrest
Record date (of Date/Time syntax: Y-M-D): 2003-10-7
New row position: 1

Changing data options:
1. Add new row at the end
2. Add new row at the begining
4. Change row values
5. Remove row
0. Return
What is your choice? 1

   Enter value(s) for new row:
Movie title (of Text): jurassic park 3
Main cast (of Text): Sam Neill, William H, Macy, Tea Leoni, Trevor Morgan
Record date (of Date/Time syntax: Y-M-D): 2002-8-13
New row position: 2

Changing data options:
1. Add new row at the end
2. Add new row at the begining
3. Insert new row before...
4. Change row values
5. Remove row
0. Return
What is your choice? 1

   Enter value(s) for new row:
Movie title (of Text): gods and generals
Main cast (of Text): Jeff Daniels, Mark Alrich, Stephen Lang, George Allen, Rober Duval
Record date (of Date/Time syntax: Y-M-D): 2004-2-1
New row position: 3

Changing data options:
1. Add new row at the end
2. Add new row at the begining
3. Insert new row before...
4. Change row values
5. Remove row
0. Return
What is your choice? 0

What do you want to edit?
1. Change columns
2. Edit row values
3. Change name and/or description
0. Return
Your choice? 0

Main menu:
1. Show found DBs infos
2. Choose DB
3. Delete DB
4. Create new DB
5. Edit selected DB
6. View selected DB
7. End program
Your choice? 6

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 1
Current columns configuration:

Number of columns: 3
1. Name: Movie title Type: Text
2. Name: Main cast Type: Text
3. Name: Record date Type: Date/Time syntax: Y-M-D

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 3

Enter field nr to show (1-3): 1
Movie title: apocalypse now
Main cast: Marlon Brando, Rober Duval, Martin Sheen, Frederic Forrest
Record date: 2003-10-7

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 4

HINT: for text values enter any text to search, for numbers enter minimal and maximal value (inc
ve) or enter both values the same (to disable searching range)
To disable searching on column just hit enter
Movie title:
Main cast: Duval
Record date (syntax: Y-M-D):

Searching...done!
Found 2 matching rows!

What do you want to do with results?
1. Show on screen
2. Export
0. Return (discard)
Your choice? 1

Row nr: 1
Movie title: apocalypse now
Main cast: Marlon Brando, Rober Duval, Martin Sheen, Frederic Forrest
Record date: 2003-10-7

Row nr: 3
Movie title: gods and generals
Main cast: Jeff Daniels, Mark Alrich, Stephen Lang, George Allen, Rober Duval
Record date: 2004-2-1

What do you want to do with results?
1. Show on screen
2. Export
0. Return (discard)
Your choice? 0

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 3

Enter field nr to show (1-3): 2
Movie title: jurassic park 3
Main cast: Sam Neill, William H, Macy, Tea Leoni, Trevor Morgan
Record date: 2002-8-13

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 4

HINT: for text values enter any text to search, for numbers enter minimal and maximal value (inc
ve) or enter both values the same (to disable searching range)
To disable searching on column just hit enter
Movie title:
Main cast: Duval Leoni
Record date (syntax: Y-M-D):

Searching...done!
Found 3 matching rows!

What do you want to do with results?
1. Show on screen
2. Export
0. Return (discard)
Your choice? 2

Choose destination file type:
1. Web page (.html)
2. Text file (.txt)
0. Return
Your choice? 2
Opening file vhs-movies.dbq.txt to export data...success!
Exporting...finished!

Choose destination file type:
1. Web page (.html)
2. Text file (.txt)
0. Return
Your choice? 0

What do you want to do with results?
1. Show on screen
2. Export
0. Return (discard)
Your choice? 0

View options:
1. Show columns configuration
2. Show statistics
3. Show field at...
4. Search for...
5. Export data
0. Return
Your choice? 0

Main menu:
1. Show found DBs infos
2. Choose DB
3. Delete DB
4. Create new DB
5. Edit selected DB
6. View selected DB
7. End program
Your choice? 7

Saving updated data and releasing memory...
Updating file and releasing memory for vhs movies (file: vhs-movies.dbq)...done!
All files done!