I have another problem in using Oracle RDBMS as a back-end Server with VFP.
Most of tables in the Oracle database I'm working With have at least one Varchar data type in its primary Key field. When I tried to
Update remote view originated from those Oracle tables in my VFP project , all that I encountered was UPDATE CONFLICT.
I checked MS KB and found an article concerning that problem. MicroSoft mentioned that problem and provide temporary solution in
the Web. However I couldn't solve the problem with the tip MS provide and after a couple of trial I gave up. Actually VFP is not a
major tool in the whole system in my company, and I'm the lonely and only VFP developer , I didn't have to stick to it.
I've used VFP as a kind of OLAP tool concentrating on the VFP-specific functions such as sophistcated report , easy to use implementing
Graph, self-containing db engine.
To make it simple, there is a problem , at least in my case, using remote view with Oracle.
When doing the same work in Access, there wasn't .
Does anyone know the right answer for it.
Thanks in advance.
OCP8 DBA