how Wild card are used in sqlite

Question

0.00/5 (No votes)

See more:

This below query is not correctly working with sqlite weather with sql it works fine i am using vb.net

SQL

com.CommandText = "SELECT MAX(DocumentCode) AS DocumentCode FROM DocumentsHeader WHERE (DocumentCode LIKE @DocumentCode + '%')";
com.Parameters.Add("@DocumentCode", SqlDbType.NVarChar).Value = Passvalue.ToString().Trim();
returnvalue = com.ExecuteScalar();

Posted 20-Oct-15 9:36am

Malikdanish

Add a Solution

Comments

Richard MacCutchan 20-Oct-15 16:05pm

What does "is not correctly working" mean?

Malikdanish 20-Oct-15 16:14pm

My Database is having the record which is matched with wildcard % and it works fine but when i am woring with sqlite it does nt fetch the record from the db , I mean to say that This query works fine with SQL but with SQLITE it is not . about DB both DB Having 100 % same entries and same schema of DB as well

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

ZurdoDev · Answer 1 · 2015-10-20T10:31:00

Solution 1

Refer to this good article, http://www.techonthenet.com/sqlite/like.php[^]

It may be that you need single quotes around your DOcumentCode. What datatype is DocumentCode?

Posted 20-Oct-15 10:31am

ZurdoDev

Comments

Malikdanish 21-Oct-15 0:46am

It is of type nvarchar(255)

Richard MacCutchan · Answer 2 · 2015-10-20T11:05:00

Solution 2

This question is a duplicate of sqlite query syntax error with like operator[^]. Please do not post the same question more than once.

Posted 20-Oct-15 11:05am

Richard MacCutchan