var DB = new Database('DB') DB.CreateRecordset('FLIGHTS') with (DB.FLIGHTS) { CreateField('FLIGHT_ID') CreateField('DEP_DAY') CreateField('DEP_CITY') CreateField('DEP_TIME') CreateField('ARR_TIME') CreateField('ARR_CITY') CreateField('ARR_DAY') CreateField('viaPIK') } with (DB.FLIGHTS) { A([500,"6","STN","15:45","02:10","ATL","7","0"]) A([202,"3","STN","14:10","01:05","ATL","4","0"]) A([203,"3","STN","09:15","16:10","BAH","3","0"]) A([204,"1","STN","18:55","21:25","CGN","1","0"]) A([206,"6","STN","21:05","23:30","CGN","6","0"]) A([207,"7","STN","20:00","12:50","DEL","1","0"]) A([208,"4","STN","10:30","04:00","DEL","5","0"]) A([400,"1","STN","09:55","19:20","DMM","1","0"]) A([209,"1","STN","09:55","23:20","DXB","1","0"]) A([501,"4","STN","20:20","09:40","DXB","5","0"]) A([212,"6","STN","16:35","19:00","FRA","6","0"]) A([214,"6","STN","15:45","18:15","FRA","6","0"]) A([502,"7","STN","20:00","22:30","FRA","7","0"]) A([349,"4","STN","20:20","22:45","FRA","4","0"]) A([350,"3","STN","14:10","16:35","FRA","3","0"]) A([217,"5","STN","09:00","05:05","HKG","6","0"]) A([219,"1","STN","09:55","14:00","HKG","2","0"]) A([503,"6","STN","21:05","20:40","HKG","7","0"]) A([220,"7","STN","20:00","23:05","HKG","1","0"]) A([221,"4","STN","10:30","13:45","HKG","5","0"]) A([222,"3","STN","09:15","15:45","HKG","4","0"]) A([223,"6","STN","16:35","07:45","IAH","7","0"]) A([224,"4","STN","10:30","13:25","MUC","4","0"]) A([225,"3","STN","09:15","12:10","MUC","3","0"]) A([227,"6","STN","16:35","02:45","ORD","7","0"]) A([504,"1","STN","18:55","23:00","PVG","2","0"]) A([229,"4","STN","20:20","23:59","PVG","5","0"]) A([800,"6","LHR","17:10","03:10","DXB","7","0"]) A([801,"7","LHR","21:15","09:15","DXB","1","0"]) A([802,"4","LHR","21:05","17:10","ICN","5","0"]) A([803,"6","LHR","21:35","17:40","ICN","7","0"]) A([804,"3","LHR","12:00","08:45","NRT","4","0"]) A([805,"5","LHR","17:00","13:45","NRT","6","0"]) A([806,"7","LHR","09:55","10:20","NRT","1","0"]) A([807,"6","LHR","17:10","15:45","TPE","7","0"]) A([808,"7","LHR","21:15","18:00","TPE","1","0"]) A([233,"7","CGN","02:00","20:40","HKG","7","0"]) A([850,"1","CGN","23:25","23:00","PVG","2","0"]) A([235,"6","PIK","22:45","02:10","ATL","7","0"]) A([236,"3","PIK","21:40","01:05","ATL","4","0"]) A([237,"7","PIK","00:50","07:45","IAH","7","0"]) A([238,"7","PIK","00:50","02:45","ORD","7","0"]) A([239,"3","MUC","14:15","22:10","BAH","3","0"]) A([240,"4","MUC","16:00","04:00","DEL","5","0"]) A([242,"4","MUC","16:00","13:45","HKG","5","0"]) A([860,"3","MUC","14:15","15:45","HKG","4","0"]) A([580,"6","FRA","20:15","02:10","ATL","7","1"]) A([507,"3","FRA","19:05","01:05","ATL","4","1"]) A([246,"1","FRA","00:30","12:50","DEL","1","0"]) A([247,"5","FRA","00:45","09:40","DXB","5","0"]) A([379,"1","FRA","00:30","23:05","HKG","1","0"]) A([380,"6","FRA","22:20","07:45","IAH","7","1"]) A([381,"6","FRA","22:20","02:45","ORD","7","1"]) A([382,"6","FRA","20:15","21:15","PIK","6","0"]) A([508,"6","FRA","22:20","23:20","PIK","6","0"]) A([509,"3","FRA","19:05","20:05","PIK","3","0"]) A([850,"5","FRA","00:45","23:59","PVG","5","0"]) A([383,"7","ATL","04:40","12:50","DEL","1","1"]) A([384,"7","ATL","04:40","19:20","DMM","1","1"]) A([352,"4","ATL","03:40","09:40","DXB","5","1"]) A([411,"7","ATL","04:40","22:30","FRA","7","1"]) A([412,"4","ATL","03:40","22:45","FRA","4","1"]) A([510,"7","ATL","04:40","17:30","STN","7","0"]) A([413,"4","ATL","03:40","16:30","STN","4","0"]) A([258,"7","IAH","15:45","19:20","DMM","1","1"]) A([260,"7","IAH","15:45","23:20","DXB","1","1"]) A([261,"7","IAH","15:45","06:30","STN","1","0"]) A([511,"7","ORD","05:30","19:20","DMM","1","1"]) A([512,"7","ORD","05:30","23:20","DXB","1","1"]) A([415,"7","ORD","05:30","06:30","STN","1","0"]) A([262,"6","BOM","14:30","23:30","CGN","6","1"]) A([263,"4","BOM","02:00","13:25","MUC","4","1"]) A([264,"6","BOM","14:30","18:35","STN","6","0"]) A([266,"4","BOM","02:00","06:10","STN","4","0"]) A([416,"6","DEL","09:35","19:00","FRA","6","1"]) A([513,"3","DEL","07:55","16:35","FRA","3","1"]) A([271,"5","DEL","05:55","13:45","HKG","5","0"]) A([364,"1","DEL","15:35","23:05","HKG","1","0"]) A([276,"5","DEL","02:50","06:30","STN","5","0"]) A([277,"1","DEL","03:50","07:30","STN","1","0"]) A([284,"6","DEL","09:35","13:15","STN","6","0"]) A([285,"3","DEL","07:55","11:45","STN","3","0"]) A([285,"3","MAA","01:00","12:10","MUC","3","1"]) A([286,"6","MAA","05:20","18:15","FRA","6","1"]) A([700,"6","MAA","05:20","10:50","STN","6","0"]) A([701,"3","MAA","01:00","06:30","STN","3","0"]) A([276,"2","DXB","03:00","14:00","HKG","2","0"]) A([703,"4","BAH","03:01","15:45","HKG","4","0"]) A([704,"6","PVG","03:00","07:15","DEL","6","0"]) A([705,"3","PVG","01:35","05:40","DEL","3","0"]) A([706,"6","PVG","03:00","19:00","FRA","6","1"]) A([707,"3","PVG","01:35","16:35","FRA","3","1"]) A([708,"6","PVG","01:35","11:45","STN","6","0"]) A([709,"3","PVG","03:00","11:45","STN","3","0"]) A([516,"6","HKG","08:45","12:30","BOM","6","0"]) A([294,"3","HKG","20:15","23:59","BOM","3","0"]) A([296,"7","HKG","22:40","21:25","CGN","1","1"]) A([518,"7","HKG","22:40","01:55","DEL","1","0"]) A([520,"4","HKG","21:20","00:30","DEL","5","0"]) A([303,"6","HKG","08:45","23:30","CGN","6","1"]) A([305,"6","HKG","00:45","03:20","MAA","6","0"]) A([306,"2","HKG","22:20","23:00","MAA","2","0"]) A([310,"3","HKG","20:15","13:25","MUC","4","1"]) A([710,"2","HKG","20:20","12:10","MUC","3","1"]) A([711,"6","HKG","00:45","18:15","FRA","6","1"]) A([524,"6","HKG","00:45","10:50","STN","6","0"]) A([311,"6","HKG","08:45","18:35","STN","6","0"]) A([522,"7","HKG","22:40","07:30","STN","1","0"]) A([526,"4","HKG","21:20","06:30","STN","5","0"]) A([862,"2","HKG","20:20","06:30","STN","3","0"]) A([863,"3","HKG","20:15","06:10","STN","4","0"]) A([809,"4","ICN","13:20","16:40","LHR","4","0"]) A([810,"6","ICN","15:15","18:35","LHR","6","0"]) A([811,"2","NRT","22:25","06:55","LHR","3","0"]) A([812,"4","NRT","22:30","07:15","LHR","5","0"]) A([813,"6","NRT","21:30","07:15","LHR","7","0"]) A([814,"6","TPE","01:30","12:55","LHR","6","0"]) A([815,"7","TPE","03:30","18:15","LHR","7","0"]) }