RE: database SELECT SYNTAX

[dkfire]

Before doing your select statement, have you selected the database to use ?

Try to make a small vi that demonstrate what you are doing and post it here.

[SteveChandler]

Edit: I didn't see your other post so the semicolon is probably not the problem. What does the server error log say?

[Yamaeda]

select top 1 id from SensoresIR1 order by id desc

/Y

[ChrisReed]

Just going back to your original post where your SQL statement didn't work the reason is as follows...

SELECT id FROM SensoresIR1 WHERE id=36151  = ERROR!

SELECT id FROM SensoresIR1 WHERE id='36151'  = GOOD

ie. you just need to put apostrophes around the value that you want to search for - this syntax will work of MySQL and MS SQL databases.

Chris

[SteveChandler]

---

@Chris Reed wrote:

ie. you just need to put apostrophes around the value that you want to search for - this syntax will work of MySQL and MS SQL databases.

Chris

---

nomade42k, I would be interested to hear from you if that worked. You do not have to quote numeric datatypes although you can. I can not speak to MySQL or MS SQL as I only use PostgreSQL. I know that MySQL has some funky syntax. Is id a string? That would totally explain the error

The reason I did not think it was a string is because you said it is automatically assigned by the server which implies it is an integer sequence.

[nomade42k]

Hello!

here I leave you my block VI and the DB with its columns (in spanish)

It still doesn´t work...

[SteveChandler]

I think you need to quote your time string. I don't know if MySQL uses single or double quotes.

[SteveChandler · Accepted solution]

After looking at this some more I notice you are using the select vi. You are sending the entire SQL statement to the where clause input. There is a vi under advanced called 'execute query' which you will want to use when you are building the statement yourself. The select just requires the table input and an array of columns.

Try something like this. You may need to change the quote from single to double (or remove the quote if the DB tools is smart enough to quote the parameters. I have never used it)

[Onin]

Err message disapears after add 'where' in my case 😉

[Yamaeda]

---

@Onin wrote:

Err message disapears after add 'where' in my case 😉

---

If memory serves, the Select function adds Where automatically (if the string is not empty), so you'll get a double Where in this case.

/Y