This content has been marked as final. Show 3 replies
1) Set up an ODBC data source in the Windows "Data Sources(ODBC)" control panel ?
2) Connected via the following connection url, eg. if you named your odbc datasource "myDBF",
the jdbc url should be "jdbc:odbc:myDBF"
That's the main difference between reading dBase files, and a standard JDBC data source.
If you're not getting any SQLExceptions from executeUpdate(), then it worked.
Check result, it is the number of rows updated.
Have you actually checked your data ?
Execute "select * from mon_sta where ZDATE_ENT = 111111111"... see if there's any results.
If not, then you're trying to update a record that doesn't exist / conform to your where clause.