RE: Can anyone see?
Hi Guys,
Many thanks to Cal, Stan, Tom and Jerry, the entire select works as advertised, You have saved my butt. A week from Thursday (12/11/03) I will spend 6 days in Indianapolis and Louisville installing the DB. The entire code now looks like this:
tbl = table.current()
if tbl.mode_get() > 0 ' runs script in enter and change 'modes
select
case tbl.holidayYN="Y"
tbl.holadd=tbl.holidayadd
tbl.holmult=tbl.hol_mult
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
case dow(tbl.drop_date)=1
tbl.sunadd=tbl.Sun_add
tbl.sunmult=tbl.Sun_mult
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sat_add=0
tbl.satmult=1
case dow(tbl.pup_date)=7
tbl.sat_add=tbl.Sats_add
tbl.satmult=tbl.Sat_mult
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
case toseconds(tbl.too_early)>toseconds(tbl.tim_pkd_up)
tbl.b48m_f_add=tbl.b48am_add
tbl.b48mfmult=tbl.b48am_mult
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
case toseconds(tbl.too_late)toseconds(tbl.drop_time)
tbl.b48m_f_add=tbl.b48am_add
tbl.b48mfmult=tbl.b48am_mult
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
tbl.aftr5add=10
tbl.aftr5_mult=1
case toseconds(tbl.Too_late)
Hi Guys,
Many thanks to Cal, Stan, Tom and Jerry, the entire select works as advertised, You have saved my butt. A week from Thursday (12/11/03) I will spend 6 days in Indianapolis and Louisville installing the DB. The entire code now looks like this:
tbl = table.current()
if tbl.mode_get() > 0 ' runs script in enter and change 'modes
select
case tbl.holidayYN="Y"
tbl.holadd=tbl.holidayadd
tbl.holmult=tbl.hol_mult
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
case dow(tbl.drop_date)=1
tbl.sunadd=tbl.Sun_add
tbl.sunmult=tbl.Sun_mult
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sat_add=0
tbl.satmult=1
case dow(tbl.pup_date)=7
tbl.sat_add=tbl.Sats_add
tbl.satmult=tbl.Sat_mult
tbl.b48m_f_add=0
tbl.b48mfmult=1
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
case toseconds(tbl.too_early)>toseconds(tbl.tim_pkd_up)
tbl.b48m_f_add=tbl.b48am_add
tbl.b48mfmult=tbl.b48am_mult
tbl.aftr5add=0
tbl.aftr5_mult=1
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
case toseconds(tbl.too_late)toseconds(tbl.drop_time)
tbl.b48m_f_add=tbl.b48am_add
tbl.b48mfmult=tbl.b48am_mult
tbl.holadd=0
tbl.holmult=1
tbl.sunadd=0
tbl.sunmult=1
tbl.sat_add=0
tbl.satmult=1
tbl.aftr5add=10
tbl.aftr5_mult=1
case toseconds(tbl.Too_late)
Comment