Android Question RDC SQL LIKE Operator

[Bladimir Silva Toro]

Hello friends

I am developing an application in B4A connected directly to SQL Server using RDC,
following the link: https://www.b4x.com/android/forum/t...connector-rdc-connect-to-any-remote-db.31540/

The query in SQL Server is the following:

The query is in the RDC Config file:

The query is executed in the RDC log

The problem I have is when I use the LIKE operator in a SELECT query, in the smartphone it shows all the records and that query should only return 5 records


Thank you for your assistance

 

[Erel]

Why are you using RDC instead of jRDC2?

 

[Bladimir Silva Toro]

Hi Erel

1. I thought that jRDC2 was only for B4J and not for B4A

2. The examples I found are only for B4J

That's the reason why I use RDC

I would appreciate it if you can give me an example using jRDC2 (SQL Insert and Select operators)

Thank you very much for your help

 

[sorex]

what about replacing

like '%?%'

with

in ('?')

?

the wildcards are then gone.

 

[Bladimir Silva Toro]

what about replacing

like '%?%'

with

in ('?')

?

the wildcards are then gone.

Hi sorex

Make the change you tell me the sql query was like this:

SELECT NIT, Suc, Name, Address, City, LP, Seller_ID FROM Customers WHERE Name in ('?')

When executing it in the SmartPhone it does not return any record

 

[sorex]

it seems that the value is not stored where the ? is

 

[Jorge M A]

Maybe you want use SQL Server Profiler in your server, and monitor the sentence received by DB Engine.

 

[Bladimir Silva Toro]

Maybe you want use SQL Server Profiler in your server, and monitor the sentence received by DB Engine.

Hi Jorge MA

Look, I did the test in the SQL Server Profiler

Here are the results:

Performing the query with the IN operator in SQL Server Mannagent Studio does not show any record, see image:

The problem seems to be in the LIKE operator, all the other queries I do work well.

Thank you

 

[sorex]

oh wait, you do a search in larger content. IN is mainly to match a non wildcard string.

my bad, sorry.

 

[Jorge M A]

@Bladimir Silva Toro,
Try the same with the LIKE operator. Make sure the percent signs ('%value%') arrive to the server. If not, enclose with double quote.

 

[Bladimir Silva Toro]

@Jorge M A

It seems that the wildcard (?) Sent from the RDC's config file does not send anything to the LIKE operator in the SQL Server Database. See the image of the SQL Server Profiler

If I do this same query in the SQL Server Mannagent Studio, the same result is returned which returns all the records in the table, see the image

The idea is that you can use the operator like the wildcard (?) Should send this to the database engine.

Thank you

 

[Jorge M A]

This is not the way that MS SQL works. The quotation mark (?) defines the PARAMETER substitution to be used.
But your issue is not MS SQL, but in JDBC driver and the PREPARED statement. JDBC is out of my experience.
maybe you want read the official documentation here.

 

[Bladimir Silva Toro]

As I read to change from RDC to jRDC2 it is just change the DBRequestManager.bas file in my B4A, I have read this information in: https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

Is this correct ? or what other change should I make?

Thank you very much

 

[Bladimir Silva Toro]

Hi @Erel

As I read to change from RDC to jRDC2 it is just change the DBRequestManager.bas file in my B4A, I have read this information in: https://www.b4x.com/android/forum/t...-rdc-remote-database-connector.61801/#content

Is this correct ? or what other change should I make?

Thank you very much

 

[OliverA]

As to your like issue, see https://stackoverflow.com/a/8248052

 

[Erel]

You shouldn't use RDC. It was replaced by jRDC2.

or what other change should I make?

Also update the link. It ends with /rdc

Note that there is a newer DBRequestManager that can be used with Wait For and is simpler to use.

 

[Bladimir Silva Toro]

Hi @Erel

I have already started jRDC2 connected with MS SQL Server, the test works fine.

You have an example of the B4A client connected to a MySQL or SQL Server database by jRDC2?

Thank you very much.

 

[DonManfred]

You have an example of the B4A client connected to a MySQL or SQL Server database by jRDC2?

Check the rdc b4a example. Calling rdc2 is the same....

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

Check the migration notes from RDC to RDC2 in this post.