UPDATE Problem
Posted: Tue Apr 15, 2008 8:23 am
CAN anybody pls tell me where is the problem with the following UPDATE SQL-
UPDATE Month_Rent SET rent_date='4/15/2008', gas ='sd', swearage ='sd', water ='sd', elec_100 ='sd', elec_400 ='sd', elec_service_a-d ='sd', elec_service_e-h ='sd', elec_demand ='sd', elec_vat ='sd' WHERE rent_id='4-2008'
I have 11 fields(including PK) all of which is of VARCHAR type except the rent_date(date type)
UPDATE Month_Rent SET rent_date='4/15/2008', gas ='sd', swearage ='sd', water ='sd', elec_100 ='sd', elec_400 ='sd', elec_service_a-d ='sd', elec_service_e-h ='sd', elec_demand ='sd', elec_vat ='sd' WHERE rent_id='4-2008'
I have 11 fields(including PK) all of which is of VARCHAR type except the rent_date(date type)