Android Question ANDROID QUERY

[Gabriel Sam]

rs.setDatabase("SAM,1433","CCPoSRestaurant","sa","96241822726890838")
rs.Query("Select * From Login where Password = '" & txtPin.Text & "'")
Msgbox(rs.TableList,"")
If LastException.IsInitialized=False Then
Msgbox("Invalid Pin","")
Else
For i = 0 To lv.Size
Msgbox(lv.Get(i),"")
Next
i NEED TO CHECK WHETHER THE ABOVE CODING IS CORRECT FOR SEARCH PASSWORD.

 

[lemonisdead]

i NEED TO CHECK WHETHER THE ABOVE CODING IS CORRECT FOR SEARCH PASSWORD.

in fact it is false : you have to count from the Login database where the login and password do match
SELECT COUNT FROM Login WHERE ....

If you get 0 then Login and Password don't match. If you get 1 then its ok

 

[eps]

Be careful of case sensitive text as well - I'm sure it will work as you expect it, but don't assume that it will - worth checking when testing.

 

[Gabriel Sam]

Thanks for the Reply.
I have typed the Code
Dim cnt As Int

rs.setDatabase("SAM,1433","CCPoSRestaurant","sa","96241822725842541")
cnt = rs.Query("SELECT COUNT FROM Login WHERE password = '" & txtPin.Text & "'")
Msgbox(cnt,"")
But I am not getting the Message Box . Please Advice.

 

[DonManfred]

I suggest to go over the sql tutorial
https://www.b4x.com/android/forum/threads/sql-tutorial.6736/

 

[Gabriel Sam]

The above tutorial use to open the db file, but my Database is on Server Sam.1433. And I got stuck on Line
cnt=rs.query("SELECT COUNT ....
Please Help ....

 

[DonManfred]

The above tutorial use to open the db file, but my Database is on Server Sam.1433. And I got stuck on Line

You can not connect to a remote database using the sql object. It is only for connecting to a sqlite database on the device.

To connect to a remote database you need to setup an RDC (Remote DatabaseConnector). jRDC2 is the newest release.
Search the forum for jRDC2
It is a B4J app which you must run on your server. See the RDC tutorial onn how to connect to your RDC and get data from your DB.

 

[Gabriel Sam]

I am Dummy How to use JRDC2 in Android as I am expert in VB.NET. Please Help !!

 

[DonManfred]

I am Dummy How to use JRDC2 in Android

Serch the forum, check the tutorials. check the docu.

 

[OliverA]

You can not connect to a remote database using the sql object. It is only for connecting to a sqlite database on the device.

I think he is using the MSSQL library located here. I'm just guessing though, since not a lot of info is given by the originating author. If that's the case, the first post on the library page has the following code fragment:

db = setDatabase("Server IPNUMBER (not name)","databasename","username","password")

With some code fragments in other posts showing:

a.setDatabase("IPADDRESS\SQLEXPRESS:port","DATABASENAME","USERNAME","PASSWORD")

So first of all I don't think the author is able to connect, since the connection string is not correct.

Also, @Erel says the following several times in that particular library thread:

the correct solution is to avoid using the library.

 

[OliverA]

rs.setDatabase("SAM,1433","CCPoSRestaurant","sa","96241822726890838")

I hope you just didn't post the real SA credentials for the MSSQL database you're working on. Just saying...