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  |
 

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