Hi Gary,

There's ";" (semicilon) is missing at the end of the second line.
BTW, you don't need macro substitution in SQLEXEC()

= sqlexec(fics, sqlselect,'lender_office')

>I am trying to use the following code. Each time I run this code I get an error of unrecognized command or keyword. I must be looking at the problem but can't see it.
>
>Any help will be appreciated.

>sqlselect = "Select lender_offices.lend_offc_name, " + ;
>                    "lender_offices.lend_offc_identifier, "+
>                    "loan_mortgagor_info.loan_id "+;
>            "From loan_mortgagor_info, lender_offices " + ;
>           "Where loan_mortgagor_info.loan_id = "+sqlkey + ;
>       " and lender_offices.lend_id = loan_mortgagor_info.orig_lend_id " + ;
>   "and lender_offices.lend_offc_id = loan_mortgagor_info.orig_lend_offc_id" 		
>= sqlexec(fics,'&sqlselect','lender_office')