Click here to Skip to main content
15,911,646 members
Home / Discussions / Visual Basic
   

Visual Basic

 
QuestionLineShape control not moving freely with cursor Pin
for120622-Feb-10 0:05
for120622-Feb-10 0:05 
AnswerRe: LineShape control not moving freely with cursor Pin
Dave Kreskowiak22-Feb-10 3:26
mveDave Kreskowiak22-Feb-10 3:26 
GeneralRe: LineShape control not moving freely with cursor Pin
for120622-Feb-10 17:09
for120622-Feb-10 17:09 
GeneralRe: LineShape control not moving freely with cursor Pin
Dave Kreskowiak22-Feb-10 17:42
mveDave Kreskowiak22-Feb-10 17:42 
GeneralRe: LineShape control not moving freely with cursor [modified] Pin
for120622-Feb-10 19:02
for120622-Feb-10 19:02 
GeneralRe: LineShape control not moving freely with cursor Pin
Dave Kreskowiak23-Feb-10 1:10
mveDave Kreskowiak23-Feb-10 1:10 
GeneralRe: LineShape control not moving freely with cursor Pin
for120623-Feb-10 1:17
for120623-Feb-10 1:17 
QuestionUsing "LIKE" Pin
EvanSaunders21-Feb-10 21:12
EvanSaunders21-Feb-10 21:12 
Hey All

I am having difficulty running a specific SQL statement in VB and was wondering if there is a way around it.
The problem I am having involves using "LIKE":
e.g. SELECT * FROM Table WHRE Field1 LIKE 'start*' (where start is the start of any text taken in as a parameter).
When I program an SQL statement like in VB, it won't yield the results I am looking for. I tested the code within SQL Server and MS Access Database and it works fine, but when I try again in the VB program, it yields no values.
The code does, however, work for "WHERE Field1 LIKE 'start'". So that means it has a problem with accepting the hash as part of the SQL query. I even tried using the VB character set within the SQL, but that too doesn't work.

Is there a way around this, or does VB not make use of the hash for an SQL statement?
Seems very weird to me.

Thanks for the help in advance! Thumbs Up | :thumbsup:
AnswerRe: Using "LIKE" Pin
Wayne Gaylard21-Feb-10 21:30
professionalWayne Gaylard21-Feb-10 21:30 
GeneralRe: Using "LIKE" Pin
EvanSaunders21-Feb-10 21:39
EvanSaunders21-Feb-10 21:39 
GeneralRe: Using "LIKE" Pin
JustWorking21-Feb-10 21:46
JustWorking21-Feb-10 21:46 
AnswerRe: Using "LIKE" Pin
JustWorking21-Feb-10 21:33
JustWorking21-Feb-10 21:33 
GeneralRe: Using "LIKE" Pin
EvanSaunders21-Feb-10 21:42
EvanSaunders21-Feb-10 21:42 
AnswerRe: Using "LIKE" Pin
Dave Kreskowiak22-Feb-10 3:21
mveDave Kreskowiak22-Feb-10 3:21 
QuestionAutodetect Pin
JustWorking21-Feb-10 20:30
JustWorking21-Feb-10 20:30 
AnswerRe: Autodetect Pin
Anubhava Dimri22-Feb-10 0:55
Anubhava Dimri22-Feb-10 0:55 
GeneralRe: Autodetect Pin
JustWorking22-Feb-10 1:27
JustWorking22-Feb-10 1:27 
GeneralRe: Autodetect Pin
Anubhava Dimri22-Feb-10 1:48
Anubhava Dimri22-Feb-10 1:48 
GeneralRe: Autodetect Pin
JustWorking22-Feb-10 2:15
JustWorking22-Feb-10 2:15 
QuestionGenerating datas in GridView and export to Excel [modified] Pin
John.L.Ponratnam21-Feb-10 19:39
John.L.Ponratnam21-Feb-10 19:39 
AnswerRe: Generating datas in GridView and export to Excel Pin
Paramu197321-Feb-10 23:05
Paramu197321-Feb-10 23:05 
Questionpause and resume the execution upon finding a certain character in a textfile. Pin
xiah_junsu21-Feb-10 16:06
xiah_junsu21-Feb-10 16:06 
AnswerRe: pause and resume the execution upon finding a certain character in a textfile. Pin
Dave Kreskowiak22-Feb-10 3:15
mveDave Kreskowiak22-Feb-10 3:15 
GeneralRe: pause and resume the execution upon finding a certain character in a textfile. Pin
xiah_junsu22-Feb-10 16:42
xiah_junsu22-Feb-10 16:42 
GeneralRe: pause and resume the execution upon finding a certain character in a textfile. Pin
Dave Kreskowiak22-Feb-10 17:42
mveDave Kreskowiak22-Feb-10 17:42 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.