I have a table in a MySql database containing the following fields (among others);
Tour_ID (int,6)
Tour_Date (date)
Tour_Time (char,5)
Passengers (int,4)
Rest_Time (char,5) Note: Restaurant time is usually an hour before or after Tour_Time
Rest_Persons (int,3)
There may be several Tour_ID's for each Date and Time
The objective is to show a pop-up window (containing either a R/O grid or list) showing Tour_Time, Passengers, Rest_Persons for a particular day
This is an upgrade of a program written in Xbase++. In it I create a temporary file with the fields Tour_Time, Passengers, and Rest_Persons where Time is shown as 10:00, 11:00, 12:00, etc. and then show it in a pop-up window.
The question is how do I do this in Alpha5.
A Select statement doesn't look like it will work because the Rest_Time is not the same as the Tour_Time.
I tried creating an XBasic function which creates a temporary file with the appropriate data (summing the passengers and Rest_Persons for each time etc.) but I couldn't figure out how to display it.
I'm sure that Alpha5 is capable of this but the route to do it is a mystery to me.
I hope that the explanation of what I am trying to do is clear enough for someone to offer assistance.
I tried attaching an image (Capacity,png) to this message but it just wiped out my entire message and I had to start over.
Garry
Tour_ID (int,6)
Tour_Date (date)
Tour_Time (char,5)
Passengers (int,4)
Rest_Time (char,5) Note: Restaurant time is usually an hour before or after Tour_Time
Rest_Persons (int,3)
There may be several Tour_ID's for each Date and Time
The objective is to show a pop-up window (containing either a R/O grid or list) showing Tour_Time, Passengers, Rest_Persons for a particular day
This is an upgrade of a program written in Xbase++. In it I create a temporary file with the fields Tour_Time, Passengers, and Rest_Persons where Time is shown as 10:00, 11:00, 12:00, etc. and then show it in a pop-up window.
The question is how do I do this in Alpha5.
A Select statement doesn't look like it will work because the Rest_Time is not the same as the Tour_Time.
I tried creating an XBasic function which creates a temporary file with the appropriate data (summing the passengers and Rest_Persons for each time etc.) but I couldn't figure out how to display it.
I'm sure that Alpha5 is capable of this but the route to do it is a mystery to me.
I hope that the explanation of what I am trying to do is clear enough for someone to offer assistance.
I tried attaching an image (Capacity,png) to this message but it just wiped out my entire message and I had to start over.
Garry
Comment