# New columns in sqlt\_sc and sqlt\_wq

**URL:** <https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673>\
**Category:** Ignition\
**Created:** [June 20, 2012, 8:38pm UTC](https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673 "2012-06-20T20:38:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [June 20, 2012, 8:38pm UTC](https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673/1 "2012-06-20T20:38:31Z")

</div>

in sqlt\_sc there is execflags  
in sqlt\_wq there is propname and typeclass

What are these columns used for and what can/should they be set to if we are creating our own SQLTags?

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [June 21, 2012, 12:01am UTC](https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673/2 "2012-06-21T00:01:38Z")

</div>

I was just schooled by Colby on this, so here goes

The execfalgs define how a scan class should execute. For example:

```
                    0x1= one-shot
                    0x2= polled read or read data mode
                    0x3= both scan classes are selected

```

The propname refers to the tag property to write to (tag prop enum)  
The data type, which is also the typeclass, is the type of value to write (DataTypeClass)  
Int = 0, Float/Double = 1, Str = 2

I hope this helps, and I am sure that if I butchered it too much he will correct me. He also referred to this  
[files.inductiveautomation.com.s3 … \_guide.pdf](http://files.inductiveautomation.com.s3.amazonaws.com/guides/sqltags_custom_driver_guide.pdf)

I will be giving this a read, he also mentioned that he needs to update it as well.

---

<div class="post-metadata">

**Author:** ![Robert](https://avatars.discourse-cdn.com/v4/letter/r/e95f7d/32.png) [@Robert](https://forum.inductiveautomation.com/u/Robert)\
**Post date:** [June 21, 2012, 3:53pm UTC](https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673/3 "2012-06-21T15:53:53Z")

</div>

Thanks Greg,

The reason I posted was because these fields are not in that document. 🙂

---

<div class="post-metadata">

**Author:** ![greg.simpson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/greg.simpson/32/3135_2.png) [@greg.simpson](https://forum.inductiveautomation.com/u/greg.simpson)\
**Post date:** [June 21, 2012, 4:00pm UTC](https://forum.inductiveautomation.com/t/new-columns-in-sqlt-sc-and-sqlt-wq/4673/4 "2012-06-21T16:00:43Z")

</div>

Yeah, I figured as much. Thats why Colby said he needed to update that document.