>Database who can work in native dbf file and sql server all in one source code.
>
> best regrads

So you want to define a view in a VFP DBC that will either get its data from Fox tables or SQL Server tables based on a runtime setting? I don't know of any way to do that since the view definition in the dbc must identify the FROM data at the time you create the view. You could use a CREATE VIEW command in your code to create the view at runtime and in that way you could determine where the data was coming from when you create the view.

Either that or you could not use a view in a dbf and rather use SELECT statements in your code that could either issue the SELECT command in VFP or use SPT to do an SQLExec() with the SELECT command sending it to SQL Server. Of course using the later method would mean you would need to code the data updates yourself as well.