Android Question RDC - Returning alias from MySQL sp is ignored

achtrade

Active Member
Licensed User
Longtime 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
Longtime User
like this ?:

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