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