Hi,
we are using remote views to store new records into an Oracle databases and
we have a very special case where the tableupdate(.T.,.T.,"tabla") command
is rejecting the insertion of records, please note that this trouble arises
just in one of the two workstations we are using for the development, and as
a fact, both computers are succesfully updating oracle databases on three
different Oracle database servers and the trouble happens only on the fourth
Oracle server
both workstationss are using VFP 6.0 installed from the same CD
to eliminate application bugs we have tested direcctly from the command
window the following
Use "remote view"
replace key_fields with 99999
?tableupdate(.T.,.T.,"remote view") ----> this returns .F.
if after this, we execute again the use "remote view" command, we get an
error message that says that we can not insert a reciord with null values..
we have confirmed for sure that there are absolutely no restrictions for
NULL values in the Oracle database... this is a specific workstation trouble
we have verified that we have the same settings for the DSN in the MS
Windows ODBC sources
we are using the same Oracle8 ODBC driver
I would appreciate any suggestion of what to compare between both
workstations in order to diagnose and fix this trouble
thanks in Advance
Oscar Taboada