view. Can doing select statement on base table (employee) prior to issuing delete on view cause this problem? I'm I missing something here?
Thanks for replying again Esparta. I created the view using view designner. However I ran gendbc so you can see how the view is setup.
FUNCTION MakeView_LV_EMPLOYEE
***************** View setup for LV_EMPLOYEE ***************
CREATE SQL VIEW "LV_EMPLOYEE" ;
AS SELECT Employee.e_id, Employee.e_ssn, Employee.e_fname, Employee.e_lname, Employee.e_mi, Employee.e_inital, Employee.e_sex, Employee.e_unit, Employee.e_class, Employee.e_itemno, Employee.e_strcty_dte, Employee.e_strprob_dte, Employee.e_address, Employee.e_city, Employee.e_state, Employee.e_zip, Employee.e_dob, Employee.e_lic, Employee.e_lic_class, Employee.e_licexp, Employee.e_milectrt, Employee.e_physdte, Employee.e_emg, Employee.e_phone, Employee.e_prkper, Employee.e_entryc, Employee.e_empstatus, Employee.e_badgeno, Employee.e_budget, Employee.e_psycdte, Employee.e_cntysnrdte, Employee.e_relinfo, Employee.e_drugdte, Employee.e_degree, Employee.e_rehiredte, Employee.e_agdte, Employee.e_termdte, Employee.e_rehire, Employee.e_kcso, Employee.e_dmv, Employee.e_bpd, Employee.e_comments, Employee.e_phq, Employee.e_employeed, Employee.e_cto, Employee.e_lstrdte, Employee.e_lretdte, Employee.e_sickamt, Employee.e_lieu, Employee.e_lwop, Employee.e_reason, Employee.e_drstmt, Employee.e_flg13, Employee.e_flg14, Employee.e_flg15, Employee.e_flg16, Employee.e_dtestamp, Employee.e_flg1, Employee.e_flg12, Employee.e_flg5, Employee.e_flg2, Employee.e_flg17, Employee.e_flg18, Employee.e_flg19 FROM employee!employee WHERE Employee.e_id = ?lc_eid
DBSetProp('LV_EMPLOYEE', 'View', 'UpdateType', 1)
DBSetProp('LV_EMPLOYEE', 'View', 'WhereType', 3)
DBSetProp('LV_EMPLOYEE', 'View', 'FetchMemo', .T.)
DBSetProp('LV_EMPLOYEE', 'View', 'SendUpdates', .T.)
DBSetProp('LV_EMPLOYEE', 'View', 'UseMemoSize', 255)
DBSetProp('LV_EMPLOYEE', 'View', 'FetchSize', 100)
DBSetProp('LV_EMPLOYEE', 'View', 'MaxRecords', -1)
DBSetProp('LV_EMPLOYEE', 'View', 'Tables', 'employee!employee')
DBSetProp('LV_EMPLOYEE', 'View', 'Prepared', .F.)
DBSetProp('LV_EMPLOYEE', 'View', 'CompareMemo', .T.)
DBSetProp('LV_EMPLOYEE', 'View', 'FetchAsNeeded', .F.)
DBSetProp('LV_EMPLOYEE', 'View', 'FetchSize', 100)
DBSetProp('LV_EMPLOYEE', 'View', 'ParameterList', "lc_eid,'I'")
DBSetProp('LV_EMPLOYEE', 'View', 'Comment', "* employee table view" + CHR(13) + "")
DBSetProp('LV_EMPLOYEE', 'View', 'BatchUpdateCount', 1)
DBSetProp('LV_EMPLOYEE', 'View', 'ShareConnection', .F.)
*!* Field Level Properties for LV_EMPLOYEE
* Props for the LV_EMPLOYEE.e_id field.
DBSetProp('LV_EMPLOYEE.e_id', 'Field', 'KeyField', .T.)
DBSetProp('LV_EMPLOYEE.e_id', 'Field', 'Updatable', .F.)
DBSetProp('LV_EMPLOYEE.e_id', 'Field', 'UpdateName', 'employee!employee.e_id')
DBSetProp('LV_EMPLOYEE.e_id', 'Field', 'Comment', "uniqueid for employee")
DBSetProp('LV_EMPLOYEE.e_id', 'Field', 'DataType', "I")
* Props for the LV_EMPLOYEE.e_ssn field.
DBSetProp('LV_EMPLOYEE.e_ssn', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_ssn', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_ssn', 'Field', 'UpdateName', 'employee!employee.e_ssn')
DBSetProp('LV_EMPLOYEE.e_ssn', 'Field', 'Comment', "social security")
DBSetProp('LV_EMPLOYEE.e_ssn', 'Field', 'DataType', "C(11)")
* Props for the LV_EMPLOYEE.e_fname field.
DBSetProp('LV_EMPLOYEE.e_fname', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_fname', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_fname', 'Field', 'UpdateName', 'employee!employee.e_fname')
DBSetProp('LV_EMPLOYEE.e_fname', 'Field', 'Comment', "firstname")
DBSetProp('LV_EMPLOYEE.e_fname', 'Field', 'DataType', "C(20)")
* Props for the LV_EMPLOYEE.e_lname field.
DBSetProp('LV_EMPLOYEE.e_lname', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lname', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lname', 'Field', 'UpdateName', 'employee!employee.e_lname')
DBSetProp('LV_EMPLOYEE.e_lname', 'Field', 'Comment', "lastname")
DBSetProp('LV_EMPLOYEE.e_lname', 'Field', 'DataType', "C(25)")
* Props for the LV_EMPLOYEE.e_mi field.
DBSetProp('LV_EMPLOYEE.e_mi', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_mi', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_mi', 'Field', 'UpdateName', 'employee!employee.e_mi')
DBSetProp('LV_EMPLOYEE.e_mi', 'Field', 'Comment', "middle intials")
DBSetProp('LV_EMPLOYEE.e_mi', 'Field', 'DataType', "C(2)")
* Props for the LV_EMPLOYEE.e_inital field.
DBSetProp('LV_EMPLOYEE.e_inital', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_inital', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_inital', 'Field', 'UpdateName', 'employee!employee.e_inital')
DBSetProp('LV_EMPLOYEE.e_inital', 'Field', 'Comment', "3 digit initals" + CHR(13) + "")
DBSetProp('LV_EMPLOYEE.e_inital', 'Field', 'DataType', "C(3)")
* Props for the LV_EMPLOYEE.e_sex field.
DBSetProp('LV_EMPLOYEE.e_sex', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_sex', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_sex', 'Field', 'UpdateName', 'employee!employee.e_sex')
DBSetProp('LV_EMPLOYEE.e_sex', 'Field', 'Comment', "m/f")
DBSetProp('LV_EMPLOYEE.e_sex', 'Field', 'DataType', "C(1)")
* Props for the LV_EMPLOYEE.e_unit field.
DBSetProp('LV_EMPLOYEE.e_unit', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_unit', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_unit', 'Field', 'UpdateName', 'employee!employee.e_unit')
DBSetProp('LV_EMPLOYEE.e_unit', 'Field', 'Comment', "unit")
DBSetProp('LV_EMPLOYEE.e_unit', 'Field', 'DataType', "C(35)")
* Props for the LV_EMPLOYEE.e_class field.
DBSetProp('LV_EMPLOYEE.e_class', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_class', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_class', 'Field', 'UpdateName', 'employee!employee.e_class')
DBSetProp('LV_EMPLOYEE.e_class', 'Field', 'Comment', "class")
DBSetProp('LV_EMPLOYEE.e_class', 'Field', 'DataType', "C(35)")
* Props for the LV_EMPLOYEE.e_itemno field.
DBSetProp('LV_EMPLOYEE.e_itemno', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_itemno', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_itemno', 'Field', 'UpdateName', 'employee!employee.e_itemno')
DBSetProp('LV_EMPLOYEE.e_itemno', 'Field', 'Comment', "designated itemno belonging to job classification")
DBSetProp('LV_EMPLOYEE.e_itemno', 'Field', 'DataType', "C(8)")
* Props for the LV_EMPLOYEE.e_strcty_dte field.
DBSetProp('LV_EMPLOYEE.e_strcty_dte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_strcty_dte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_strcty_dte', 'Field', 'UpdateName', 'employee!employee.e_strcty_dte')
DBSetProp('LV_EMPLOYEE.e_strcty_dte', 'Field', 'Comment', "start date with county")
DBSetProp('LV_EMPLOYEE.e_strcty_dte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_strprob_dte field.
DBSetProp('LV_EMPLOYEE.e_strprob_dte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_strprob_dte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_strprob_dte', 'Field', 'UpdateName', 'employee!employee.e_strprob_dte')
DBSetProp('LV_EMPLOYEE.e_strprob_dte', 'Field', 'Comment', "start date with probation")
DBSetProp('LV_EMPLOYEE.e_strprob_dte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_address field.
DBSetProp('LV_EMPLOYEE.e_address', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_address', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_address', 'Field', 'UpdateName', 'employee!employee.e_address')
DBSetProp('LV_EMPLOYEE.e_address', 'Field', 'Comment', "address")
DBSetProp('LV_EMPLOYEE.e_address', 'Field', 'DataType', "C(100)")
* Props for the LV_EMPLOYEE.e_city field.
DBSetProp('LV_EMPLOYEE.e_city', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_city', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_city', 'Field', 'UpdateName', 'employee!employee.e_city')
DBSetProp('LV_EMPLOYEE.e_city', 'Field', 'Comment', "city")
DBSetProp('LV_EMPLOYEE.e_city', 'Field', 'DataType', "C(15)")
* Props for the LV_EMPLOYEE.e_state field.
DBSetProp('LV_EMPLOYEE.e_state', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_state', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_state', 'Field', 'UpdateName', 'employee!employee.e_state')
DBSetProp('LV_EMPLOYEE.e_state', 'Field', 'Comment', "state")
DBSetProp('LV_EMPLOYEE.e_state', 'Field', 'DataType', "C(10)")
* Props for the LV_EMPLOYEE.e_zip field.
DBSetProp('LV_EMPLOYEE.e_zip', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_zip', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_zip', 'Field', 'UpdateName', 'employee!employee.e_zip')
DBSetProp('LV_EMPLOYEE.e_zip', 'Field', 'Comment', "zip")
DBSetProp('LV_EMPLOYEE.e_zip', 'Field', 'DataType', "C(10)")
* Props for the LV_EMPLOYEE.e_dob field.
DBSetProp('LV_EMPLOYEE.e_dob', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_dob', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_dob', 'Field', 'UpdateName', 'employee!employee.e_dob')
DBSetProp('LV_EMPLOYEE.e_dob', 'Field', 'Comment', "date of birth")
DBSetProp('LV_EMPLOYEE.e_dob', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_lic field.
DBSetProp('LV_EMPLOYEE.e_lic', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lic', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lic', 'Field', 'UpdateName', 'employee!employee.e_lic')
DBSetProp('LV_EMPLOYEE.e_lic', 'Field', 'Comment', "drivers license number")
DBSetProp('LV_EMPLOYEE.e_lic', 'Field', 'DataType', "C(10)")
* Props for the LV_EMPLOYEE.e_lic_class field.
DBSetProp('LV_EMPLOYEE.e_lic_class', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lic_class', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lic_class', 'Field', 'UpdateName', 'employee!employee.e_lic_class')
DBSetProp('LV_EMPLOYEE.e_lic_class', 'Field', 'Comment', "license class")
DBSetProp('LV_EMPLOYEE.e_lic_class', 'Field', 'DataType', "C(3)")
* Props for the LV_EMPLOYEE.e_licexp field.
DBSetProp('LV_EMPLOYEE.e_licexp', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_licexp', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_licexp', 'Field', 'UpdateName', 'employee!employee.e_licexp')
DBSetProp('LV_EMPLOYEE.e_licexp', 'Field', 'Comment', "license expiration date")
DBSetProp('LV_EMPLOYEE.e_licexp', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_milectrt field.
DBSetProp('LV_EMPLOYEE.e_milectrt', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_milectrt', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_milectrt', 'Field', 'UpdateName', 'employee!employee.e_milectrt')
DBSetProp('LV_EMPLOYEE.e_milectrt', 'Field', 'Comment', "mileage contract")
DBSetProp('LV_EMPLOYEE.e_milectrt', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_physdte field.
DBSetProp('LV_EMPLOYEE.e_physdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_physdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_physdte', 'Field', 'UpdateName', 'employee!employee.e_physdte')
DBSetProp('LV_EMPLOYEE.e_physdte', 'Field', 'Comment', "the date employee passsed the physical test")
DBSetProp('LV_EMPLOYEE.e_physdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_emg field.
DBSetProp('LV_EMPLOYEE.e_emg', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_emg', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_emg', 'Field', 'UpdateName', 'employee!employee.e_emg')
DBSetProp('LV_EMPLOYEE.e_emg', 'Field', 'Comment', "emergency contact information" + CHR(13) + "")
DBSetProp('LV_EMPLOYEE.e_emg', 'Field', 'DataType', "C(200)")
* Props for the LV_EMPLOYEE.e_phone field.
DBSetProp('LV_EMPLOYEE.e_phone', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_phone', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_phone', 'Field', 'UpdateName', 'employee!employee.e_phone')
DBSetProp('LV_EMPLOYEE.e_phone', 'Field', 'Comment', "phone number")
DBSetProp('LV_EMPLOYEE.e_phone', 'Field', 'DataType', "C(40)")
* Props for the LV_EMPLOYEE.e_prkper field.
DBSetProp('LV_EMPLOYEE.e_prkper', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_prkper', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_prkper', 'Field', 'UpdateName', 'employee!employee.e_prkper')
DBSetProp('LV_EMPLOYEE.e_prkper', 'Field', 'Comment', "now used as phq Psyc ID# (txtprkper) previously used as parking permit number (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_prkper', 'Field', 'DataType', "C(6)")
* Props for the LV_EMPLOYEE.e_entryc field.
DBSetProp('LV_EMPLOYEE.e_entryc', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_entryc', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_entryc', 'Field', 'UpdateName', 'employee!employee.e_entryc')
DBSetProp('LV_EMPLOYEE.e_entryc', 'Field', 'Comment', "now used as phq Psyc completed date (txtEntryno) previously used as entry code (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_entryc', 'Field', 'DataType', "C(6)")
* Props for the LV_EMPLOYEE.e_empstatus field.
DBSetProp('LV_EMPLOYEE.e_empstatus', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_empstatus', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_empstatus', 'Field', 'UpdateName', 'employee!employee.e_empstatus')
DBSetProp('LV_EMPLOYEE.e_empstatus', 'Field', 'Comment', "employee status " + CHR(13) + "1 = volenteer" + CHR(13) + "2 = intern" + CHR(13) + "3 = extra help" + CHR(13) + "4 = permanent" + CHR(13) + "5 = vacant" + CHR(13) + "6 = retired" + CHR(13) + "7 = terminated")
DBSetProp('LV_EMPLOYEE.e_empstatus', 'Field', 'DataType', "I")
* Props for the LV_EMPLOYEE.e_badgeno field.
DBSetProp('LV_EMPLOYEE.e_badgeno', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_badgeno', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_badgeno', 'Field', 'UpdateName', 'employee!employee.e_badgeno')
DBSetProp('LV_EMPLOYEE.e_badgeno', 'Field', 'Comment', "employee badge list number , put bade number from badge table if issued to an officer")
DBSetProp('LV_EMPLOYEE.e_badgeno', 'Field', 'DataType', "C(3)")
* Props for the LV_EMPLOYEE.e_budget field.
DBSetProp('LV_EMPLOYEE.e_budget', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_budget', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_budget', 'Field', 'UpdateName', 'employee!employee.e_budget')
DBSetProp('LV_EMPLOYEE.e_budget', 'Field', 'Comment', "budget number")
DBSetProp('LV_EMPLOYEE.e_budget', 'Field', 'DataType', "C(4)")
* Props for the LV_EMPLOYEE.e_psycdte field.
DBSetProp('LV_EMPLOYEE.e_psycdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_psycdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_psycdte', 'Field', 'UpdateName', 'employee!employee.e_psycdte')
DBSetProp('LV_EMPLOYEE.e_psycdte', 'Field', 'Comment', "psychological evaluation date")
DBSetProp('LV_EMPLOYEE.e_psycdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_cntysnrdte field.
DBSetProp('LV_EMPLOYEE.e_cntysnrdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_cntysnrdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_cntysnrdte', 'Field', 'UpdateName', 'employee!employee.e_cntysnrdte')
DBSetProp('LV_EMPLOYEE.e_cntysnrdte', 'Field', 'Comment', "county senority date")
DBSetProp('LV_EMPLOYEE.e_cntysnrdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_relinfo field.
DBSetProp('LV_EMPLOYEE.e_relinfo', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_relinfo', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_relinfo', 'Field', 'UpdateName', 'employee!employee.e_relinfo')
DBSetProp('LV_EMPLOYEE.e_relinfo', 'Field', 'Comment', "employee release information" + CHR(13) + "")
DBSetProp('LV_EMPLOYEE.e_relinfo', 'Field', 'DataType', "C(200)")
* Props for the LV_EMPLOYEE.e_drugdte field.
DBSetProp('LV_EMPLOYEE.e_drugdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_drugdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_drugdte', 'Field', 'UpdateName', 'employee!employee.e_drugdte')
DBSetProp('LV_EMPLOYEE.e_drugdte', 'Field', 'Comment', "drug test date")
DBSetProp('LV_EMPLOYEE.e_drugdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_degree field.
DBSetProp('LV_EMPLOYEE.e_degree', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_degree', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_degree', 'Field', 'UpdateName', 'employee!employee.e_degree')
DBSetProp('LV_EMPLOYEE.e_degree', 'Field', 'Comment', "does employee have a degree?")
DBSetProp('LV_EMPLOYEE.e_degree', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_rehiredte field.
DBSetProp('LV_EMPLOYEE.e_rehiredte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_rehiredte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_rehiredte', 'Field', 'UpdateName', 'employee!employee.e_rehiredte')
DBSetProp('LV_EMPLOYEE.e_rehiredte', 'Field', 'Comment', "rehire date (eh)")
DBSetProp('LV_EMPLOYEE.e_rehiredte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_agdte field.
DBSetProp('LV_EMPLOYEE.e_agdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_agdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_agdte', 'Field', 'UpdateName', 'employee!employee.e_agdte')
DBSetProp('LV_EMPLOYEE.e_agdte', 'Field', 'Comment', "aguility date")
DBSetProp('LV_EMPLOYEE.e_agdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_termdte field.
DBSetProp('LV_EMPLOYEE.e_termdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_termdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_termdte', 'Field', 'UpdateName', 'employee!employee.e_termdte')
DBSetProp('LV_EMPLOYEE.e_termdte', 'Field', 'Comment', "termination date")
DBSetProp('LV_EMPLOYEE.e_termdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_rehire field.
DBSetProp('LV_EMPLOYEE.e_rehire', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_rehire', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_rehire', 'Field', 'UpdateName', 'employee!employee.e_rehire')
DBSetProp('LV_EMPLOYEE.e_rehire', 'Field', 'Comment', "rehire (eh)")
DBSetProp('LV_EMPLOYEE.e_rehire', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_kcso field.
DBSetProp('LV_EMPLOYEE.e_kcso', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_kcso', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_kcso', 'Field', 'UpdateName', 'employee!employee.e_kcso')
DBSetProp('LV_EMPLOYEE.e_kcso', 'Field', 'Comment', "now used as Billed (chkkcso) previously used as kern county sheriffs office (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_kcso', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_dmv field.
DBSetProp('LV_EMPLOYEE.e_dmv', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_dmv', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_dmv', 'Field', 'UpdateName', 'employee!employee.e_dmv')
DBSetProp('LV_EMPLOYEE.e_dmv', 'Field', 'Comment', "now used as Record checks (chkdmv) previously used as department of motor vehicles (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_dmv', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_bpd field.
DBSetProp('LV_EMPLOYEE.e_bpd', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_bpd', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_bpd', 'Field', 'UpdateName', 'employee!employee.e_bpd')
DBSetProp('LV_EMPLOYEE.e_bpd', 'Field', 'Comment', "now used for Background Cleared (chkbpd) previoulsy used as bakersfield police department (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_bpd', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_comments field.
DBSetProp('LV_EMPLOYEE.e_comments', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_comments', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_comments', 'Field', 'UpdateName', 'employee!employee.e_comments')
DBSetProp('LV_EMPLOYEE.e_comments', 'Field', 'Comment', "employee comments")
DBSetProp('LV_EMPLOYEE.e_comments', 'Field', 'DataType', "C(200)")
* Props for the LV_EMPLOYEE.e_phq field.
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'UpdateName', 'employee!employee.e_phq')
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'Caption', "Divison")
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'Comment', "employee personal history questionarie now used for divison and unit assignment" + CHR(13) + "08/27/02 no longer phq, it is now used for divison for the org chart")
DBSetProp('LV_EMPLOYEE.e_phq', 'Field', 'DataType', "C(50)")
* Props for the LV_EMPLOYEE.e_employeed field.
DBSetProp('LV_EMPLOYEE.e_employeed', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_employeed', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_employeed', 'Field', 'UpdateName', 'employee!employee.e_employeed')
DBSetProp('LV_EMPLOYEE.e_employeed', 'Field', 'Comment', "field may not used of thinking of purge system to move data back and forth")
DBSetProp('LV_EMPLOYEE.e_employeed', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_cto field.
DBSetProp('LV_EMPLOYEE.e_cto', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_cto', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_cto', 'Field', 'UpdateName', 'employee!employee.e_cto')
DBSetProp('LV_EMPLOYEE.e_cto', 'Field', 'Comment', "comp time off - (staff)")
DBSetProp('LV_EMPLOYEE.e_cto', 'Field', 'DataType', "N(8,1)")
* Props for the LV_EMPLOYEE.e_lstrdte field.
DBSetProp('LV_EMPLOYEE.e_lstrdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lstrdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lstrdte', 'Field', 'UpdateName', 'employee!employee.e_lstrdte')
DBSetProp('LV_EMPLOYEE.e_lstrdte', 'Field', 'Comment', "start date for leave of absence (loa)")
DBSetProp('LV_EMPLOYEE.e_lstrdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_lretdte field.
DBSetProp('LV_EMPLOYEE.e_lretdte', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lretdte', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lretdte', 'Field', 'UpdateName', 'employee!employee.e_lretdte')
DBSetProp('LV_EMPLOYEE.e_lretdte', 'Field', 'Comment', "return date for leave of absence (loa)")
DBSetProp('LV_EMPLOYEE.e_lretdte', 'Field', 'DataType', "D")
* Props for the LV_EMPLOYEE.e_sickamt field.
DBSetProp('LV_EMPLOYEE.e_sickamt', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_sickamt', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_sickamt', 'Field', 'UpdateName', 'employee!employee.e_sickamt')
DBSetProp('LV_EMPLOYEE.e_sickamt', 'Field', 'Comment', "amount of sick leave used (loa)")
DBSetProp('LV_EMPLOYEE.e_sickamt', 'Field', 'DataType', "N(8,2)")
* Props for the LV_EMPLOYEE.e_lieu field.
DBSetProp('LV_EMPLOYEE.e_lieu', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lieu', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lieu', 'Field', 'UpdateName', 'employee!employee.e_lieu')
DBSetProp('LV_EMPLOYEE.e_lieu', 'Field', 'Comment', "amount of vacation or comp-time used (loa)")
DBSetProp('LV_EMPLOYEE.e_lieu', 'Field', 'DataType', "N(8,2)")
* Props for the LV_EMPLOYEE.e_lwop field.
DBSetProp('LV_EMPLOYEE.e_lwop', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_lwop', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_lwop', 'Field', 'UpdateName', 'employee!employee.e_lwop')
DBSetProp('LV_EMPLOYEE.e_lwop', 'Field', 'Comment', "time off without pay (loa)")
DBSetProp('LV_EMPLOYEE.e_lwop', 'Field', 'DataType', "N(8,2)")
* Props for the LV_EMPLOYEE.e_reason field.
DBSetProp('LV_EMPLOYEE.e_reason', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_reason', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_reason', 'Field', 'UpdateName', 'employee!employee.e_reason')
DBSetProp('LV_EMPLOYEE.e_reason', 'Field', 'Comment', "reason for leave of absence (loa)")
DBSetProp('LV_EMPLOYEE.e_reason', 'Field', 'DataType', "C(200)")
* Props for the LV_EMPLOYEE.e_drstmt field.
DBSetProp('LV_EMPLOYEE.e_drstmt', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_drstmt', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_drstmt', 'Field', 'UpdateName', 'employee!employee.e_drstmt')
DBSetProp('LV_EMPLOYEE.e_drstmt', 'Field', 'Comment', "does employee have a dr statement")
DBSetProp('LV_EMPLOYEE.e_drstmt', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_flg13 field.
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'UpdateName', 'employee!employee.e_flg13')
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'Caption', "Eye")
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'Comment', "eye description")
DBSetProp('LV_EMPLOYEE.e_flg13', 'Field', 'DataType', "C(3)")
* Props for the LV_EMPLOYEE.e_flg14 field.
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'UpdateName', 'employee!employee.e_flg14')
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'Caption', "Weight")
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'Comment', "weight")
DBSetProp('LV_EMPLOYEE.e_flg14', 'Field', 'DataType', "C(3)")
* Props for the LV_EMPLOYEE.e_flg15 field.
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'UpdateName', 'employee!employee.e_flg15')
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'Caption', "Height")
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'Comment', "height")
DBSetProp('LV_EMPLOYEE.e_flg15', 'Field', 'DataType', "C(6)")
* Props for the LV_EMPLOYEE.e_flg16 field.
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'UpdateName', 'employee!employee.e_flg16')
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'Caption', "PMT")
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'Comment', "pmt")
DBSetProp('LV_EMPLOYEE.e_flg16', 'Field', 'DataType', "C(1)")
* Props for the LV_EMPLOYEE.e_dtestamp field.
DBSetProp('LV_EMPLOYEE.e_dtestamp', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_dtestamp', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_dtestamp', 'Field', 'UpdateName', 'employee!employee.e_dtestamp')
DBSetProp('LV_EMPLOYEE.e_dtestamp', 'Field', 'Comment', "stamp")
DBSetProp('LV_EMPLOYEE.e_dtestamp', 'Field', 'DataType', "T")
* Props for the LV_EMPLOYEE.e_flg1 field.
DBSetProp('LV_EMPLOYEE.e_flg1', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg1', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg1', 'Field', 'UpdateName', 'employee!employee.e_flg1')
DBSetProp('LV_EMPLOYEE.e_flg1', 'Field', 'Comment', "being used")
DBSetProp('LV_EMPLOYEE.e_flg1', 'Field', 'DataType', "I")
* Props for the LV_EMPLOYEE.e_flg12 field.
DBSetProp('LV_EMPLOYEE.e_flg12', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg12', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg12', 'Field', 'UpdateName', 'employee!employee.e_flg12')
DBSetProp('LV_EMPLOYEE.e_flg12', 'Field', 'Comment', "a_flg12 used for roster classification -- for roster reports")
DBSetProp('LV_EMPLOYEE.e_flg12', 'Field', 'DataType', "C(35)")
* Props for the LV_EMPLOYEE.e_flg5 field.
DBSetProp('LV_EMPLOYEE.e_flg5', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg5', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg5', 'Field', 'UpdateName', 'employee!employee.e_flg5')
DBSetProp('LV_EMPLOYEE.e_flg5', 'Field', 'Comment', "use for pay range number for orgchart reports")
DBSetProp('LV_EMPLOYEE.e_flg5', 'Field', 'DataType', "N(4,1)")
* Props for the LV_EMPLOYEE.e_flg2 field.
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'UpdateName', 'employee!employee.e_flg2')
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'Caption', "NOSYNC")
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'Comment', "A checkmark on this field means this record will not sync to camera itc access program. validations checks will be bypassed. This record will NOT SHOW UP in access program photoid")
DBSetProp('LV_EMPLOYEE.e_flg2', 'Field', 'DataType', "L")
* Props for the LV_EMPLOYEE.e_flg17 field.
DBSetProp('LV_EMPLOYEE.e_flg17', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg17', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg17', 'Field', 'UpdateName', 'employee!employee.e_flg17')
DBSetProp('LV_EMPLOYEE.e_flg17', 'Field', 'Comment', "Y/N for psyc pass or fail -- used on 6th tab under txtpsycpassfail (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_flg17', 'Field', 'DataType', "C(1)")
* Props for the LV_EMPLOYEE.e_flg18 field.
DBSetProp('LV_EMPLOYEE.e_flg18', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg18', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg18', 'Field', 'UpdateName', 'employee!employee.e_flg18')
DBSetProp('LV_EMPLOYEE.e_flg18', 'Field', 'Comment', "comment for phq -- used on 6th tab under txtphqcomment (03/20/03)")
DBSetProp('LV_EMPLOYEE.e_flg18', 'Field', 'DataType', "C(254)")
* Props for the LV_EMPLOYEE.e_flg19 field.
DBSetProp('LV_EMPLOYEE.e_flg19', 'Field', 'KeyField', .F.)
DBSetProp('LV_EMPLOYEE.e_flg19', 'Field', 'Updatable', .T.)
DBSetProp('LV_EMPLOYEE.e_flg19', 'Field', 'UpdateName', 'employee!employee.e_flg19')
DBSetProp('LV_EMPLOYEE.e_flg19', 'Field', 'Comment', "facility name within division 6th tab")
DBSetProp('LV_EMPLOYEE.e_flg19', 'Field', 'DataType', "C(50)")
ENDFUNC
On this form I also do have a routine that does update remote table using SPT. I am setting the following when I run the routine to update the remote:
lnRes = CURSORSETPROP( "Buffering", 5, "RCTCursor" )
I could this have changed my form setting permanently when I ran it once? I don't think this should affect anything but just thought I'd let you know.
THanks
Nick Patel
