Android Question RDC SQL LIKE Operator

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 5, 2018

• #2

Why are you using RDC instead of jRDC2?

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #3

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

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Jan 5, 2018

• #4

what about replacing

like '%?%'

with

in ('?')

?

the wildcards are then gone.

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #5

sorex said:

what about replacing

like '%?%'

with

in ('?')

?

the wildcards are then gone.

Click to expand...

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

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Jan 5, 2018

• #6

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

 

Upvote 0

Jorge M A

Well-Known Member

Licensed User

Longtime User

• Jan 5, 2018

• #7

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

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #8

Jorge M A said:

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

Click to expand...

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

 

Upvote 0

S

sorex

Expert

Licensed User

Longtime User

• Jan 5, 2018

• #9

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

my bad, sorry.

 

Upvote 0

Jorge M A

Well-Known Member

Licensed User

Longtime User

• Jan 5, 2018

• #10

@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.

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #11

@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

 

Upvote 0

Jorge M A

Well-Known Member

Licensed User

Longtime User

• Jan 5, 2018

• #12

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.

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #13

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

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 5, 2018

• #14

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

 

Upvote 0

OliverA

Expert

Licensed User

Longtime User

• Jan 5, 2018

• #15

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

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Jan 7, 2018

• #16

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

Bladimir Silva Toro said:

or what other change should I make?

Click to expand...

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.

 

Upvote 0

Bladimir Silva Toro

Active Member

Licensed User

Longtime User

• Jan 8, 2018

• #17

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.

 

Upvote 0

DonManfred

Expert

Licensed User

Longtime User

• Jan 8, 2018

• #18

Bladimir Silva Toro said:

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

Click to expand...

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.

 

Last edited: Jan 8, 2018

Upvote 0