SELECT *
FROM landlords
WHERE landlordno = #landlordno#
UPDATE apartmentinfo
SET aptsetupdate = #createodbcdate(now())#,
apartmentname = '#apartmentname#',
apartmentstreet = '#apartmentstreet#',
apartmentcity = '#apartmentcity#',
apartmentstate = '#apartmentstate#',
apartmentzip = '#apartmentzip#',
apartmentemail = '#apartmentemail#',
apartmentphone = '#apartmentphone#',
officehoursmf = '#officehoursmf#',
officehourssat = '#officehourssat#',
officehourssun = '#officehourssun#',
description = '#description#',
directions = '#directions#',
leaseterms = '#leaseterms#',
nounits = #nounits#,
yearbuilt = #yearbuilt#,
yearremodeled = #yearremodeled#,
dwellingtype = '#dwellingtype#',
sendemail = '#sendemail#',
propertytitle = '#propertytitle#',
apartmentcontact = '#apartmentcontact#',
managementname = '#managementname#'
WHERE listingno = #listingno#
DELETE FROM rentalrates
WHERE listingno = #listingno#
INSERT INTO rentalrates (listingno, bedroomsize, rentmin, rentmax, sqft, baths)
valueS (#listingno#, '#evaluate("bedroomsize#loopcount#")#', #rentmin#, #rentmax#, '#evaluate("sqft#loopcount#")#', '#evaluate("baths#loopcount#")#')
UPDATE specials
SET specials1 = '#specials1#',
specials2 = '#specials2#',
specials3 = '#specials3#',
specials4 = '#specials4#',
specials5 = '#specials5#'
WHERE listingno = #listingno#
UPDATE apartmentfeatures
SET airconditioning = '#airconditioning#',
cableready = '#cableready#',
fireplace = '#fireplace#',
ceilingfans = '#ceilingfans#',
disabilityaccess = '#disabilityaccess#',
patiobalcony = '#patiobalcony#',
basiccable = '#basiccable#',
privacyfence = '#privacyfence#',
alarmsystem = '#alarmsystem#',
extrastorage = '#extrastorage#'
WHERE listingno = #listingno#
UPDATE communityfeatures
SET highspeedinternet = '#highspeedinternet#',
businesscenter = '#businesscenter#',
laundryfacility = '#laundryfacility#',
playground = '#playground#'
WHERE listingno = #listingno#
UPDATE petpolicy
SET petsunder25 = '#petsunder25#',
catsallowed = '#catsallowed#',
dogsallowed = '#dogsallowed#'
WHERE listingno = #listingno#
UPDATE appliances
SET dishwasher = '#dishwasher#',
washerdryerhookups = '#washerdryerhookups#',
washerdryer = '#washerdryer#',
microwave = '#microwave#',
garbagedisposal = '#garbagedisposal#'
WHERE listingno = #listingno#
UPDATE recreation
SET clubhouse = '#clubhouse#',
fitnesscenter = '#fitnesscenter#',
swimmingpool = '#swimmingpool#',
tenniscourt = '#tenniscourt#',
racquetball = '#racquetball#',
joggingpath = '#joggingpath#',
jucuzzisspa = '#jucuzzisspa#',
sandvolleyball = '#sandvolleyball#',
basketball = '#basketball#'
WHERE listingno = #listingno#
UPDATE vehicletransportation
SET coveredparking = '#coveredparking#',
gatedentrance = '#gatedentrance#',
garage = '#garage#',
publictransportation = '#publictransportation#',
freewayaccess = '#freewayaccess#'
WHERE listingno = #listingno#
UPDATE orderinfo
SET cctype = '#cctype#',
ccfirstname = '#ccfirstname#',
cclastname = '#cclastname#',
ccphone = '#apartmentphone#',
ccstreet = '#ccstreet#',
cccity = '#cccity#',
ccstate = '#ccstate#',
cczip = '#cczip#',
ccexpiration = '#ccexpiration#',
ccamount = #ccamount#,
expirationdate = #expirationdate#,
listinglevel = '#listinglevel#',
renewalrate = '#renewalrate#',
pricinglevel = '#pricinglevel#',
ipaddress = '#ipaddress#',
transactionid = '#transactionid#',
ccexpmonth = '#ccexpmonth#',
ccexpyear = '#ccexpyear#',
ccnumber = #ccnumber#
WHERE orderno = #orderno#