Simple SQL not working

[vgarroc]

Hi all

I’m a beginner with Base and already crashed with my first SQL. But why?? I hope you could help me.
As you can see from the image, I have a table tbl_Radiator_Import which I populated with data from Calc. Some of the imported data have the text “Err:502” in the field PartName. (Side Note: cannot figure out why the data font on the table is black and unreadible).
I wrote a SQL statement to delete those records, but I get an error shown in the image. I tried with different types of quotation… but same error.
Many thanks for looking into this.

[Wanderer]

You must not use statements in the Query-designer. (It is only for queries…)
.
Use the Menu to open Tools->SQL and put the statement there (; not necessary).

[nn45]

@vgarroc

Thank you for the screen you have shown. It seems to me that I would have to make clear that the error pertains to CALC environment, and therefore I have to solve the spreadsheet first and thereafter do the passage to BASE once again. Of course I could not try to intervene in BASE issue as it is by now. Error 502 is intended as “Bad Gateway”; did you perhaps prior transferred your data to CALC from remote?

Regards

[RobertG]

Code in Tools → SQL should look like
DELETE FROM "tbl_Radiator_Import" WHERE "PartName" = 'Err:502'
It is masked the wrong way in the screenshot. Tablenames and Fieldnames all should be masked with ", text content should be masked with '.

[vgarroc]

Hi. Thank you for your reply. The Erro:502 came as I was manipulating the data in CALC with formulae. I could not come up with an easy method to get rid of those rows in CALC so I decided to import the sheet into Base and delete them there.

[vgarroc]

@Wanderer

Use the Menu to open Tools->SQL and put the statement there

This worked! Many thanks to all…