# Using Prop:SQLRowSet on Dynamic File Driver

**URL:** <https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221>\
**Category:** questions\
**Tags:** drivers, sql, c10\
**Created:** [June 7, 2024, 7:37am UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221 "2024-06-07T07:37:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![xxetfxx](https://clarionhub.com/user_avatar/clarionhub.com/xxetfxx/32/5215_2.png) [@xxetfxx](https://clarionhub.com/u/xxetfxx)\
**Post date:** [June 7, 2024, 7:37am UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221/1 "2024-06-07T07:37:06Z")

</div>

> [@Clarion 10.11897](https://clarionhub.com/t/clarion-10-11897/440/1):
>
> You can now use PROP:SQLRowSet with the Dynamic file driver

Has anyone managed to make it running?  
I have this code, tried but doesn't build the structure when prop:sqlrowset is used, but no errorcode or fileerrorcode

```clarion
   MyDynamicFile &= NEW(FILE)
   MyDynamicFile{PROP:Driver} = 'ODBC'
   MyDynamicFile{PROP:DriverString} = '\TURBOSQL=TRUE'
   MyDynamicFile{PROP:Owner} = GLO:SQLConnectString
   OPEN(MyDynamicFile)
   IF SUB(CLIP(LEFT(p_SQLQuery)),1,4) = 'WITH'
      MyDynamicFile{PROP:SQLRowSet} = p_SQLQuery
   ELSE
      MyDynamicFile{PROP:SQL} = p_SQLQuery
   END
   FIXFORMAT(MyDynamicFile)
   !map columns
   DO DeepAssignColumns

```

Kind Regards,  
Christian

---

<div class="post-metadata">

**Author:** ![FominTools](https://clarionhub.com/user_avatar/clarionhub.com/fomintools/32/3634_2.png) [@FominTools](https://clarionhub.com/u/FominTools)\
**Post date:** [June 18, 2024, 7:35pm UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221/2 "2024-06-18T19:35:08Z")

</div>

That’s true. I changed **{prop:SQL}** to **{prop:SQLRowSet}** in **DynFile.CreateFromSQL** PROCEDURE ( **DynFile.clw** ) and **FillVirtualListBox.sln** example still works fine with predefined SQL **SELECT** queries against [Northwind](https://github.com/microsoft/sql-server-samples/blob/master/samples/databases/northwind-pubs/instnwnd.sql) sample database.

Unfortunately, following [CTE](https://learn.microsoft.com/en-us/sql/t-sql/queries/with-common-table-expression-transact-sql) and [stored procedure](https://learn.microsoft.com/ru-ru/sql/t-sql/language-elements/execute-transact-sql) queries fail with errorcode 80 “_Unsupported File Diver Function_” using either {prop:SQL} or {prop:SQLRowSet} with Dynamic File Driver

```auto
WITH q (Records) AS (SELECT COUNT(*) FROM Products) SELECT * FROM q

```

```auto
exec dbo.CustOrderHist 'VINET'

```

---

<div class="post-metadata">

**Author:** ![Gustavo\_Saracca](https://clarionhub.com/user_avatar/clarionhub.com/gustavo_saracca/32/5355_2.png) [@Gustavo\_Saracca](https://clarionhub.com/u/Gustavo_Saracca)\
**Post date:** [February 16, 2026, 12:37pm UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221/3 "2026-02-16T12:37:19Z")

</div>

I still don’t understand why it doesn’t work if it works with regular SQL. It would be great if SV added support for this, as it’s becoming increasingly common.

There has to be some flag in the driver.

---

<div class="post-metadata">

**Author:** ![JonW](https://clarionhub.com/user_avatar/clarionhub.com/jonw/32/1344_2.png) [@JonW](https://clarionhub.com/u/JonW)\
**Post date:** [February 16, 2026, 1:05pm UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221/4 "2026-02-16T13:05:37Z")

</div>

No idea what the problem with the Dynamic driver is, but PROP:SQLRowSet is exactly that: it’s a flag. It tells Clarion: even if this doesn’t look like a query that returns a rowset (because it doesn’t start with SELECT) , it really is, so you have to set up a place for the results to be stored.