Originally Posted by copeg
first of all.. i do not want to read a file and update database with the information in the file.. i am making a text file as my application database.. connecting using jdbcodbc driver .. connecting the the file and running an query is successful
but i tried to update data in my text file using SQL UPDATE statement and unfortunately it didn't work out..
and the error occur as i have mentioned in my first post. So i thought there must be any way using any of file manipulation Class that can do something like this
1. get the field first value
2. update the second value which is the second column based on the value of the first column
but i don't have any idea how to do that.. or can UPDATE statement can be used to update the data in my text file??