Passenger Seating Dbase

[Peter.Greulich]

Re: Passenger Seating Dbase

Thanks Peter, the sample you provided works excellent. The next stumbling block I have come across is that when I close the form then re-open it, the seats are no longer colored. I have to adjust the record, to reforce it to save, and re-color again.

You may be missing the point. I just provided you a sample to get you started. In order for the seats to properly display on form load, you need to script a loop thru the relevant records in the table and "re-color" the seats before viewing. Use the OnInit event. Here is some simplified generic code to query and loop thru the records. You have to study the code and apply what I gave you previously to make it all work. Of course, I could build the whole thing for you, but then you'd have to pay me. ;)

tbl = table.open()
''========================QUERY
query.description = ""
query.order = ""        
query.filter = ""
query.options = ""    
Q = tbl.query_create()
''************************No of records
nrecs = Q.records_get()
IF nrecs = 0
    Q.drop()
    tbl.close()
    ui_msg_box("Null Query","No records were found matching the criteria.",UI_INFORMATION_SYMBOL)
    END
END IF
''========================FETCH 
i = 1
tbl.fetch_first()
while .not. tbl.fetch_eof()
        ''code here
    statusbar.percent(i,nrecs)
    i = i + 1
tbl.fetch_next()
end while
tbl.close()
END

[Peter.Greulich]

Re: Passenger Seating Dbase

Are you suggesting that Nathan has over 400 little spots (for a 747) on a form and each spot changes colour when it gets booked?

Well, I didn't think about the number! 400 - yikes! I guess you would make the objects very small to fit them all on the form/screen view. But there might be a performance issue w. that many objects. One would have to test it to see how fast 400 objects update.

So Nathan could have several Seating layouts on conditional layers for each plane layout, 737, 747 etc.

You could use cond objects, although, in this case, I would probably minimize the number of objects and "re-use" objects (if feasible) by code.

Sure is going to take some coding! But doable.

I don't think the coding is too bad, actually. The secret is to name the objects logically and address them by xbasic - e.g. S001, S002, S003, or some such system. You certainly don't need a line of code to address each each object individually!

[Peter.Greulich]

Re: Passenger Seating Dbase

See what you all think of the approach in the attached.

You can do all kinds of cool tricks like that. But, the one thing I totally disagree with is putting all the fields for each seat of one flight in one record - 400 fields+ (using your sample idea would require 1200+ fields in a single record ~ what's the limit of fields per record?). I would humbly suggest a closer adherence to db normalization rules and use one record per seat. Like Keith said, it can be a child table or whatever.

[Raymond Lyons]

Re: Passenger Seating Dbase

You can do all kinds of cool tricks like that. But, the one thing I totally disagree with is putting all the fields for each seat of one flight in one record - 400 fields+ (using your sample idea would require 1200+ fields in a single record ~ what's the limit of fields per record?). I would humbly suggest a closer adherence to db normalization rules and use one record per seat. Like Keith said, it can be a child table or whatever.

I was mainly interested in some form what one could do with the "cool tricks" on a form. Clearly if you have up to 400 seats not everything can be in one table (the limit is around 1000 fields, plus God forbid anyone break normalization rules). As for one record per seat, I humbly await any genuinely cool tricks with that scenario--or maybe I missed them in your sample. Seems like it would have to be something like a calendar/appointments model. But unlike you ("Of course, I could build the whole thing for you, but then you'd have to pay me"), I'm not looking for business, so I'll leave it to you and whoever else wants to play around with it.

Raymond Lyons

[Mike Wilson]

Re: Passenger Seating Dbase

That was pretty much fun. I think this example goes along the lines that Peter was describing. I think. It makes for a platform for folks to play with, at least. This really is a RAD product.

In this example, the progressive lookup for the airport codes displays a dialog box which has the OK button highlighted, but requires a mouse press, as the Enter key will not activate it. It was created throught the Genie and converted to xdialog for color changes. I can't figure how to get the dialog buttons to operate with keystrokes.

[Raymond Lyons]

Re: Passenger Seating Dbase

Mike,

A great start! However, unless I bypass opening the mainmenu form, any action on that form seems to crash A5. Maybe it is just the Navigate button--not sure.

Ray

[nathanashton]

Re: Passenger Seating Dbase

Hi Mike,

Wow! thats about all I can say. You've pretty much nailed the functionality that I was aiming for. A little bit of customisation etc and this would be pretty much perfect. Very grateful for your help. Now I need to dig through the code and see how it all works........

[Bob Arbuthnot]

Re: Passenger Seating Dbase

Very impressive, Mike. Nice work!

ba

[Keith Hubert]

Re: Passenger Seating Dbase

Mike,

That is amazing, I take my hat off to you sir.

Thank you for including me on your flight.

My idea to have conditional layers was to allow for the different areas of the plane.
Which would allow for the number of seats in a 747.

Just for added functionally, available seat numbers could be on a lookup with a W or A as in this planes seating arrangement

How cool would the drag and drop be, in this application?
Upgrading might be a problem with conditional layers and drag and drop?

When you can produce an application like this, even as a sample, then you can call yourself an Alpha Developer

[Peter.Greulich]

Re: Passenger Seating Dbase

That's sick, Mike! But you'll be happy to know I just used your program to book a flight to Taipei! BTW: I charged it to your credit card. ;)

Very Impressive.

[Raymond Lyons]

Re: Passenger Seating Dbase

Mike,

I don't get it. Am I the only for which your Navigator function crashes A5 completely? I downloaded the zip again, no help. I am on XP, sp3 and the v9 patch just released a day or two ago. What's going on?

Ray

[Bob Arbuthnot]

Re: Passenger Seating Dbase

Ray,

I opened it with V8 and it worked fine.

Bob Arbuthnot

[Raymond Lyons]

Re: Passenger Seating Dbase

I just tried it in V8. Same thing--big time crash (Ctrl+ Alt+Del type). Oh well, I am not going to be flying anytime soon!!

Ray

[gmeredith17]

Re: Passenger Seating Dbase

Ray - Worked fine for me in V8. Might be worth downloading it again in case any of the files were corrupted.

Mike - Thank you for providing this sample. Its a great help for novices like myself.

[Raymond Lyons]

Re: Passenger Seating Dbase

I did download it again. Same problem with both V8 and V9.