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 "
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 "