Android Question RDC - Returning alias from MySQL sp is ignored

achtrade

Active Member
Licensed User
Hello community

I have a MySQL SP with this sentence:

select t0.id, t0.Status as `UserStatus`, t1.Status as `PassStatus` from Users t0 inner join Pass t1 on t1.idUser = t0.id;

In the MySQL Workbench I'm getting the correct info:
--------------------------------|
|id | UserStatus | PassStatus|
|1 | A |A |
--------------------------------|
But in the JobDone sub
B4X:
Dim result As DBResult = reqManager.HandleJob(Job)
result is getting this:
id=1, Status=A, null=A

It's like the alias of the select 'UserStatus' and 'PassStatus' are ignored.

How can I fix it without modify my tables?

Thanks.
 

achtrade

Active Member
Licensed User
like this ?:

B4X:
JdbcUrl=jdbc:mysql://localhost/use15?characterEncoding=utf8?useOldAliasMetadataBehavior=true
 

achtrade

Active Member
Licensed User
No, it didn't work. I had to change my sp to this:

select ifnull('-1', '-1') as 'id';
 
Top