April 21, 2005, 08:03 PM
MADDYCOMMA PROBLEM
HI GUYS,
I HAVE SQL QUERY WHICH RETURNS THE VALUES IN SUCH A WAY THAT IN THE FOCUS SIDE I GET FIELD NAMES SEPARATED BY COMMAS AND SOMETINES A NULL VALUE('') WHEN I TRY TO USE PRINT ITS GIVING ME ERROR AS INVALID FIELDNAME
FOR EX
TABLE FILE CAR
PRINT
''
CARNAME,CARMODEL
CARBRAND
END
WHERE CARNAME AND CARMODEL ARE MY FIELDNAMES
IS THERE ANY SET COMMAND OR EDIT FUNCTION IN FOCUS SO THAT IT TREATS '' AS NULL AND OVERLOOK COMMA AND TREAT IT AS SPACE BETWEEN FIELDS RATHER THEN AS COMMA
THANKS
MADDY
April 28, 2005, 08:32 PM
Francis MarianiWhat is the SQL query that results in null values and commas between field names?