>I am using the Microsoft ODBC for Oracle to insert the record from VFP table to Oracle table. The problem I have is I am sending 108 records but only 107 records insert into Oracle table and it is not missing the same record if I send the table again. Does anyone has the same problem as I have. My ODBC driver is date 7/26/2000. Does Microsoft have new ODBC release? I really need help. Any help or idea is welcome.
>
>Thanks, Tai Fei Pao
You did not tell, how did you do it
If through remote view, it by default has buff 3
and makes automatic update, when record is moved
For the last record, you have to make =tableupdate(.t.,.f.)
If you did it through sql path through, you may be had set manial transaction in sqlset prop or server was set to not autocommit mode.
If first, do sqlcommit(con)
if second sqlexec(con,'commit')
Best wishes, Vladimir
MVP-2006-2011, PHD in Math and Physics ,
host of
www.foxclub.ru,
VFP lector at Interface and Microinform companies
Head science researcher of VNIIA Rosatom.