Locating an undefined variable / defining OLE variable

[jlockley]

I've struggled on and off with ObjectPal for a number of years, and I am not really good at it, (bad memory and not enought time to really get involved). I'm at it again, trying to put together a script to permit me to access and program a query from a user interface. Using a script and method from the db community (which seems to have changed? Not be accessible?) I've got the structure below.
I have two questions:

Somewhere in a lot of fields I've made a mistake resulting from an undefined variable. (Due to my poor practices in naming the fields in the table, I had to correct many and now will have to go back and correct the table - I imaging that there's a typo in the list). The syntax checks and the data model is set to the correct DB.

At any rate, with about 200 fields I am having a hard time indentifying the error. I've gone through everything twice, but proof reading is not a strength.

Is there a way to identify the discrepency via Paradox rather than going through the data a piece at a time?


any help will be appreciated
A truncated version of the program is below.

method pushButton(var eventInfo Event)
var
StNAME String
stLOCATION String
stTITLE String
stPARTNER String
stDATE String
stTelephone String
stFax String

;...sample of about 200 fields

Endvar
;============================== Parameters

if StNAME.isBlank() then
StNAME = "Check"
else
StNAME = "Check, " + StNAME
endif
;.................
if stLOCATION.isBlank() then
stLOCATION = "Check"
else
stLOCATION = "Check, " + stLOCATION
endif
;.................
if stTITLE.isBlank() then
stTITLE = "Check"
else
stTITLE = "Check, " + stTITLE
endif
;.................
if stPARTNER.isBlank() then
stPARTNER = "Check"
else
stPARTNER = "Check, " + stPARTNER
endif
;.................
if stDATE.isBlank() then
stDATE = "Check"
else
stDATE = "Check, " + stDATE
endif
;.................
if stTelephone.isBlank() then
stTelephone = "Check"
else
stTelephone = "Check, " + stTelephone
endif
;.................
if stFax.isBlank() then
stFax = "Check"
else
stFax = "Check, " + stFax
endif

;.......etc end parameters

:........Query


quQuery = QUERY


ANSWER: : C:\Roladex\results.DB


newrol.DB | NAME | LOCATION | TITLE | PARTNER | DATE | Telephone |
| Check | Check | Check | Check | Check | Check |

newrol.DB | Fax |
| Check |
;......sample of about two hundred fields

ENDQUERY

quQuery = QUERY



errorTrapOnWarnings(Yes)
quQuery.writeQBE(":Work:Query.QBE")
try
quQuery.executeQBE()
tvResults.open(":Work:OrderInfo1.DB")
tvResults.wait()
tvResults.close()
onFail
errorShow()
msgStop("", "")
endTry
errorTrapOnWarnings(No)

endMethod



| Check |

 

[jlockley]

Sorry. Wrong copy. Here is the correct one. The Variable is defined but the the first statement after endvar, "stNAME = fldNAME'value" yields -> "Error: unknown identifier". Clues again appreciated.

BTW, this is based on Mike Irwin's model on the DBCommunity

Note: There is a field in the form with the name fldNAME


method pushButton(var eventInfo Event)

var
stNAME String
stlocation String
stTITLE String
stPARTNER String
stENTRY_DATE String
stTelephone String
stFax String
stWphone String
stCell_pgr String
ste_mail String
stweb_site String
stAddress String
stCity String
stState String
stZip String
stCountry String
stInformation String
stPreferred_Location String
stSalary String
stLocation_Type String
stRating_backg String
stRating_Prof String
stRating_stab String
stRating_food String
stRating_org_sys String
stRating_vol String
stRating_attitude String
stRestaurant String
stREST_S String
stWinery String
stR_VOL String
stR_STAR String
stR_CORP String
stCLUB String
stCL_TOP String
stHOT String
stTop_Hotel String
stConvention_Ctr String
stCasino String
stInn_Bed_Breakfast String
stMaritime String
stHOT_UNIT String
stLuxury_Resort String
stRd String
stCOMM String
stCTG String
stFS String
stDELI_HRM String
stFamily String
stChain String
stQuick_Serve String
stRetail String
stBAKERY_RTL String
stBakery_Comm String
stBKRY_WHLS String
stDOM String
stSchool String
stQUAL String
stSEAT_NR String
stBNKT_NR String
stVOL_Annual String
stVol_Covers String
stVery_interesting String
stTRAIN String
stSPECIAL_SKILLS String
stFrench_Haute String
stFrench_Bistro String
stContinental String
stAmerican_Club String
stAmerican_Market String
stItalian String
stSpanish String
stMexican String
stOther_Hispanic String
stHaute_Complex String
stHaute String
stMediterran String
stChinese String
stJapanese String
stChop_House String
stIndian String
stOther_Asian String
stOther_Exotic String
stIsland_Carribean String
stAmerican_Comfort String
stSteakhouse String
stSeafood String
stOther_Product String
stLight String
stPub String
stbiodynamic_healing_etc String
stCalif_Style String
stVegetarian String
stAmerican_Bistro String
stMarket_Driven String
stBar_B_Que String
stGarde String
stIce String
stShow_Pieces String
stCharcuterie String
stButcher String
stOther_Skill String
stSugar String
stChocolate String
stCake_deco String
stVienoiserie String
stFine_Desserts String
stCalifornia_Style String
stCajun String
stOther_American_regional String
stBuffet String
stBanquet String
stPastry String
stDesserts String
stBread String
stHigh_Profile String
stVolume_Production String
stFood_Chemistry String
stNutrition String
stTrainer String
stHaccp String
stInstructor String
stComputer String
stMulti_Unit String
stOpening_Planning String
stCEC String
stSrve_Safe String
stSpeak_Span String
stPress_Portfolio String
stAwards String
stCorpChef String
stExecChef String
stWCh String
stExSch String
stSch String
stChef_and_Manager String
stGarde_Manger String
stTournant String
stChdC String
stKM String
stPstryCh String
stPstryAsst String
stBaker String
stDir_Bkry_Prod String
stBnktCh String
stBnktAsst String
stLnCk String
stDFB String
stDir_Ops_CEO String
stDir_Prod String
stRegional_Manager String
stCorpGM String
stGeneral_Manager String
stDining_Room_Maitre_D String
stManager String
stDirector_of_Food_Service String
stAsst_Manager String
stAGM String
stDir_Ctg String
stCatMgr String
stBnktmgr String
stRetail_management String
stOther_management String
stWine String
stResume String
stResumememo String
stNotes String
stQuality_Of_Life String
stMove_from_SF_or_CA String
stNon_Urban String
stPrint__Sample_Menu_or_pic String
stReference_Letter String
stReferences String
stSample_Sample_Menu String
stSource String
stConsider String
stDo String
stPicture String
stFoodpics String
stPic1 String
stPic2 String
stPic3 String
stPic4 String
stPic5 String
stPic6 String
stPic7 String
stPic8 String
stPic9 String
stPic10 String
stPhoto String
stReview String
stRank String
stNo String
stCategories String
stNorth_East String
stSoutheast String
stSouth String
stMidwest String
stSouthwest String
stMountain_States String
stNorthwest String
stNo_preference String
stInternattional String
stAsia String
stMiddle_East String
stEurope String
stWest_Coast String
streferrals String
stContact String
stConsider_For String
quQuery Query
tvResults tableView
endvar
stNAME = fldNAME'value
stLOCATION = fldlocation'value
stTITLE = fldtitle'value
stPARTNER = fldPARTNER'value
stENTRY_DATE = fldentry_Date'value
stTelephone = fldtelephone'value
stFax = fldfax'value
stWphone = fldwphone'value
stCell_pgr = fldcell_Pgr'value
ste_mail = flde_Mail'value
stweb_site = fldweb_Site'value
stAddress = fldaddress'value
stCity = fldcity'value
stState = fldstate'value
stZip = fldzip'value
stCountry = fldcountry'value
stInformation = fldinformation'value
stPreferred_Location = fldpreferred_Location'value
stSalary = fldsalary'value
stLocation_Type = fldlocation_Type'value
stRating_backg = fldrating_Backg'value
stRating_Prof = fldrating_Prof'value
stRating_stab = fldrating_Stab'value
stRating_food = fldrating_Food'value
stRating_org_sys = fldrating_Org_Sys'value
stRating_vol = fldrating_Vol'value
stRating_attitude = fldrating_Attitude'value
stRestaurant = fldrestaurant'value
stREST_S = fldrest_S'value
stWinery = fldwinery'value
stR_VOL = fldr_Vol'value
stR_STAR = fldr_Star'value
stR_CORP = fldr_Corp'value
stCLUB = fldclub'value
stCL_TOP = fldcl_Top'value
stHOT = fldhot'value
stTop_Hotel = fldtop_Hotel'value
stConvention_Ctr = fldconvention_Ctr'value
stCasino = fldcasino'value
stInn_Bed_Breakfast = fldinn_Bed_Breakfast'value
stMaritime = fldmaritime'value
stHOT_UNIT = fldhot_Unit'value
stLuxury_Resort = fldluxury_Resort'value
stRd = fldrd'value
stCOMM = fldcomm'value
stCTG = fldctg'value
stFS = fldfs'value
stDELI_HRM = flddeli_Hrm'value
stFamily = fldfamily'value
stChain = fldchain'value
stQuick_Serve = fldquick_Serve'value
stRetail = fldretail'value
stBAKERY_RTL = fldbakery_Rtl'value
stBakery_Comm = fldbakery_Comm'value
stBKRY_WHLS = fldbkry_Whls'value
stDOM = flddom'value
stSchool = fldschool'value
stQUAL = fldqual'value
stSEAT_NR = fldseat_Nr'value
stBNKT_NR = fldbnkt_Nr'value
stVOL_Annual = fldvol_Annual'value
stVol_Covers = fldvol_Covers'value
stVery_interesting = fldvery_Interesting'value
stTRAIN = fldtrain'value
stSPECIAL_SKILLS = fldspecial_Skills'value
stFrench_Haute = fldfrench_Haute'value
stFrench_Bistro = fldfrench_Bistro'value
stContinental = fldcontinental'value
stAmerican_Club = fldamerican_Club'value
stAmerican_Market = fldamerican_Market'value
stItalian = flditalian'value
stSpanish = fldspanish'value
stMexican = fldmexican'value
stOther_Hispanic = fldother_Hispanic'value
stHaute_Complex = fldhaute_Complex'value
stHaute = fldhaute'value
stMediterran = fldmediterran'value
stChinese = fldchinese'value
stJapanese = fldjapanese'value
stChop_House = fldchop_House'value
stIndian = fldindian'value
stOther_Asian = fldother_Asian'value
stOther_Exotic = fldother_Exotic'value
stIsland_Carribean = fldisland_Carribean'value
stAmerican_Comfort = fldamerican_Comfort'value
stSteakhouse = fldsteakhouse'value
stSeafood = fldseafood'value
stOther_Product = fldother_Product'value
stLight = fldlight'value
stPub = fldpub'value
stbiodynamic_healing_etc = fldbiodynamic_Healing_Etc'value
stCalif_Style = fldcalif_Style'value
stVegetarian = fldvegetarian'value
stAmerican_Bistro = fldamerican_Bistro'value
stMarket_Driven = fldmarket_Driven'value
stBar_B_Que = fldbar_B_Que'value
stGarde = fldgarde'value
stIce = fldice'value
stShow_Pieces = fldshow_Pieces'value
stCharcuterie = fldcharcuterie'value
stButcher = fldbutcher'value
stOther_Skill = fldother_Skill'value
stSugar = fldsugar'value
stChocolate = fldchocolate'value
stCake_deco = fldcake_Deco'value
stVienoiserie = fldvienoiserie'value
stFine_Desserts = fldfine_Desserts'value
stCalifornia_Style = fldcalifornia_Style'value
stCajun = fldcajun'value
stOther_American_regional = fldother_American_Regional'value
stBuffet = fldbuffet'value
stBanquet = fldbanquet'value
stPastry = fldpastry'value
stDesserts = flddesserts'value
stBread = fldbread'value
stHigh_Profile = fldhigh_Profile'value
stVolume_Production = fldvolume_Production'value
stFood_Chemistry = fldfood_Chemistry'value
stNutrition = fldnutrition'value
stTrainer = fldtrainer'value
stHaccp = fldhaccp'value
stInstructor = fldinstructor'value
stComputer = fldcomputer'value
stMulti_Unit = fldmulti_Unit'value
stOpening_Planning = fldopening_Planning'value
stCEC = fldcec'value
stSrve_Safe = fldsrve_Safe'value
stSpeak_Span = fldspeak_Span'value
stPress_Portfolio = fldpress_Portfolio'value
stAwards = fldAwards'value
stCorpChe= fldcorpcheff'value
stExecChef = fldExecchef'value
stWCh = fldwch'value
stExSch = fldexsch'value
stSch = fldsch'value
stChef_and_Manager = fldchef_And_Manager'value
stGarde_Manger = fldgarde_Manger'value
stTournant = fldtournant'value
stChdC = fldchdc'value
stKM = fldkm'value
stPstryCh = fldpstrych'value
stPstryAsst = fldpstryasst'value
stBaker = fldbaker'value
stDir_Bkry_Prod = flddir_Bkry_Prod'value
stBnktCh = fldbnktch'value
stBnktAsst = fldbnktasst'value
stLnCk = fldlnck'value
stDFB = flddfb'value
stDir_Ops_CEO = flddir_Ops_Ceo'value
stDir_Prod = flddir_Prod'value
stRegional_Manager = fldregional_Manager'value
stCorpGM = fldcorpgm'value
stGeneral_Manager = fldgeneral_Manager'value
stDining_Room_Maitre_D = flddining_Room_Maitre_D'value
stManager = fldmanager'value
stDirector_of_Food_Service = flddirector_Of_Food_Servicevice'value
stAsst_Manager = fldasst_Manager'value
stAGM = fldagm'value
stDir_Ctg = flddir_Ctg'value
stCatMgr = fldcatmgr'value
stBnktmgr = fldbnktmgr'value
stRetail_management = fldretail_Management'value
stOther_management = fldother_Management'value
stWine = fldwine'value
stResume = fldresume'value
stResumememo = fldresumememo'value
stNotes = fldnotes'value
stQuality_Of_Life = fldquality_Of_Life'value
stMove_from_SF_or_CA = fldmove_From_Sf_Or_Ca'value
stNon_Urban = fldnon_Urban'value
stPrint__Sample_Menu_or_picc = fldprint__Sample_Menu_Or_Picc'value
stReference_Letter = fldreference_Letter'value
stReferences = fldreferences'value
stSample_Sample_Menu = fldsample_Sample_Menu'value
stSource = fldsource'value
stConsider = fldconsider'value
stDo = flddo'value
stPicture = fldpicture'value
stFoodpics = fldfoodpics'value
stPic1 = fldpic1'value
stPic2 = fldpic2'value
stPic3 = fldpic3'value
stPic4 = fldpic4'value
stPic5 = fldpic5'value
stPic6 = fldpic6'value
stPic7 = fldpic7'value
stPic8 = fldpic8'value
stPic9 = fldpic9'value
stPic10 = fldpic10'value
stPhoto = fldphoto'value
stReview = fldreview'value
stRank = fldrank'value
stNo = fldno'value
stCategories = fldcategories'value
stNorth_East = fldnorth_East'value
stSoutheast = fldsoutheast'value
stSouth = fldSouth'value
stMidwest = fldmidwest'value
stSouthwest = fldsouthwest'value
stMountain_States = fldmountain_States'value
stNorthwest = fldnorthwest'value
stNo_preference = fldno_Preference'value
stInternattional = fldinternattional'value
stAsia = fldasia'value
stMiddle_East = fldmiddle_East'value
stEurope = fldeurope'value
stWest_Coast = fldwest_Coast'value
streferrals = fldreferrals'value
stContact = fldcontact'value
stConsider_For = fldconsider_For'value


;============================== Parameters

if StNAME.isBlank() then
StNAME = "Check"
else
StNAME = "Check " + StNAME
endif
;.................
if stLOCATION.isBlank() then
stLOCATION = "Check"
else
stLOCATION = "Check " + stLOCATION
endif
;.................
if stTITLE.isBlank() then
stTITLE = "Check"
else
stTITLE = "Check " + stTITLE
endif
;.................
if stPARTNER.isBlank() then
stPARTNER = "Check"
else
stPARTNER = "Check " + stPARTNER
endif
;.................
if stENTRY_DATE.isBlank() then
stENTRY_DATE = "Check"
else
stENTRY_DATE = "Check " + stENTRY_DATE
endif
;.................
if stTelephone.isBlank() then
stTelephone = "Check"
else
stTelephone = "Check " + stTelephone
endif
;.................
if stFax.isBlank() then
stFax = "Check"
else
stFax = "Check " + stFax
endif
;.................
if stWphone.isBlank() then
stWphone = "Check"
else
stWphone = "Check " + stWphone
endif
;.................
if stCell_pgr.isBlank() then
stCell_pgr = "Check"
else
stCell_pgr = "Check " + stCell_pgr
endif
;.................
if ste_mail.isBlank() then
ste_mail = "Check"
else
ste_mail = "Check " + ste_mail
endif
;.................
if stweb_site.isBlank() then
stweb_site = "Check"
else
stweb_site = "Check " + stweb_site
endif
;.................
if stAddress.isBlank() then
stAddress = "Check"
else
stAddress = "Check " + stAddress
endif
;.................
if stCity.isBlank() then
stCity = "Check"
else
stCity = "Check " + stCity
endif
;.................
if stState.isBlank() then
stState = "Check"
else
stState = "Check " + stState
endif
;.................
if stZip.isBlank() then
stZip = "Check"
else
stZip = "Check " + stZip
endif
;.................
if stCountry.isBlank() then
stCountry = "Check"
else
stCountry = "Check " + stCountry
endif
;.................
if stInformation.isBlank() then
stInformation = "Check"
else
stInformation = "Check " + stInformation
endif
;.................
if stPreferred_Location.isBlank() then
stPreferred_Location = "Check"
else
stPreferred_Location = "Check " + stPreferred_Location
endif
;.................
if stSalary.isBlank() then
stSalary = "Check"
else
stSalary = "Check " + stSalary
endif
;.................
if stLocation_Type.isBlank() then
stLocation_Type = "Check"
else
stLocation_Type = "Check " + stLocation_Type
endif
;.................
if stRating_backg.isBlank() then
stRating_backg = "Check"
else
stRating_backg = "Check " + stRating_backg
endif
;.................
if stRating_Prof.isBlank() then
stRating_Prof = "Check"
else
stRating_Prof = "Check " + stRating_Prof
endif
;.................
if stRating_stab.isBlank() then
stRating_stab = "Check"
else
stRating_stab = "Check " + stRating_stab
endif
;.................
if stRating_food.isBlank() then
stRating_food = "Check"
else
stRating_food = "Check " + stRating_food
endif
;.................
if stRating_org_sys.isBlank() then
stRating_org_sys = "Check"
else
stRating_org_sys = "Check " + stRating_org_sys
endif
;.................
if stRating_vol.isBlank() then
stRating_vol = "Check"
else
stRating_vol = "Check " + stRating_vol
endif
;.................
if stRating_attitude.isBlank() then
stRating_attitude = "Check"
else
stRating_attitude = "Check " + stRating_attitude
endif
;.................
if stRestaurant.isBlank() then
stRestaurant = "Check"
else
stRestaurant = "Check " + stRestaurant
endif
;.................
if stREST_S.isBlank() then
stREST_S = "Check"
else
stREST_S = "Check " + stREST_S
endif
;.................
if stWinery.isBlank() then
stWinery = "Check"
else
stWinery = "Check " + stWinery
endif
;.................
if stR_VOL.isBlank() then
stR_VOL = "Check"
else
stR_VOL = "Check " + stR_VOL
endif
;.................
if stR_STAR.isBlank() then
stR_STAR = "Check"
else
stR_STAR = "Check " + stR_STAR
endif
;.................
if stR_CORP.isBlank() then
stR_CORP = "Check"
else
stR_CORP = "Check " + stR_CORP
endif
;.................
if stCLUB.isBlank() then
stCLUB = "Check"
else
stCLUB = "Check " + stCLUB
endif
;.................
if stCL_TOP.isBlank() then
stCL_TOP = "Check"
else
stCL_TOP = "Check " + stCL_TOP
endif
;.................
if stHOT.isBlank() then
stHOT = "Check"
else
stHOT = "Check " + stHOT
endif
;.................
if stTop_Hotel.isBlank() then
stTop_Hotel = "Check"
else
stTop_Hotel = "Check " + stTop_Hotel
endif
;.................
if stConvention_Ctr.isBlank() then
stConvention_Ctr = "Check"
else
stConvention_Ctr = "Check " + stConvention_Ctr
endif
;.................
if stCasino.isBlank() then
stCasino = "Check"
else
stCasino = "Check " + stCasino
endif
;.................
if stInn_Bed_Breakfast.isBlank() then
stInn_Bed_Breakfast= "Check"
else
stInn_Bed_Breakfast = "Check " + stInn_Bed_Breakfast
endif
;.................
if stMaritime.isBlank() then
stMaritime = "Check"
else
stMaritime = "Check " + stMaritime
endif
;.................
if stHOT_UNIT.isBlank() then
stHOT_UNIT = "Check"
else
stHOT_UNIT = "Check " + stHOT_UNIT
endif
;.................
if stLuxury_Resort.isBlank() then
stLuxury_Resort = "Check"
else
stLuxury_Resort = "Check " + stLuxury_Resort
endif
;.................
if stRd.isBlank() then
stRd = "Check"
else
stRd = "Check " + stRd
endif
;.................
if stCOMM.isBlank() then
stCOMM = "Check"
else
stCOMM = "Check " + stCOMM
endif
;.................
if stCTG.isBlank() then
stCTG = "Check"
else
stCTG = "Check " + stCTG
endif
;.................
if stFS.isBlank() then
stFS = "Check"
else
stFS = "Check " + stFS
endif
;.................
if stDELI_HRM.isBlank() then
stDELI_HRM = "Check"
else
stDELI_HRM = "Check " + stDELI_HRM
endif
;.................
if stFamily.isBlank() then
stFamily = "Check"
else
stFamily = "Check " + stFamily
endif
;.................
if stChain.isBlank() then
stChain = "Check"
else
stChain = "Check " + stChain
endif
;.................
if stQuick_Serve.isBlank() then
stQuick_Serve = "Check"
else
stQuick_Serve = "Check " + stQuick_Serve
endif
;.................
if stRetail.isBlank() then
stRetail = "Check"
else
stRetail = "Check " + stRetail
endif
;.................
if stBAKERY_RTL.isBlank() then
stBAKERY_RTL = "Check"
else
stBAKERY_RTL = "Check " + stBAKERY_RTL
endif
;.................
if stBakery_Comm.isBlank() then
stBakery_Comm = "Check"
else
stBakery_Comm = "Check " + stBakery_Comm
endif
;.................
if stBKRY_WHLS.isBlank() then
stBKRY_WHLS = "Check"
else
stBKRY_WHLS = "Check " + stBKRY_WHLS
endif
;.................
if stDOM.isBlank() then
stDOM = "Check"
else
stDOM = "Check " + stDOM
endif
;.................
if stSchool.isBlank() then
stSchool = "Check"
else
stSchool = "Check " + stSchool
endif
;.................
if stQUAL.isBlank() then
stQUAL = "Check"
else
stQUAL = "Check " + stQUAL
endif
;.................
if stSEAT_NR.isBlank() then
stSEAT_NR = "Check"
else
stSEAT_NR = "Check " + stSEAT_NR
endif
;.................
if stBNKT_NR.isBlank() then
stBNKT_NR = "Check"
else
stBNKT_NR = "Check " + stBNKT_NR
endif
;.................
if stVOL_Annual.isBlank() then
stVOL_Annual = "Check"
else
stVOL_Annual = "Check " + stVOL_Annual
endif
;.................
if stVol_Covers.isBlank() then
stVol_Covers = "Check"
else
stVol_Covers = "Check " + stVol_Covers
endif
;.................
if stVery_interesting.isBlank() then
stVery_interesting = "Check"
else
stVery_interesting = "Check " + stVery_interesting
endif
;.................
if stTRAIN.isBlank() then
stTRAIN = "Check"
else
stTRAIN = "Check " + stTRAIN
endif
;.................
if stSPECIAL_SKILLS.isBlank() then
stSPECIAL_SKILLS = "Check"
else
stSPECIAL_SKILLS = "Check " + stSPECIAL_SKILLS
endif
;.................
if stFrench_Haute.isBlank() then
stFrench_Haute = "Check"
else
stFrench_Haute = "Check " + stFrench_Haute
endif
;.................
if stFrench_Bistro.isBlank() then
stFrench_Bistro = "Check"
else
stFrench_Bistro = "Check " + stFrench_Bistro
endif
;.................
if stContinental.isBlank() then
stContinental = "Check"
else
stContinental = "Check " + stContinental
endif
;.................
if stAmerican_Club.isBlank() then
stAmerican_Club = "Check"
else
stAmerican_Club = "Check " + stAmerican_Club
endif
;.................
if stAmerican_Market.isBlank() then
stAmerican_Market = "Check"
else
stAmerican_Market = "Check " + stAmerican_Market
endif
;.................
if stItalian.isBlank() then
stItalian = "Check"
else
stItalian = "Check " + stItalian
endif
;.................
if stSpanish.isBlank() then
stSpanish = "Check"
else
stSpanish = "Check " + stSpanish
endif
;.................
if stMexican.isBlank() then
stMexican = "Check"
else
stMexican = "Check " + stMexican
endif
;.................
if stOther_Hispanic.isBlank() then
stOther_Hispanic = "Check"
else
stOther_Hispanic = "Check " + stOther_Hispanic
endif
;.................
if stHaute_Complex.isBlank() then
stHaute_Complex = "Check"
else
stHaute_Complex = "Check " + stHaute_Complex
endif
;.................
if stHaute.isBlank() then
stHaute = "Check"
else
stHaute = "Check " + stHaute
endif
;.................
if stMediterran.isBlank() then
stMediterran = "Check"
else
stMediterran = "Check " + stMediterran
endif
;.................
if stChinese.isBlank() then
stChinese = "Check"
else
stChinese = "Check " + stChinese
endif
;.................
if stJapanese.isBlank() then
stJapanese = "Check"
else
stJapanese = "Check " + stJapanese
endif
;.................
if stChop_House.isBlank() then
stChop_House = "Check"
else
stChop_House = "Check " + stChop_House
endif
;.................
if stIndian.isBlank() then
stIndian = "Check"
else
stIndian = "Check " + stIndian
endif
;.................
if stOther_Asian.isBlank() then
stOther_Asian = "Check"
else
stOther_Asian = "Check " + stOther_Asian
endif
;.................
if stOther_Exotic.isBlank() then
stOther_Exotic = "Check"
else
stOther_Exotic = "Check " + stOther_Exotic
endif
;.................
if stIsland_Carribean.isBlank() then
stIsland_Carribean = "Check"
else
stIsland_Carribean = "Check " + stIsland_Carribean
endif
;.................
if stAmerican_Comfort.isBlank() then
stAmerican_Comfort = "Check"
else
stAmerican_Comfort = "Check " + stAmerican_Comfort
endif
;.................
if stSteakhouse.isBlank() then
stSteakhouse = "Check"
else
stSteakhouse = "Check " + stSteakhouse
endif
;.................
if stSeafood.isBlank() then
stSeafood = "Check"
else
stSeafood = "Check " + stSeafood
endif
;.................
if stOther_Product.isBlank() then
stOther_Product = "Check"
else
stOther_Product = "Check " + stOther_Product
endif
;.................
if stLight.isBlank() then
stLight = "Check"
else
stLight = "Check " + stLight
endif
;.................
if stPub.isBlank() then
stPub = "Check"
else
stPub = "Check " + stPub
endif
;.................
if stbiodynamic_healing_etc.isBlank() then
stbiodynamic_healing_etc = "Check"
else
stbiodynamic_healing_etc = "Check " + stbiodynamic_healing_etc
endif
;.................
if stCalif_Style.isBlank() then
stCalif_Style = "Check"
else
stCalif_Style = "Check " + stCalif_Style
endif
;.................
if stVegetarian.isBlank() then
stVegetarian = "Check"
else
stVegetarian = "Check " + stVegetarian
endif
;.................
if stAmerican_Bistro.isBlank() then
stAmerican_Bistro = "Check"
else
stAmerican_Bistro = "Check " + stAmerican_Bistro
endif
;.................
if stMarket_Driven.isBlank() then
stMarket_Driven = "Check"
else
stMarket_Driven = "Check " + stMarket_Driven
endif
;.................
if stBar_B_Que.isBlank() then
stBar_B_Que = "Check"
else
stBar_B_Que = "Check " + stBar_B_Que
endif
;.................
if stGarde.isBlank() then
stGarde = "Check"
else
stGarde = "Check " + stGarde
endif
;.................
if stIce.isBlank() then
stIce = "Check"
else
stIce = "Check " + stIce
endif
;.................
if stShow_Pieces.isBlank() then
stShow_Pieces = "Check"
else
stShow_Pieces = "Check " + stShow_Pieces
endif
;.................
if stCharcuterie.isBlank() then
stCharcuterie = "Check"
else
stCharcuterie = "Check " + stCharcuterie
endif
;.................
if stButcher.isBlank() then
stButcher = "Check"
else
stButcher = "Check " + stButcher
endif
;.................
if stOther_Skill.isBlank() then
stOther_Skill = "Check"
else
stOther_Skill = "Check " + stOther_Skill
endif
;.................
if stSugar.isBlank() then
stSugar = "Check"
else
stSugar = "Check " + stSugar
endif
;.................
if stChocolate.isBlank() then
stChocolate = "Check"
else
stChocolate = "Check " + stChocolate
endif
;.................
if stCake_deco.isBlank() then
stCake_deco = "Check"
else
stCake_deco = "Check " + stCake_deco
endif
;.................
if stVienoiserie.isBlank() then
stVienoiserie = "Check"
else
stVienoiserie = "Check " + stVienoiserie
endif
;.................
if stFine_Desserts.isBlank() then
stFine_Desserts = "Check"
else
stFine_Desserts = "Check " + stFine_Desserts
endif
;.................
if stCalifornia_Style.isBlank() then
stCalifornia_Style = "Check"
else
stCalifornia_Style = "Check " + stCalifornia_Style
endif
;.................
if stCajun.isBlank() then
stCajun = "Check"
else
stCajun = "Check " + stCajun
endif
;.................
if stOther_American_regional.isBlank() then
stOther_American_regional = "Check"
else
stOther_American_regional = "Check " + stOther_American_regional
endif
;.................
if stBuffet.isBlank() then
stBuffet = "Check"
else
stBuffet = "Check " + stBuffet
endif
;.................
if stBanquet.isBlank() then
stBanquet = "Check"
else
stBanquet = "Check " + stBanquet
endif
;.................
if stPastry.isBlank() then
stPastry = "Check"
else
stPastry = "Check " + stPastry
endif
;.................
if stDesserts.isBlank() then
stDesserts = "Check"
else
stDesserts = "Check " + stDesserts
endif
;.................
if stBread.isBlank() then
stBread = "Check"
else
stBread = "Check " + stBread
endif
;.................
if stHigh_Profile.isBlank() then
stHigh_Profile = "Check"
else
stHigh_Profile = "Check " + stHigh_Profile
endif
;.................
if stVolume_Production.isBlank() then
stVolume_Production = "Check"
else
stVolume_Production = "Check " + stVolume_Production
endif
;.................
if stFood_Chemistry.isBlank() then
stFood_Chemistry = "Check"
else
stFood_Chemistry = "Check " + stFood_Chemistry
endif
;.................
if stNutrition.isBlank() then
stNutrition = "Check"
else
stNutrition = "Check " + stNutrition
endif
;.................
if stTrainer.isBlank() then
stTrainer = "Check"
else
stTrainer = "Check " + stTrainer
endif
;.................
if stHaccp.isBlank() then
stHaccp = "Check"
else
stHaccp = "Check " + stHaccp
endif
;.................
if stInstructor.isBlank() then
stInstructor = "Check"
else
stInstructor = "Check " + stInstructor
endif
;.................
if stComputer.isBlank() then
stComputer = "Check"
else
stComputer = "Check " + stComputer
endif
;.................
if stMulti_Unit.isBlank() then
stMulti_Unit = "Check"
else
stMulti_Unit = "Check " + stMulti_Unit
endif
;.................
if stOpening_Planning.isBlank() then
stOpening_Planning = "Check"
else
stOpening_Planning = "Check " + stOpening_Planning
endif
;.................
if stCEC.isBlank() then
stCEC = "Check"
else
stCEC = "Check " + stCEC
endif
;.................
if stSrve_Safe.isBlank() then
stSrve_Safe = "Check"
else
stSrve_Safe = "Check " + stSrve_Safe
endif
;.................
if stSpeak_Span.isBlank() then
stSpeak_Span = "Check"
else
stSpeak_Span = "Check " + stSpeak_Span
endif
;.................
if stPress_Portfolio.isBlank() then
stPress_Portfolio = "Check"
else
stPress_Portfolio = "Check " + stPress_Portfolio
endif
;.................
if stAwards.isBlank() then
stAwards = "Check"
else
stAwards = "Check " + stAwards
endif
;.................
if stCorpChef.isBlank() then
stCorpChef = "Check"
else
stCorpChef = "Check " + stCorpChef
endif
;.................
if stExecChef.isBlank() then
stExecChef = "Check"
else
stExecChef = "Check " + stExecChef
endif
;.................
if stWCh.isBlank() then
stWCh = "Check"
else
stWCh = "Check " + stWCh
endif
;.................
if stExSch.isBlank() then
stExSch = "Check"
else
stExSch = "Check " + stExSch
endif
;.................
if stSch.isBlank() then
stSch = "Check"
else
stSch = "Check " + stSch
endif
;.................
if stChef_and_Manager.isBlank() then
stChef_and_Manager = "Check"
else
stChef_and_Manager = "Check " + stChef_and_Manager
endif
;.................
if stGarde_Manger.isBlank() then
stGarde_Manger = "Check"
else
stGarde_Manger = "Check " + stGarde_Manger
endif
;.................
if stTournant.isBlank() then
stTournant = "Check"
else
stTournant = "Check " + stTournant
endif
;.................
if stChdC.isBlank() then
stChdC = "Check"
else
stChdC = "Check " + stChdC
endif
;.................
if stKM.isBlank() then
stKM = "Check"
else
stKM = "Check " + stKM
endif
;.................
if stPstryCh.isBlank() then
stPstryCh = "Check"
else
stPstryCh = "Check " + stPstryCh
endif
;.................
if stPstryAsst.isBlank() then
stPstryAsst = "Check"
else
stPstryAsst = "Check " + stPstryAsst
endif
;.................
if stBaker.isBlank() then
stBaker = "Check"
else
stBaker = "Check " + stBaker
endif
;.................
if stDir_Bkry_Prod.isBlank() then
stDir_Bkry_Prod = "Check"
else
stDir_Bkry_Prod = "Check " + stDir_Bkry_Prod
endif
;.................
if stBnktCh.isBlank() then
stBnktCh = "Check"
else
stBnktCh = "Check " + stBnktCh
endif
;.................
if stBnktAsst.isBlank() then
stBnktAsst = "Check"
else
stBnktAsst = "Check " + stBnktAsst
endif
;.................
if stLnCk.isBlank() then
stLnCk = "Check"
else
stLnCk = "Check " + stLnCk
endif
;.................
if stDFB.isBlank() then
stDFB = "Check"
else
stDFB = "Check " + stDFB
endif
;.................
if stDir_Ops_CEO.isBlank() then
stDir_Ops_CEO = "Check"
else
stDir_Ops_CEO = "Check " + stDir_Ops_CEO
endif
;.................
if stDir_Prod.isBlank() then
stDir_Prod = "Check"
else
stDir_Prod = "Check " + stDir_Prod
endif
;.................
if stRegional_Manager.isBlank() then
stRegional_Manager = "Check"
else
stRegional_Manager = "Check " + stRegional_Manager
endif
;.................
if stCorpGM.isBlank() then
stCorpGM = "Check"
else
stCorpGM = "Check " + stCorpGM
endif
;.................
if stGeneral_Manager.isBlank() then
stGeneral_Manager = "Check"
else
stGeneral_Manager = "Check " + stGeneral_Manager
endif
;.................
if stDining_Room_Maitre_D.isBlank() then
stDining_Room_Maitre_D = "Check"
else
stDining_Room_Maitre_D = "Check " + stDining_Room_Maitre_D
endif
;.................
if stManager.isBlank() then
stManager = "Check"
else
stManager = "Check " + stManager
endif
;.................
if stDirector_of_Food_Service.isBlank() then
stDirector_of_Food_Service = "Check"
else
stDirector_of_Food_Service = "Check " + stDirector_of_Food_Service
endif
;.................
if stAsst_Manager.isBlank() then
stAsst_Manager = "Check"
else
stAsst_Manager = "Check " + stAsst_Manager
endif
;.................
if stAGM.isBlank() then
stAGM = "Check"
else
stAGM = "Check " + stAGM
endif
;.................
if stDir_Ctg.isBlank() then
stDir_Ctg = "Check"
else
stDir_Ctg = "Check " + stDir_Ctg
endif
;.................
if stCatMgr.isBlank() then
stCatMgr = "Check"
else
stCatMgr = "Check " + stCatMgr
endif
;.................
if stBnktmgr.isBlank() then
stBnktmgr = "Check"
else
stBnktmgr = "Check " + stBnktmgr
endif
;.................
if stRetail_management.isBlank() then
stRetail_management = "Check"
else
stRetail_management = "Check " + stRetail_management
endif
;.................
if stOther_management.isBlank() then
stOther_management = "Check"
else
stOther_management = "Check " + stOther_management
endif
;.................
if stWine.isBlank() then
stWine = "Check"
else
stWine = "Check " + stWine
endif
;.................
if stResume.isBlank() then
stResume = "Check"
else
stResume = "Check " + stResume
endif
;.................
if stResumememo.isBlank() then
stResumememo = "Check"
else
stResumememo = "Check " + stResumememo
endif
;.................
if stNotes.isBlank() then
stNotes = "Check"
else
stNotes = "Check " + stNotes
endif
;.................
if stQuality_Of_Life.isBlank() then
stQuality_Of_Life = "Check"
else
stQuality_Of_Life = "Check " + stQuality_Of_Life
endif
;.................
if stMove_from_SF_or_CA.isBlank() then
stMove_from_SF_or_CA = "Check"
else
stMove_from_SF_or_CA = "Check " + stMove_from_SF_or_CA
endif
;.................
if stNon_Urban.isBlank() then
stNon_Urban = "Check"
else
stNon_Urban = "Check " + stNon_Urban
endif
;.................
if stPrint_Sample_Menu_or_pic.isBlank() then
stPrint_Sample_Menu_or_pic = "Check"
else
stPrint_Sample_Menu_or_pic = "Check " + stPrint_Sample_Menu_or_pic
endif
;.................
if stReference_Letter.isBlank() then
stReference_Letter = "Check"
else
stReference_Letter = "Check " + stReference_Letter
endif
;.................
if stReferences.isBlank() then
stReferences = "Check"
else
stReferences = "Check " + stReferences
endif
;.................
if stSample_Sample_Menu.isBlank() then
stSample_Sample_Menu = "Check"
else
stSample_Sample_Menu = "Check " + stSample_Sample_Menu
endif
;.................
if stSource.isBlank() then
stSource = "Check"
else
stSource = "Check " + stSource
endif
;.................
if stConsider.isBlank() then
stConsider = "Check"
else
stConsider = "Check " + stConsider
endif
;.................
if stDo.isBlank() then
stDo = "Check"
else
stDo = "Check " + stDo
endif
;.................
if stPicture.isBlank() then
stPicture = "Check"
else
stPicture = "Check " + stPicture
endif
;.................
if stFoodpics.isBlank() then
stFoodpics = "Check"
else
stFoodpics = "Check " + stFoodpics
endif
;.................
if stPic1.isBlank() then
stPic1 = "Check"
else
stPic1 = "Check " + stPic1
endif
;.................
if stPic2.isBlank() then
stPic2 = "Check"
else
stPic2 = "Check " + stPic2
endif
;.................
if stPic3.isBlank() then
stPic3 = "Check"
else
stPic3 = "Check " + stPic3
endif
;.................
if stPic4.isBlank() then
stPic4 = "Check"
else
stPic4 = "Check " + stPic4
endif
;.................
if stPic5.isBlank() then
stPic5 = "Check"
else
stPic5 = "Check " + stPic5
endif
;.................
if stPic6.isBlank() then
stPic6 = "Check"
else
stPic6 = "Check " + stPic6
endif
;.................
if stPic7.isBlank() then
stPic7 = "Check"
else
stPic7 = "Check " + stPic7
endif
;.................
if stPic8.isBlank() then
stPic8 = "Check"
else
stPic8 = "Check " + stPic8
endif
;.................
if stPic9.isBlank() then
stPic9 = "Check"
else
stPic9 = "Check " + stPic9
endif
;.................
if stPic10.isBlank() then
stPic10 = "Check"
else
stPic10 = "Check " + stPic10
endif
;.................
if stPhoto.isBlank() then
stPhoto = "Check"
else
stPhoto = "Check " + stPhoto
endif
;.................
if stReview.isBlank() then
stReview = "Check"
else
stReview = "Check " + stReview
endif
;.................
if stRank.isBlank() then
stRank = "Check"
else
stRank = "Check " + stRank
endif
;.................
if stNo.isBlank() then
stNo = "Check"
else
stNo = "Check " + stNo
endif
;.................
if stCategories.isBlank() then
stCategories = "Check"
else
stCategories = "Check " + stCategories
endif
;.................
if stNorth_East.isBlank() then
stNorth_East = "Check"
else
stNorth_East = "Check " + stNorth_East
endif
;.................
if stSoutheast.isBlank() then
stSoutheast = "Check"
else
stSoutheast = "Check " + stSoutheast
endif
;.................
if stSouth.isBlank() then
stSouth = "Check"
else
stSouth = "Check " + stSouth
endif
;.................
if stMidwest.isBlank() then
stMidwest = "Check"
else
stMidwest = "Check " + stMidwest
endif
;.................
if stSouthwest.isBlank() then
stSouthwest = "Check"
else
stSouthwest = "Check " + stSouthwest
endif
;.................
if stMountain_States.isBlank() then
stMountain_States = "Check"
else
stMountain_States = "Check " + stMountain_States
endif
;.................
if stNorthwest.isBlank() then
stNorthwest = "Check"
else
stNorthwest = "Check " + stNorthwest
endif
;.................
if stNo_preference.isBlank() then
stNo_preference = "Check"
else
stNo_preference = "Check " + stNo_preference
endif
;.................
if stInternattional.isBlank() then
stInternattional = "Check"
else
stInternattional = "Check " + stInternattional
endif
;.................
if stAsia.isBlank() then
stAsia = "Check"
else
stAsia = "Check " + stAsia
endif
;.................
if stMiddle_East.isBlank() then
stMiddle_East = "Check"
else
stMiddle_East = "Check " + stMiddle_East
endif
;.................
if stEurope.isBlank() then
stEurope = "Check"
else
stEurope = "Check " + stEurope
endif
;.................
if stWest_Coast.isBlank() then
stWest_Coast = "Check"
else
stWest_Coast = "Check " + stWest_Coast
endif
;.................
if streferrals.isBlank() then
streferrals = "Check"
else
streferrals = "Check " + streferrals
endif
;.................
if stContact.isBlank() then
stContact = "Check"
else
stContact = "Check " + stContact
endif
;.................
if stConsider_For.isBlank() then
stConsider_For = "Check"
else
stConsider_For = "Check " + stConsider_For
endif

endif
;=============================== errors
errorTrapOnWarnings(Yes)
;date range issues. try later
;try ;this will drop out if either date conversion fails
;daTemp = date(stFromDate)
;daTemp = date(stToDate)
;stDateRange = "Check " + ">= " + stFromDate + "<= " + ;stToDate
;onFail
;stFromDate.blank()
; stToDate.blank()
;stDateRange = "Check"
;fldFromDate'value = "" ;adjust the display
;fldToDate'value = "" ;to match our query <g> !
;endTry
; errorTrapOnWarnings(No)


;==============================

;==========query

quQuery = QUERY


ANSWER: : C:\WORKING\results.DB


newrol.DB | NAME | LOCATION | TITLE | PARTNER | ENTRY_DATE | Telephone |
| ~stNAME| ~stLOCATION ~stTITLE | ~stPARTNER | ~stENTRY_DATE | ~stTelephone |

newrol.DB | Fax | Wphone | Cell_pgr | e_mail | web_site | Address | City |
|~stFax | ~stWphone | ~stCell_pgr | ~ste_mail | ~stweb_site | ~stAddress | ~stCity |

newrol.DB | State | Zip | Country | Information | Preferred_Location |
| ~stState | ~stZip | ~stCountry | ~stInformation | ~stPreferred_Location |

newrol.DB | Salary | Location_Type | Rating_backg | Rating_Prof | Rating_stab |
| ~stSalary | ~stLocation_Type | ~stRating_backg | ~stRating_Prof | Check ~stRating_stab |

newrol.DB | Rating_food | Rating_org_sys | Rating_vol | Rating_attitude |
| ~stRating_food| ~stRating_org_sys | ~stRating_vol | ~stRating_attitude |

newrol.DB | Restaurant | REST_S | Winery | R_VOL | R_STAR | R_CORP | CLUB |
| ~stRestaurant | ~stREST_S | ~stWinery | ~stR_VOL | ~stR_STAR | ~stR_CORP | ~stCLUB |

newrol.DB | CL_TOP | HOT | Top_Hotel | Convention Ctr | Casino |
| ~stCL_TOP | ~stHOT | ~stTop_Hotel | ~stConvention_Ctr | ~stCasino |

newrol.DB | Inn_Bed_Breakfast | Maritime | HOT_UNIT | Luxury_Resort |
| ~stInn_Bed_Breakfast | ~Maritime | ~stHOT_UNIT | ~stLuxury_Resort|

newrol.DB | Lodge_Guest_Ranch | Rd | COMM | CTG | FS | DELI_HRM |
| ~stLodge_Guest_Ranch | ~stRde | ~stCOMM | ~stCTG| ~stFS | ~stDELI_HRM |

newrol.DB | Family | Chain | Quick Serve | Retail | BAKERY RTL |
| ~stFamily | ~stChain| ~stQuick_Serve| ~stRetail | ~stBAKERY_RTL |

newrol.DB | Bakery_Comm | BKRY_WHLS | DOM | School | QUAL | SEAT_NR |
| ~stBakery_Comm | ~stBKRY_WHLS | ~stDOM | ~stSchool| ~stQUAL | ~stSEAT_NR |

newrol.DB | BNKT_NR | VOL_Annual | Vol_Covers | Very_interesting | TRAIN |
| ~stBNKT_NR | Check ~stVOL_Annual | ~stVol_Covers | ~stVery_interesting | ~stTRAIN |

newrol.DB | SPECIAL_SKILLS | French_Haute | French_Bistro | Continental |
| ~stSPECIAL_SKILLS | ~stFrench_Haute| ~stFrench_Bistro | ~stContinental |

newrol.DB | American_Club | American_Market | Italian | Spanish | Mexican |
| ~stAmerican_Club | ~stAmerican_Market| ~stItalian| ~stSpanish | ~stMexican |

newrol.DB | Other_Hispanic | Haute_Complex | Haute | Mediterranean | Chinese |
| ~stOther_Hispanic | ~stHaute_Complex | ~stHaute | ~stMediterranean | ~stChinese |

newrol.DB | Japanese | Chop_House | Indian | Other_Asian | Other_Exotic |
| ~stJapanese | ~stChop_House | ~stIndian | ~stOther_Asian | ~stOther_Exotic |

newrol.DB | Island_Carribean | American_Contemporary | American_Comfort |
| ~stIsland_Carribean | ~stAmerican_Contemporary | ~stAmerican_Comfort |

newrol.DB | Steakhouse | Seafood | Other_Product | Light | Pub |
| ~stSteakhouse | ~stSeafood | ~stOther_Product| ~stLight | ~stPub |

newrol.DB | biodynamic healing etc | Calif Style | Vegetarian |
| ~stbiodynamic_healing_etc | ~stCalif_Style | ~stVegetarian |

newrol.DB | American_Bistro | Market_Driven | Bar_B_Que | Garde | Ice |
| ~stAmerican_Bistro | ~stMarket_Driven | ~stBar_B_Que | ~stGarde | ~stIce |

newrol.DB | Show_Pieces | Charcuterie | Butcher | Other_Skill | Sugar |
| ~stShow_Pieces | ~stCharcuterie | ~stButcher| ~stOther_Skill | ~stSugar |

newrol.DB | Chocolate | Cake_deco | Vienoiserie | Fine_Desserts |
| ~stChocolate | ~stCake_deco | ~stVienoiserie | ~stFine_Desserts |

newrol.DB | California_Style | Cajun | Other_American_regional | Buffet |
| ~stCalifornia_Style | ~stCajun| ~stOther_American_regional | ~stBuffet |

newrol.DB | Banquet | Pastry | Desserts | Bread | High_Profile |
| ~stBanquet | ~stPastry | ~stDesserts | ~stBread | ~stHigh_Profile |

newrol.DB | Volume Production | Food Chemistry | Nutrition | Trainer | Haccp |
| ~stVolume_Production | ~stFood_Chemistry | ~stNutrition | ~stTrainer | ~stHaccp |

newrol.DB | Instructor | Computer | Multi_Unit | Opening_Planning | CEC |
| ~stInstructor | ~stComputer | ~stMulti_Unit | ~stOpening_Planning| ~stCEC |

newrol.DB | Srve_Safe | Speak_Span | Press_Portfolio | Awards | CorpChef |
| ~stInstructor | ~stComputer |~stMulti_Unit | ~stOpening_Planning | ~stCEC|

newrol.DB | ExecChef | WCh | ExSch | Sch | Chef_and_Manager |
| ~stExecChef | ~stWCJ | ~stExSch | ~stSch | ~stChef_and_Manager |

newrol.DB | Garde_Manger | Tournant | ChdC | KM | PstryCh | PstryAsst |
| ~stGarde_Manger | ~stTournant | ~stChdC | ~stKM | ~stPstryCh| ~stPstryAsst |

newrol.DB | Baker | Dir_Bkry Prod | BnktCh | BnktAsst | LnCk | DFB |
| ~stBaker | ~stDir_Bkry_Prod | ~stBnktCh | ~stBnktAsst | ~stLnCk | ~stDFB |

newrol.DB | Dir_Ops_CEO | Dir_Prod | Regional_Manager | CorpGM |
| ~stDir_Ops_CEO | ~stDir_Prod | ~stRegional_Manager| ~stCorpGM |

newrol.DB | General_Manager | Dining Room_Maitre D | Manager |
| ~stGeneral_Manager | ~stDining_Room_Maitre_D | ~stManager|

newrol.DB | Director_of_Food_Service | Asst_Manager | AGM | Dir_Ctg |
| ~stDirector_of_Food_Service | ~stAsst_Manager| ~stAGM| ~stDir_Ctg |

newrol.DB | CatMgr | Bnktmgr | Retail management | Other_management | Wine |
| ~stCatMgr| ~stBnktmgr | ~stRetail_management | ~stOther_management| ~stWine |

newrol.DB | Resume | Resumememo | Notes | Quality_Of_Life |
| ~stResume | ~stResumememo| ~stNotes| ~stQuality_Of_Life |

newrol.DB | Move_from_SF_or_CA | Non_Urban | Print_Sample_Menu_or_pic |
| ~stMove_from_SF_or_CA | ~stNon_Urban | Check | ~stPrint__Sample_Menu_or_pic |

newrol.DB | Reference_Letter | References | Sample_Menu | Source | Consider |
| ~stReference_Letter | ~stReferences | ~stSample_Sample_Menu| ~stSource | ~stConsider |

newrol.DB | Do | Picture | Foodpics | Pic1 | Pic2 | Pic3 | Pic4 |
| ~stDo | ~stPicture | ~stFoodpics | ~stPic1| ~stPic2 | ~stPic3 | ~stPic4 |

newrol.DB | Pic5 | Pic6 | Pic7 | Pic8 | Pic9 | Pic10 | Photo |
| ~stPic5 | ~stPic6 | ~stPic7 | ~stPic8 | ~stPic9| ~stPic10 | ~stPhoto |

newrol.DB | Review | Rank | No | Categories | North_East | Southeast |
| ~stReview | ~stRank | ~stNo | ~stCategories | ~stNorth_East | ~stSoutheast |

newrol.DB | South | Midwest | Southwest | Mountain_States | Northwest |
| ~stSouth | ~stMidwest| ~stSouthwest | ~stMountain_States | ~stNorthwest |

newrol.DB | No_preference | Internattional | Asia | Middle_East | Europe |
| ~stNo_preference | ~stInternattional | ~stAsia| ~stMiddle_East | ~stEurope |

newrol.DB | West_Coast | referrals | Contact | Consider_For |
| ~stWest_Coast | ~streferrals | ~stContact | ~stConsider_For |


ENDQUERY

errorTrapOnWarnings(Yes)
quQuery.writeQBE(":Work:Query.QBE")
try
quQuery.executeQBE()
tvResults.open(":Work:OrderInfo1.DB")
tvResults.wait()
tvResults.close()
onFail
errorShow()
msgStop("", "")
endTry
errorTrapOnWarnings(No)
endMethod