Besides the good references they already gave you, you might want to look at the VFP manual. Look for the following topics:
SQL Pass-Through
SQLCONNECT()
SQLEXEC()
SQLDISCONNECT()
Remote Views
CREATE SQL VIEW AS ...
And check the Fox Wiki:
http://fox.wikis.com/wc.dll?Wiki~SQLPass-Through~VFPhttp://fox.wikis.com/wc.dll?Wiki~RemoteViewsHTH
>>>>>>>>>>>>>>>>>>>>>>
> I am new with Visual Foxpro 6.0 . I am now developing the application with MS SQL 7.0 as the database for my application, and the connection to the database is through the ODBC.
> Is there any sample application on net?
>
> i facing the problem like, how to start the connection, whem should i start the connection. Should i create the remote view? or local view. i don't know the different.
>
> when print report, how do enter the sql statement?
>
> actually.. i don't know at all. i am very blur now. can anyone help?
>>>>>>>>>>>>>>>>>>>>>>