Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sql select problem
Message
 
 
To
05/08/2003 10:25:57
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00816857
Message ID:
00816860
Views:
20
Gary,

Try this:
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')
I did notice that you missed a couple of ; on the end of some of your lines.

I hope this helps!!
Neil Lewis
IT R&D Manager
Velmore Ltd
Previous
Reply
Map
View

Click here to load this message in the networking platform