Hi Jodi
Are you looking for a way to only update the records where the column doesn't already hold a value?
If you are, here are a few suggestions:
In MapInfo Pro v2019, you can add a condition to your update statement for example using the new SQL Window. This lets you update specific records in a table determined by the condition.
In you example, it would be:
Update previous_ss_testing
Set CHMP = "11635"
Where CHMP = ""
In earlier versions of MapInfo Pro, you would have to do this using two statements; first, use a Select statement to get the records to be updated into a query table, and then use the Update statement to update these records:
Select * From previous_ss_testing
Where CHMP = ""
Into __TO__UPDATE NoSelect
Update __TO__UPDATE
Set CHMP = "11635"
It would be easiest to run these from the MapBasic window.
Let me know if I have missed the point
------------------------------
Peter Horsbøll Møller
Principal Presales Consultant | Distinguished Engineer
Precisely | Trust in Data
------------------------------
Original Message:
Sent: 09-22-2020 01:13
From: Jodi Turnbull
Subject: Sent from Snipping Tool
Is there a way to search string for a blank and replace with data? If I leave the search box empty it does not work. Alternatively is ther a way to populate the attributes column in bulk rather than having to cut and paste each one individually.
Thanks
Jodi