Hi!

If you meant SQL Server - no. SQL Server have its own language. It has less functions than in VFP and most of them do not match to VFP functions.

It is recommended to organize your application very accurately. Read several article at the fox.wikis.com and other sites related to migrating VFP application to SQL Server or other server. You will see how much problems it cause.

However, there is a good approach for this.

First of all, organize your application to use only views and never use tables directly.

Never create a view that is based on the joined view and table at the same time. THis is not possible to do with remote views, so when moving to SQL you will have troubles.

Never use direct query (SQL statements) that use data from tables in the VFP code. Later, when moving, you will require to find and change all places where such queries used. This is related also to the query as a row source of combobox/listbox and as a record source for grid. Use view instead.

If you do not want to have 100+ views in the database (large number of views cause view opening from database slow), simple queries for lookups and other things you can do directly, but organize it another way. For example, in the code use function call "RunQuery('MySimpleQueryName','ResultAlias')". Implement that function (RunQuery) that will lookup a query string from the special table that contain query name and query string. Use "&" to run VFP query. Later, when you move to SQL Server, all changes that you require to do is just change this function: instead of running query as a VFP query by using "&", use SQLEXEC() function to run remote query. Of course, your table with queries will require to change all query strings to match the syntax required for remote backend. However, it is much more simple than just find all places in code and classs that run VFP query.

HTH.

>Hi Guys!
>
>I'm developing an application software using Visual Foxpro 7 and planning to migrate to SQL. Will the SQL recognize the functions of VFP& used in my current application?
>
>Thanks in advance...