strsql

What does this error mean ? An insert/Update I make to another table of the same database works fine. An update to the table where the error occurs works fine, but an Insert command brings this error. With 2 other tools the same insert worked fine, only in b4j I get this error. B4X...

I have a table in access with a foreign key. I try to make an insert, but get an foreign key violation in b4J. With an other tool I can execute the sql without a problem. The problem is, I must pass the value Null. But some how it dont work in b4j. B4X: dim strSQL as string strSQL=" INSERT...