imbault pls log in with membership no 14926 and password 12345678 to check if you wish. Yet query will return null for the password in the returned cursor even though browsing the dba will show the value of 12345678
Pardon me, but the db gets actually opened and the record with that membership no and password gets fetched. The issue is in the result set - some fields bring back values while a few return null! But these are not null as can be confirmed by viewing with sqlite browser. So why do they get returned as null?
Thanks Erel for your comments. Will learn from them. I must be doing something wrong cos I set pword_ass as 12345678 for membership no 14926 while testing. The value showing above for pword_ass, pword_set and svrid all show as null on my log! What will my problem stem from? Thanks
Thanks to Erel and Klaus. I noted the index and made the correction Klaus pointed out. But still. Attached is the screen shot of the np content copied and pasted into notepad to wrap it around as it was too long
Dim curs2 As Cursor = SQL1.ExecQuery2("SELECT * FROM membersinfo WHERE MembershipNo =?",Array As String(edtMemNo.Text))
For i = 0 To curs2.RowCount - 1
curs2.Position = i
For c = 0 To curs2.ColumnCount - 1
Log(curs2.GetColumnName(c) & ": " & curs2.GetString2(c))
This is wrong too! mp.Put( "pword_ass", values(10))
It must be mp.Put( "pword_ass", values(9))!!!
values(10) is pword_set and not pword_ass.
The column numbers begin with 0 not with 1!
Are you sure that the database you are using is the same as in the Assets folder?
I get this with Erels code:
fullname: ABDULSALAM AHMAD ABUBAKR
official_add: BURSARY DEPARTMENT, KADUNA POLYTECHNIC
residential_add: NO. 22A BISAU CRESCENT NORTH, MALALI LOW COST, KADUNA
email: Not Available
duesos: 45500 pword_ass: 12345678
154,14926,ABDULSALAM AHMAD ABUBAKR,CNA,803514056,BURSARY DEPARTMENT, KADUNA POLYTECHNIC,NO. 22A BISAU CRESCENT NORTH, MALALI LOW COST, KADUNA,Not Available,45500,12345678,NA,1
Thanks Erel. Thanks Klaus. It is now working!!! I had it open in a browser for sqlite which maintained some sort of copy I suppose. Compacting and closing that and removing older copy from the emulator and syncing a few times from file manager - all due to eliminate compatibility/ corruption issues worked. Attached is screenshot showing the result. Thanks for the wonderful responses and support.