iOS cache how to clean

Hi
i have db sqlite but when i do select * from table erro show table no found and the table is in the db.

any idea what is this problem.

thanks

Hi
any idea way this error no such table: tbUser and the tables is on my sqlite db.

thanks

my code

Var SqlStr As Text
Var Rs As iOSSQLiteRecordSet
Var er As text

SqlStr=“Select * From tbUser Where Name=’” + User + “’ And Password=’” + Pass + "’ "

Try
Rs=App.DBConn.SQLSelect(SqlStr)
Catch e As iOSSQLiteException
//ErrorLabel.Text = e.Reason
er= e.Reason
Return true
End Try

If Rs.EOF=False Then

End If

See what tables your app can find with:

SELECT name AS table_name FROM sqlite_master WHERE type ='table' AND name NOT LIKE 'sqlite_%';

Thanks Rick
It show only one table and i have 5 tables

what is the problem ?

You are probably pointing to the wrong Database.

i chk that and is correct

Or you are pointing to some “other” DB “with only one table”, or your equipments are cursed by bad witches. And I don’t believe in witches. :smiley: Double check everything with care.

ok
thanks

problems is in /Users/alexiscolonlugo/Library/Developer/CoreSimulator/Devices/C86BAF5B-4918-468C-9966-705CA3DD88BA/data/Containers/Data/Application/0CC14690-5C77-426F-BE80-E06D354B7FD1/Documents/asambleaipd.sqlite

i change the name and it run so is in that location

i delete the file in the location and now works

thanks

Be careful with things depending on finding files previously put on place.

ok
thanks