Android Question Types do not match

[David Elkington]

Hi Everyone,

I have some code below (2nd line) that seems to have an underline saying types do not match, I can't see why, and it does not seem to work... It just freezes the app and I can't see where it goes

Sub InsertLolerRequest
    
    Dim cmd As DBCommand = CreateCommand("insert_req_loler_31298", Array(1,0,1,Main.lngLolerKitID))
    Dim j As HttpJob = CreateRequest.Executebatch(cmd, Null)
    Wait For(j) JobDone(j As HttpJob)
    If j.Success Then
        Log("Inserted successfully!")
    End If
    j.Release
end sub

Any help would be appreciated, writing in b4a 10.0

 

[Erel]

It just freezes the app and I can't see where it goes

A type error can never freeze the app. If the app freezes then there is a different problem.

The second line is empty. You probably mean line #4.

See the correct way to call ExecuteBatch in the tutorial: https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

 

[David Elkington]

Hi Erel,

That tutorial is where I got the code from, I just adapted the createcommand in line 3 to insert into my table on SQL Server.

The SQL side is as below

sql.insert_req_loler_31298=INSERT INTO tbl_system_requests(sys_type_ID,sys_status,sys_parm_1,sys_parm_2) VALUES (?,?,?,?);

 

[Erel]

That tutorial is where I got the code from

No.

 

[David Elkington]

Thanks, I put array around it, but it still shows the underline...

 

[David Elkington]

It appears it is not waiting.... If I put in some code and add a break point in JobDone, it goes through and pauses there. Is there a reason why it would not wait and then execute the lines below? I checked the SQL table, and it is actually writing to the table ok.

 

[Erel]

Lest start with the warning. You should upload a small project with the code that causes this warning.

 

[David Elkington]

Thats the issue, my project is enormous now after 5 years of development on it.

 

[David Elkington]

I get this now on compile, perhaps there is an issue here...

B4A Version: 10.0
Java Version: 8
Parsing code. (0.59s)
Building folders structure. (0.06s)
Compiling code. (3.21s)
Compiling layouts code. (0.42s)
Organizing libraries. (0.00s)
(Android Support Library)
Generating R file. (0.00s)
Compiling debugger engine code. (1.48s)
Compiling generated Java code. Error
B4A line: 1077
Dim j As HttpJob = CreateRequest.Execute
javac 1.8.0_131
src\b4a\riskassessment\loler_audit.java:2535: error: incompatible types: String cannot be converted to httpjob
_j = (b4a.riskassessment.httpjob)(_createrequest()._executebatch /*String*/ (null,anywheresoftware.b4a.keywords.Common.ArrayToList(new Object[]{(Object)(_cmd)}),anywheresoftware.b4a.keywords.Common.Null));

 

[emexes]

1/ Click on ExecuteBatch in IDE, see what the hint help says it returns. Error indicates is returning String, which is usually the default if not otherwise specified. Should be As HttpJob.

2/ Make sure ExecuteBatch is defined in your project, probably in file DBRequestManager.bas from:

https://www.b4x.com/android/forum/t...ation-of-rdc-remote-database-connector.61801/

Public Sub ExecuteBatch(ListOfCommands As List, Tag As Object) As HttpJob
    Dim j As HttpJob = CreateJob
    ExecuteBatchImpl(j, ListOfCommands, Tag)
    Return j
End Sub

 

[David Elkington]

My public sub did not have the As HttpJob on the end, but I have not changed anything, do you think I am on an old version somehow? Mine is as below, looks nothing like yours

Public Sub ExecuteBatch(ListOfCommands As List, Tag As Object)
    Dim ser As B4XSerializator
    ser.Tag = Tag
    ser.ConvertObjectToBytesAsync(CreateMap("commands": ListOfCommands,  "version": VERSION), "ser")
End Sub

 

[Erel]

You are using an old version.

 

[David Elkington]

Where would I get the new version? I thought it was built in, I am on B4A v10.0?

 

[Erel]

[B4X] jRDC2 - B4J implementation of RDC (Remote Database Connector)

DBRequestManager is a class that you added to your project.

 

[David Elkington]

Ah yes, I did look at your attachment of DBRequest, but it says b4j = true, so I thought it was not for b4a