VFP and SQL Server

Tech-Archive recommends: Fix windows errors by optimizing your registry

I have a query tool that was written in FP/VFP. It works fine for the last 10
years in our application. Now we are moving from FoxPro backend to RDBMS, to
SQL Server in particular. We are using RV and SPT and VFP DAL for the data
connection. Unfortunately, ODBC can't convert such VFP keywords as EMPTY (for
any field type), ALLTRIM or ==.
Any ideas how we can convert the stored VFP queries to run them as SPT
without a lot of code changes?

Thanks,
Andrei
.

Relevant Pages

  • Re: MySql through ODBC driver problem
    ... System DNS ... but blips happen on occassion for me utilizing a ... no problem with SQL SPT ... > then tried your remote view in vfp again? ...
    (microsoft.public.fox.vfp.queries-sql)
  • Re: textbox behaviour
    ... VFP has a "legacy" of the old xBase mode of operation it has to also live ... > from standard windows textbox control. ... or moving by arrow keys (standard is moving ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Newbie to VFP wants advice converting FPD2.6 app
    ... You say you're coming from 2.6, but you don't say which platform. ... with the others that a re-write is in order, but even more so if you're ... Windows and also moving to VFP. ...
    (microsoft.public.fox.helpwanted)
  • Re: vfp database to SQL
    ... While moving the data is pretty easy, a lot depends on how your program was written as to how much work it is to change the VFP application. ... > into SQL database ... > is this possible without redesigning the whole software? ...
    (microsoft.public.fox.programmer.exchange)
  • Re: VFP and SQL Server
    ... How's the higher ed game treating you these days? ... > SQL Server in particular. ... ODBC can't convert such VFP keywords as EMPTY ... > Any ideas how we can convert the stored VFP queries to run them as SPT ...
    (microsoft.public.fox.programmer.exchange)