>I haven't tried any of the cool new stuff like ADO, DCOM, etc, and I would like to postpone that pleasure for as long as possible. Is there a way to share data form a plain vfp database without going to too much trouble?. I posted a similar question yesterday.
>
>I need to share data with two differente databases: an Informix residing on a UNIX server and an SQL on an NT server. No problem to read the data from there but, when the programs driving those databases (4GL and PowerBuilder) try to read data from the vfp database ODBC complains with the following message:
>
>"Invalid field definition 'DELETED()' in definition of index or relationship"
>
>I would hate to discover only now that I can read other apps data but that Iam not able to expose vfp's without major database modifications.

>>I vaguely remember a problem with indexing on a logical (the DELETED() function returns a logical) with some ODBC versions and VB; the solution I used when I ran into it was to redefine my tag on DELETED() to instead be on IIF(DELETED(),-1,0), with changes needed in my VFP SQL code to use the revised expression.

With an expression so built, will vfp be able to use the deleted() tag to optimize queries? In a previous occasion I had built into the stored procedures of the dbc a function, I don't remember the exact name, that accepted as parameters a column name even if it never used it

function FunnyDelete(colName)
return deleted()

No ODBC drivers then had problems with the tag. I just had to change my
deleted()tag with:

index on FunnyDelete(anyColumn) tag deleted

Is this the only way? I seem to remember that the deleted tag was not used in optimizations.



>>Which FoxPro ODBC driver are you using?

5.00.00414