>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.

Which FoxPro ODBC driver are you using?

>
>Can anybody help, please?
>
>TIA