Advanced SQL Command question

travin69@travin69

9 Posts

November 3, 2020, 8:28 pm

Hello all.

I am trying to use the advanced SQL command in DBPro and can't seem to get it to work. Table name and DB names are correct. Database format is 2003 Access. I have the most recent full version of Windows office.

dbpExecSQL "SCDB" "UPDATE Test_Parse |SET Extra_2 = 'Checklist'|Where Extra_2 IS NULL" ""

So, in DB SCDB, in table Test_Parse, I am trying to put the word "Checklist" in every field that is NULL.

Thanks for any help,

Daniel

rasl@rasl

39 Posts

November 4, 2020, 1:18 am

Check and ChekPoint are reserved words in sql, it may be that CheckList is being interpreted like this.
On the other hand being extra_2 text field I would add Where Extra_2 IS NULL OR Extra_2 = ''

Regards

travin69@travin69

9 PostsTopic Author

November 4, 2020, 1:28 am

Rasl,

Thanks for the help. I tried both options but still nothing. New code below:

dbpExecSQL "SCDB" "UPDATE Test_Parse |SET Extra_2 = 'Base'|Where Extra_2 IS NULL OR Extra_2 = ''" ""

Daniel

travin69@travin69

9 PostsTopic Author

November 4, 2020, 1:57 am

I stand corrected, it does work. Thanks for the help.

Daniel

juancarlos@juancarlos

92 Posts

January 13, 2021, 10:57 pm

travin69 no lo he probado pero si no lohas averiguado mira esto

UPDATE Test_Parse SET Extra_2 = 'Checklist'Where Extra_2='null'

Advanced SQL Command question - Forum

Advanced SQL Command question