Hi Karen,
>I Have Client/server application,that works in sql7.0 and vfp 6.0.In Select from vfp to sql server I have Case ... When structure.Now I want,that my application work only in vfp,without sql.When I converting sql7.0 database to vfp6.0 database and connect from odbc driver for vfp the application can't execute the Select with Case When structure.
>I must change select ... when structure,or that possible to work in vfp sqlexec command ?
VFP doesn't have a CASE ... WHEN structure. This a SQL-Server command. Use nested IIF(...) statements instead.
Regards,
Armin