V 1.20

Code Generator

Generate RB Maint Code
DataBase
Table Name
Auto Seq Field

Database	Enter complete directory and database name
Tabe	A table within the database.
Drop Down or Radio	This will create Drop Down or Radio input fields. 1. Click the [Drop Down] button 2. Select a field you want a drop down on 3. Select a table to get the drop down information from 4. Click the [Accept] button. This will bring up the field to compare and what you want to display. 5. Select something to 'Compare' to 6. Select something to 'Display' in the drop down 7, Click [Make Drop]. This will show you the data that will make the drop down. You can [Delete] any drop downs you created. 8. Click [Gen Code]. This will create your program.
Auto Sequence field	Optional field. This is a control field for the table. When adding a new record the system will automatically assign a unique sequence number to it. For example if the table is customer, and the control field for customer is custNum. Then you can have the system assign a new custNum when you create a new Customer.

1. Enter the name and location of the database.
In this case it's c:\rbp101\projects\calendar_project\data\cal.db

2. Enter the schTime table to generate code for

3. Since we have a auto sequence number called schNum, we enter that.

Since we want Drop Downs for assets and users, click the [Drop Down] button.
The following screen will pop up.

schTime.field	=	Table.
schNum userNum assetNum schBeg schEnd		asset user

Since we want a drop down for asset, select assetNum in the first column, and look for the value of assetNum in the asset Table in the second column. Then click the [Accept Drop] button. Another Pop Up screen will appear as follows

Compare	=	Display
assetNum assetType short descr		assetNum assetType short descr

Here we need to know what to Compare to in the asset table, and what to Display in the Drop Down.
We want to compare to the asset number (assetNum), and display the description (descr)
Now click the [Make Drop] button to make the drop down. The following will appear:

1. Drop schTime.assetNum = asset.assetNum Display asset.descr

This lets you know you are creating a Drop down by comparing schTime.assetNum = asset.assetNum and Displaying asset.descr in the drop down.

Now do a similar thing for the user Drop Down

You could just as easily made the Drop Down into a Radio button by clicking the [Radio] button instead of the [Drop Down] button.

back to top

---

Code Generation

To generate the code click [Gen Code]. It will tell you where it placed the code;

Output File: c:\rbp101\public\schTime.bas

Cut the output area from the screen and place it wherever you want. Usually you bring it into an editor.

---

back to top

Running the Generated program code

Anyway the code is ready to run.

Since it has no idea how you want to secure your Login the username and password are the same as the table you generated the code. In this case it's user:schTime and pass:schTime.
You can change it in the program: (should be around line 6)
keyUser$ = "schTime"
keyPass$ = "schTime"

Running the Generated code you should see the following screen.

Records:8

Pages:1

SchNum UserNum SchBeg SchEnd AssetNum Event Name Descr

SchNum

Maint	SchNum	UserNum	SchBeg	SchEnd	AssetNum	Event	Name	Descr
View	1	1	2009-10-01 01:00	2009-10-01 02:00	0	vac	Vacation	I'm outta here
View	2	1	2009-10-01 04:00	2009-10-01 05:00	6	met	Auditor	Here come the auditors
View	3	2	2009-04-01 08:30	2009-04-01 09:30	1	met	Sch Financial	Meeting with Financial
View	4	1	2009-10-01 10:30	2009-10-01 10:45	0	sic	sick	I plan on being sick
View	5	1	2009-10-01 06:00	2009-10-01 07:00	0	vac	Mexico	I will be on the beach.
View	6	1	2009-09-29 08:00	2009-09-29 09:15	1	met	Production	Production meeting
View	7	1	2009-12-26 20:25	2009-12-31 20:16	0	oth	Moving	Vacation
View	8	2	2009-04-01 05:44	2009-04-01 06:44	0	met	my meeting	whatever

Notice there is no way to maintain the data, such as Add, Change, or Delete.
However if you click [Login] and enter schTime/schTime, you will be granted maintenance privileges.

Header:

[Login] - Login into the system to get maintenance privileges.
[Export] - Will create a CSV flat file for spewd sheets.
[Help] - The system generates some very basic help . It is up to you to change it.
[Exit] - Will leave the system and return to your web page. If you do not want it to leave the system, the modify or delete this.
Records: - Lets you know how many records match the search. If there is no search then it is the total records
Pages: - How many pages there are. This is based on the number of Lines per page and the number of records
[Prev] - Go to the previous page
Page number.. You can go directly to a page by changing this and clicking on [Next]
[Next] - Go to the next page
[Lpp] - The default lines per page is 25. You can change that and click [Lpp]

back to top

The second line:

Sorting
Sort drop down is for the sort method. In this case it's in SchNum sequence.
You can select another sort from the drop down and click [Sort]. For more refined sorts, or additions or deletions look at the comments in the generated code

back to top

Searching

If you click [Search] it will present a list of all the fields. You can select one or many fields to drill down on. You can use wild cards, or compares such as =.<> > < etc.

The table List.
The first column is the Maint.
[View] - lets you view the detail.
If you logged in and get privileges it will also show:
[Chg] - to change a record
[Del] - to Delete a record.

back to top

Maintenance.

When you click [Add], [Chg], or [Del] this screen will appear.

schTime Maintenance
SchNum	1	UserNum	1 Data 2 BackBone 1 Data 3 System *None*	SchBeg
SchEnd		AssetNum	*None* 1 Conference Room A 2 Conference Room B 6 Meeting Room 1 5 Meeting Room 2 7 Movie Room 3 Recreation Room 1 4 Recreation Room 2 *None*	Event
Name		Descr

Notice the Drop Downs for the UserNum and the AssetNum.

PopUps

All date fields have a [D] and a [T] button. If you click [D] a date picker pop up window ill appear. It will display the year and month you have in the field. If nothing is in the field, it displays the current month.

Oct 2009
Sun	Mon	Tue	Wed	Thr	Fri	Sat

If you click the [T] filed a time picker pop up window will appear.

Hr	Min	Sec
05 0 1 2 3 21 22 23	00 0 1 2 3 4 5 14 15 16 17 34 35 46 47	18 0 1 2 3 4 5 6 7 8

All time fields will have the [T] button..

back to top