Ignition Vision : Add multiple names in SQL database

Hi everyone,

I'm trying to add a few customer names, as highlighted in the attached snapshot, using the EDIT function in SQL Database query browser tool.

I tried adding them using " , " and also tried inserting "OR" between customer names but none worked so far. Any suggestions would be helpful.

Thank You.

This looks like a custom table specific to your project, in which case we have zero context for what this table does (aside from what we can glean from the fieldnames and data) and how it's being used.

At first glance, it would appear that Customer and/or CustomerReference holds the link to a single customer. In this case, you would need to add multiple rows, one for each customer. If your graphics/scripts/etc. don't handle this however, then you'll have to accommodate for this as well.

We'll need more context for how this table is used to help more usefully. Pretend we don't know anything about your project apart from what you tell us (because we don't)

2 Likes