Hi, I´m using rawSQL plugin to write on an access table that is maintained by other application. I´m using the JDBC from hxtt.
The reason I´m using rawSQL is that if I create a new record with foundset.newRecord() and then save the data I get an error telling that there is a problem with referential integrity.
I know that if a referential integrity problem arises, writing with rawSQL might compromise the other application, but the truth is that there should not be any referential integrity error because that table does not have any relation. In fact I did something to try to find which field could be doing that problem: I got a record that was already in that table, modified som fileds and save it again; of course I did not get any error so what I tried is creating a new record and put all the values that the record that works has, except of course the PK. I still have the error.
Anyway using rawSQL works, but I have a little problem with that. After a do the insert-sql I also do a flushAllClientsCache(), as recommended, but I can not see the data in access until I close the developer.
am I doing anything wrong?
Thanks in advance.