Hi everybody,
I have this code:
lcBldgString = thisform.cBldgString
BLANK FIELDS &m.lcBldgString
lcBldgString is STATEUSE,CONDITION,BUILDSTYLE,YEARBUILT,RENOYEAR,CONSTCODE,NUMUNITS,CMMNAREA,
CONDOFLOOR,NUMFLOORS,GRBLDGAREA,LIVAREA,EXTCOVER,ROOFTYPE,ROOFMAT,ATTICAREA,
FFLOORAREA,BASMNTAREA,BASMUFAREA,BASMNTTYPE,TOTROOMS,BEDROOMS,BATHROOMS,
HALFBATHS,NUMFIREPL,HEATTYPE,FUELTYPE,PARKTYPE,NUMPARKSP,AMENITIES
All these fields exist in a table. Some of them may contain nulls. I get Syntax error on Blank Fields command. It worked correctly before. Do you see, what could be wrong in the above code?
Thanks in advance.
UPDATE If I try:
blank fields STATEUSE, CONDITION, BUILDSTYLE, YEARBUILT, RENOYEAR, CONSTCODE, ;
NUMUNITS, CMMNAREA, CONDOFLOOR, NUMFLOORS, GRBLDGAREA, LIVAREA, EXTCOVER, ;
ROOFTYPE, ROOFMAT, ATTICAREA, FFLOORAREA, BASMNTAREA, BASMUFAREA, BASMNTTYPE, ;
TOTROOMS, BEDROOMS, BATHROOMS, HALFBATHS, NUMFIREPL, HEATTYPE, FUELTYPE, ;
PARKTYPE, NUMPARKSP, AMENITIES
it works fine.
Oops, disregard. I see my problem. It's
m.lcString!!!!!!!!
If it's not broken, fix it until it is.
My Blog