B4J Question Search Sql

[RobRock92]

How do I check that the inserted record is the only one??

Thanks

 

[giga]

If it is SQLlite, you could go into the SQLite expert program and look at the table directly. Just in testing. Or the android SQLite viewer http://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/#content

 

[RobRock92]

If it is SQLlite, you could go into the SQLite expert program and look at the table directly. Just in testing. Or the android SQLite viewer http://www.b4x.com/android/forum/threads/android-sqlite-viewer.9197/#content

I'm looking for a method, with the message box , which does not allow the user to add the record if equal..

 

[BPak]

ExecQuerySingleResult (Query As String) As String

Check if data exists by using ExecQuerySingleResult

Executes the query and returns the value in the first column and the first row (in the result set).
Returns Null if no results were found.

Before saving the record use a unique field to check if record already exists:

Dim NumberOfMatches As Int
NumberOfMatches = SQL1.ExecQuerySingleResult("SELECT count(*) FROM table1 WHERE col2 = 300")

If NumberOfMatches > 0 then record already exists.

 

[RobRock92]

ExecQuerySingleResult (Query As String) As String

Check if data exists by using ExecQuerySingleResult

Executes the query and returns the value in the first column and the first row (in the result set).
Returns Null if no results were found.

Before saving the record use a unique field to check if record already exists:

Dim NumberOfMatches As Int
NumberOfMatches = SQL1.ExecQuerySingleResult("SELECT count(*) FROM table1 WHERE col2 = 300")

If NumberOfMatches > 0 then record already exists.

Thanks and you know a method for use the scroll pane in b4j?the scroll doesn't work

 

[Erel]

Please start a new thread for the scrolling question. v1.50 does support ScrollPane.