Android Question JobDone Problem

[DickyNAS]

I have to check for a given name in database via a sql statement by ExecuteRemoteQuery(Sql,Check_Existing_Friend) in httputils2 as follows:

Sql = "SELECT * FROM Friend WHERE Name = 'Chan Tai Main'"
Remark : Chan Tai Main is not in database. So I aware that web server will reply request with zero data.

Problem here :
Sub JobDone(job As Httpjob) seems no function by the zero data request but it functions by non-zero data request.
As a result, I cannot check for the job.success within sub jobdone.

My JobDone codes are belows:

Sub JobDone(job As Httpjob)
If job.Success Then
Dim Res As String
Dim parser As JSONParser
Res = job.GetString
parser.Initialize(Res)
Select job.JobName
Case Get_Friend
Positive case
...
Case Get_Relative
Positive case
...
Case Get_Pet
Positive case
...
End Select
Else
Select job.JobName
Case Get_Friend
Opposite case
...
Case Get_Relative
Opposite case
...
Case Get_Pet
Opposite case
...
End Select
End If
job.Release
End Sub

My main purpose is to do the Opposite case if zero data returned by web server.

Please help... Thanks.

 

[marcick]

I don't understand. Do you mean that you don't have JobDone event ?
Or do you have JobDone event but Job.success is false ?

 

[DickyNAS]

I don't understand. Do you mean that you don't have JobDone event ?
Or do you have JobDone event but Job.success is false ?

JobDone event not triggered

 

[marcick]

Sound strange to me that JobDone is not triggered, but, if true, maybe you can first check how many records with that name exists ?

Sql = "SELECT COUNT(*) FROM Friend WHERE Name = 'Chan Tai Main'"

The query is ExecQuerySingleResult type and should always return something

 

[Erel]

Please use [code]code here...[/code] tags when posting code.

Add a log message or put a breakpoint in JobDone. It must be raised if the job was started correctly.