Is there any way to get a single blank record returned from a query instead of no records at all? I have some "defines" that I want to appear, even when there are no records that match the WHERE criteria.

This message has been edited. Last edited by: Kerry,

Retracted: Try the following, after your DEFINE FILE MyFile:

TABLE FILE MyFile
PRINT REAL_FIELD NOPRINT
DEFINED_FIELD
WHERE RECORDLIMIT EQ 1
END

May I ask: Why do you want to do this? And, can you duplicate this with the CAR File?

This message has been edited. Last edited by: Doug,

If there are no records for the define to work on, then you are out of luck.

If you know that you will not have any records, say the previous TABLE FILE produced zero records, then you may be able to -WRITE a blank record to the HOLD file.

TABLE FILE CAR
PRINT COUNTRY
WHERE COUNTRY EQ 'England'
-*WHERE COUNTRY EQ 'ENGLAND'
ON TABLE HOLD AS TMP_CTY FORMAT ALPHA
END
-RUN

-IF &LINES GT 0 THEN GOTO NO_PRIME ;
-WRITE TMP_CTY  
-RUN
-NO_PRIME

DEFINE FILE TMP_CTY
 Error/A10 = IF COUNTRY EQ ' ' THEN 'Error' ELSE 'OK' ;
END

TABLE FILE TMP_CTY
PRINT COUNTRY Error
END

Good point Waz...
What was I thinking... Or was I? Which brings me back to my original questions: Why do you want to do this? And, can you duplicate this with the CAR File?

Basically: you need to work with something (as Waz pointed out) even if it's &RECORDS or &LINES...

MacLonghorn, Are you just testing for No Records Returned? If not, then what do you want to achieve?

I'm displaying HTML input tags for data entry. When it meets the criteria, there will be a value displayed. But it would be great to be able to handle "new" entries in the same call, maybe by modifying one of these defines?

DEFINE FILE CAR
	CTYFLD/A300 = '<input type="text" name="country" value="'||COUNTRY||'" />';
	CARFLD/A300 = '<input type="text" name="car" value="'||CAR||'" />';
END
TABLE FILE CAR
PRINT
	CTYFLD AS 'Country' OVER
	CARFLD AS 'Car'
WHERE COUNTRY EQ 'ENGLAND' AND CAR EQ 'JAGUAR'
ON TABLE SET PAGE-NUM NOLEAD
END

Mark,

SET EMPTYREPORT=ANSI will help you.

SET EMPTYREPORT=ANSI

TABLE FILE CAR
PRINT 
COUNTRY 
CAR
WHERE COUNTRY EQ 'England_1'
ON TABLE HOLD AS HLD_1 FORMAT ALPHA
END
-RUN
-*? STAT
-*?FF HLD_1
DEFINE FILE HLD_1
	CTYFLD/A300 = '<input type="text" name="country" value="'||COUNTRY||'" />';
	CARFLD/A300 = '<input type="text" name="car" value="'||CAR||'" />';
END
TABLE FILE HLD_1
PRINT
	CTYFLD AS 'Country' OVER
	CARFLD AS 'Car'
ON TABLE SET PAGE-NUM NOLEAD
END
-EXIT

Awsome, I'd forgotten about that one.

SET EMPTYREPORT = ON

Ram Prasad E and AlexU:
Yeah! Awesome! I know there are other, more inefficient ways of doing what I wanted, but I didn't want to have to duplicate a bunch of code just for a blank set of fields. Thanks a ton.

ON will not produce what is required it has to be ANSI if you want an empty data row returned