SQL statment - WHERE clause - General topics, questions and discussions - Jabaco

HardDrive

Beginner

Posts: 12

Date of registration: Sep 22nd 2009

Location: London

Occupation: IT Consultant

Hobbies: inline skating, chess

1

Tuesday, September 22nd 2009, 3:17pm

SQL statment - WHERE clause

Hi
Trying to get data out of a database using where clause but at no avail.
This simple example one works:
res = Database1.ExecuteStatement("SELECT * FROM INDEXDB1 WHERE IFIELD1='" & Text1.Text & "'")
but when using using the next example, does not work:
res = Database1.ExecuteStatement("SELECT * FROM INDEXDB1 WHERE IFIELD1 Like '" & Text1.Text & "'")
HELP
Please
Thank you

Go to the top of the page

A1880

Intermediate

Posts: 500

Date of registration: Jan 1st 2009

Location: Hanover, Germany

Occupation: Software Engineer

Hobbies: Hilbert Curves

2

Tuesday, September 22nd 2009, 3:37pm

Hi,
you could try to display possible SQL warnings:

	Source code
1 2 3 4 5 6 7 8 9	Dim sqlw As SQLWarning ... rs = Database1.ExecuteStatement(query) sqlw = Database1.Parent.getWarnings If sqlw <> Null Then MsgBox "SQL-Warning: " & sqlw.getMessage() End If