>Hi Every Body,
>
>I would like to know how can I use an SQL database within Visual Fox, should I creat foxpro database also or directly I can use SQL database ?
>
>I would like to use SQL database directly. I do not like to use ODBC because it slows the system.
>
>any idea ? I will be happy to get answers on this issue.
>
>thanks
>Hisham Serry
Hisham,
You might create a VFP database and define remote views or use SPT (SQL pass through). In either case you'd be using ODBC.
Another alternative is to use OLEDB and ADO. This would need more understanding and conversion in cases.
For a discussion about them and speed diference check wiki site (
http://fox.wikis.com/wc.dll?Wiki~CategoryClient/Server) ODBC way might be the one you're looking for.
Cetin