Android Question How can we manage to INSERT and UPDATE for multiple tables ?

Itila Tumer

Active Member
Licensed User
Longtime User
Hello, I 'm trying to combine two table which is persons and body .
And I can entry the all values, but when I return to main and want to see on weblist as a table. I get error.
I dont know why?

In my Edit Activity :
INSERT INTO persons VALUES (NULL, ?, ?, ?, ?, ?, ?)

Query = "UPDATE persons Set FirstName = ?, LastName = ? FatherName = ? WHERE ID = " & IDList.Get( CurrentIndex)

How could I do multiple table for applying these?? with INNER JOIN

my main query is
Query = " SELECT persons.ID, persons.Sex, .Boy FROM persons INNER JOIN body ON persons.ID = body.IDbody "
 
Top