# \#sql **URL:** https://clarionhub.com/tag/sql/8.md [Latest](https://clarionhub.com/latest.md) · [Categories](https://clarionhub.com/categories.md) · [Tags](https://clarionhub.com/tags.md) --- ## [Initinal value somtimes null sometimes empty](https://clarionhub.com/t/initinal-value-somtimes-null-sometimes-empty/9456)
**Author:** [@Dirk1](https://clarionhub.com/u/Dirk1)\ **Replies:** 11\ **Last updated:** [October 29, 2026, 7:30am UTC](https://clarionhub.com/t/initinal-value-somtimes-null-sometimes-empty/9456 "2026-10-29T07:30:31Z")
Hi All, Inserting a new record from a browse/form can initially save a specific field sometimes with null and sometimes with "empty". The field is not touched in the form. I get the idea this has to do with the last sav… --- ## [An article about company per DB vs in table](https://clarionhub.com/t/an-article-about-company-per-db-vs-in-table/5376)
**Author:** [@seanh](https://clarionhub.com/u/seanh)\ **Replies:** 9\ **Last updated:** [October 13, 2026, 12:20am UTC](https://clarionhub.com/t/an-article-about-company-per-db-vs-in-table/5376 "2026-10-13T00:20:21Z")
An article about company per DB vs in table I found interesting on stackoverflow Multi-tenant solutions range from one database per tenant (shared nothing) to one row per tenant (shared everything). "Shared nothing", "… --- ## [How to avoid SQL injection risks](https://clarionhub.com/t/how-to-avoid-sql-injection-risks/8967)
**Author:** [@PurpleEdge2214](https://clarionhub.com/u/PurpleEdge2214)\ **Replies:** 14\ **Last updated:** [March 2, 2026, 11:37am UTC](https://clarionhub.com/t/how-to-avoid-sql-injection-risks/8967 "2026-03-02T11:37:30Z")
How does one avoid SQL injection risks, in Clarion, apart from using a SQL function and passing parameters to the function? --- ## [Get SUM from MSSQL in Clarion](https://clarionhub.com/t/get-sum-from-mssql-in-clarion/8946)
**Author:** [@rob\_bac](https://clarionhub.com/u/rob_bac)\ **Replies:** 17\ **Last updated:** [February 19, 2026, 3:35pm UTC](https://clarionhub.com/t/get-sum-from-mssql-in-clarion/8946 "2026-02-19T15:35:06Z")
Maybe a simple question, but i miss the clue. I have a MSSQL file, where i want to total a field, between two dates (LOC:DAT1 and LOC:DAT2) In SSMS it’s simple: SELECT SUM(fil:field) FROM file WHERE (LOC:DAT1\>=fil:dat… --- ## [Using Prop:SQLRowSet on Dynamic File Driver](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221)
**Author:** [@xxetfxx](https://clarionhub.com/u/xxetfxx)\ **Replies:** 3\ **Last updated:** [February 16, 2026, 1:05pm UTC](https://clarionhub.com/t/using-prop-sqlrowset-on-dynamic-file-driver/7221 "2026-02-16T13:05:37Z")
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 MyDynamicFile &= NEW(FILE) MyDynamicFile{PROP:Driver}… --- ## [Clarion 12 - Prop:Filter and SQL()](https://clarionhub.com/t/clarion-12-prop-filter-and-sql/8894)
**Author:** [@AlexBerg](https://clarionhub.com/u/AlexBerg)\ **Replies:** 14\ **Last updated:** [January 14, 2026, 12:48am UTC](https://clarionhub.com/t/clarion-12-prop-filter-and-sql/8894 "2026-01-14T00:48:51Z")
After updating to Clarion 12. My browses suddenly showed no records. I use {Prop:Filter} = ‘SQL(Emp\_Number \> 100)’ That works fine when only having one Join on the view. But when more than one Join is used something go… --- ## [Load the browse empty or full with data?](https://clarionhub.com/t/load-the-browse-empty-or-full-with-data/3539)
**Author:** [@Clarion\_clarion](https://clarionhub.com/u/Clarion_clarion)\ **Replies:** 11\ **Last updated:** [January 6, 2026, 2:24pm UTC](https://clarionhub.com/t/load-the-browse-empty-or-full-with-data/3539 "2026-01-06T14:24:27Z")
Is there s simple way the browse screen will either load empty or full with data (according to some parameter)? If load empty then filtered locator will be used to show subset of data. ABC, standard browse, sql databa… --- ## [PROP:Disconnect question](https://clarionhub.com/t/prop-disconnect-question/8879)
**Author:** [@blue](https://clarionhub.com/u/blue)\ **Replies:** 2\ **Last updated:** [December 27, 2025, 6:14pm UTC](https://clarionhub.com/t/prop-disconnect-question/8879 "2025-12-27T18:14:38Z")
Hello, I read it in help about this property, but just to make it sure 100% - to close connection to SQL server I need to close all files and then on one file use SomeFile{PROP:Disconnect}? --- ## [Bug with VIEW and PROJECT that SQL SELECT has extra Fields from Keys?](https://clarionhub.com/t/bug-with-view-and-project-that-sql-select-has-extra-fields-from-keys/8874)
**Author:** [@Koen](https://clarionhub.com/u/Koen)\ **Replies:** 4\ **Last updated:** [December 23, 2025, 4:36pm UTC](https://clarionhub.com/t/bug-with-view-and-project-that-sql-select-has-extra-fields-from-keys/8874 "2025-12-23T16:36:29Z")
I think I found a bug, but I am not sure. Might be found earlier but I never noticed before. I have this view defined: ViewARS VIEW(ARules) PROJECT(ARS:ARuleID) P… --- ## [Using BUFFER while updating records possible?](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872)
**Author:** [@Koen](https://clarionhub.com/u/Koen)\ **Replies:** 2\ **Last updated:** [December 22, 2025, 4:09pm UTC](https://clarionhub.com/t/using-buffer-while-updating-records-possible/8872 "2025-12-22T16:09:39Z")
Another question on the use of the BUFFER() statement. When looping on a view the use of BUFFER is very useful to improve speed. I never tried that for a loop over a table. Now I am considering doing that while updating… --- ## [How to use BUFFER()?](https://clarionhub.com/t/how-to-use-buffer/8854)
**Author:** [@Koen](https://clarionhub.com/u/Koen)\ **Replies:** 27\ **Last updated:** [December 19, 2025, 11:21am UTC](https://clarionhub.com/t/how-to-use-buffer/8854 "2025-12-19T11:21:28Z")
I have browse procedure that can contain 130 000 records if only the minimum filter is set (customerID en date). Right now I am using the I am playing with the BUFFER() statement as BUFFER(500) The loading takes a wh… --- ## [Error S1010 in a MySQL Browse](https://clarionhub.com/t/error-s1010-in-a-mysql-browse/4780)
**Author:** [@Martin\_Queirolo](https://clarionhub.com/u/Martin_Queirolo)\ **Replies:** 6\ **Last updated:** [December 10, 2025, 1:49pm UTC](https://clarionhub.com/t/error-s1010-in-a-mysql-browse/4780 "2025-12-10T13:49:09Z")
Maybe the same thing happened to someone. I am using the Fuzzy Matching template in a Browse and it throws me a "Record Retrieval Error" Error in the function sequence (S1010) attempting to access a record from the "Tabl… --- ## [SQL Server Requiring a Certificate After Install of Latest MSSQL Studio](https://clarionhub.com/t/sql-server-requiring-a-certificate-after-install-of-latest-mssql-studio/8843)
**Author:** [@Kevin](https://clarionhub.com/u/Kevin)\ **Replies:** 2\ **Last updated:** [December 8, 2025, 3:51pm UTC](https://clarionhub.com/t/sql-server-requiring-a-certificate-after-install-of-latest-mssql-studio/8843 "2025-12-08T15:51:46Z")
Using Clarion 11 with MSSQL database driver for several years. Last week, a client updated MSSQL Studio to the latest version on a workstation. Since then, when they first sign in to our application, the SQL Server retur… --- ## [Replacing Clarion side view by SQL side view worth the effort?](https://clarionhub.com/t/replacing-clarion-side-view-by-sql-side-view-worth-the-effort/8822)
**Author:** [@Koen](https://clarionhub.com/u/Koen)\ **Replies:** 24\ **Last updated:** [December 4, 2025, 3:51pm UTC](https://clarionhub.com/t/replacing-clarion-side-view-by-sql-side-view-worth-the-effort/8822 "2025-12-04T15:51:13Z")
I have a process that does a lot of read and write actions to the database which is time consuming. It is a loop over a table with a few joins to other tables. So it is working with Clarion side views which is already an… --- ## [Better specs for SQL Express 2025](https://clarionhub.com/t/better-specs-for-sql-express-2025/8792)
**Author:** [@Jane](https://clarionhub.com/u/Jane)\ **Replies:** 3\ **Last updated:** [November 19, 2025, 12:51pm UTC](https://clarionhub.com/t/better-specs-for-sql-express-2025/8792 "2025-11-19T12:51:57Z")
SQL Express 2025 lifts the cap on individual databases to 50GB. (Still restricted to 1 socket or 4 cores). --- ## [SQL column datatype uniqueindentifier](https://clarionhub.com/t/sql-column-datatype-uniqueindentifier/2442)
**Author:** [@jm.cruz](https://clarionhub.com/u/jm.cruz)\ **Replies:** 8\ **Last updated:** [November 4, 2025, 11:06pm UTC](https://clarionhub.com/t/sql-column-datatype-uniqueindentifier/2442 "2025-11-04T23:06:16Z")
I have an sql table with the datatype uniqueidentifier and i want to update the table2 with the datatype uniqeindentifier with the code from the table1. relationship: table1 \<----\> table2 When i made the insert in the … --- ## [MariaDB - Odd Issue](https://clarionhub.com/t/mariadb-odd-issue/8746)
**Author:** [@RSchofield](https://clarionhub.com/u/RSchofield)\ **Replies:** 6\ **Last updated:** [November 3, 2025, 2:58pm UTC](https://clarionhub.com/t/mariadb-odd-issue/8746 "2025-11-03T14:58:51Z")
I have a really odd issue with one table for a project I am working on. It is a MariaDB database. The table in Clarion: YEAR\_OPTIONS FILE,DRIVER('ODBC',OWNER(gConnectionString),NAME('wp\_year\_options'),PRE(Y… --- ## [Using variables inside \`VIEW\` \`JOIN\` expression causes weird results](https://clarionhub.com/t/using-variables-inside-view-join-expression-causes-weird-results/8640)
**Author:** [@ThaDaSoft](https://clarionhub.com/u/ThaDaSoft)\ **Replies:** 11\ **Last updated:** [October 13, 2025, 12:42pm UTC](https://clarionhub.com/t/using-variables-inside-view-join-expression-causes-weird-results/8640 "2025-10-13T12:42:11Z")
Quick question - is the use of BIND variables supported in the JOIN expression? Because for some reason, when I do, I only get a single record back while I now it should return multiple - if I invert the order I get eve… --- ## [To connect to MSSQL 2022 on windows server](https://clarionhub.com/t/to-connect-to-mssql-2022-on-windows-server/8680)
**Author:** [@Edvard\_Korsbaek](https://clarionhub.com/u/Edvard_Korsbaek)\ **Replies:** 3\ **Last updated:** [October 9, 2025, 8:38pm UTC](https://clarionhub.com/t/to-connect-to-mssql-2022-on-windows-server/8680 "2025-10-09T20:38:13Z")
I can set the manager op with my user, but i need to tick the "“Trust server certificate”. To do the same from my program, I have tried: TryConnect ROUTINE GLO:DBOwner = CLIP(LOC:Server) & ',' & CLIP(LOC:Database) &… --- ## [Deadlocks on MSSQL](https://clarionhub.com/t/deadlocks-on-mssql/8639)
**Author:** [@Bjarne\_Havnen](https://clarionhub.com/u/Bjarne_Havnen)\ **Replies:** 18\ **Last updated:** [October 3, 2025, 1:39pm UTC](https://clarionhub.com/t/deadlocks-on-mssql/8639 "2025-10-03T13:39:20Z")
I have a deadlock problem and I am not sure how to solve it. Sometimes I belive I have done anything I can do to stop them from working on the same data, perhaps it is just Clarion's way, or SQL server, I see from logs… --- ## [How to update table records (data correction) in Clarion 8](https://clarionhub.com/t/how-to-update-table-records-data-correction-in-clarion-8/8635)
**Author:** [@Ankit\_Purohit](https://clarionhub.com/u/Ankit_Purohit)\ **Replies:** 6\ **Last updated:** [September 25, 2025, 11:39pm UTC](https://clarionhub.com/t/how-to-update-table-records-data-correction-in-clarion-8/8635 "2025-09-25T23:39:21Z")
Hi all, I am working in Clarion 8 and need to perform some data correction in a table (for example, updating fields where values are currently 0). What is the recommended approach in Clarion 8 for updating table data p… --- ## [Installer updated for the DCT2SQL templates and Documentation](https://clarionhub.com/t/installer-updated-for-the-dct2sql-templates-and-documentation/8595)
**Author:** [@RobertoArtigas](https://clarionhub.com/u/RobertoArtigas)\ **Replies:** 0\ **Last updated:** [September 12, 2025, 11:16pm UTC](https://clarionhub.com/t/installer-updated-for-the-dct2sql-templates-and-documentation/8595 "2025-09-12T23:16:00Z")
Greetings - Improved the DCT2SQL Templates and Documentation. You can get the installer here Documentation Areas Improved Check and Verify the dictionary templates. Can be used even if you are not converting to S… --- ## [SQLite? Where does it fit?](https://clarionhub.com/t/sqlite-where-does-it-fit/8129)
**Author:** [@johan\_rademan](https://clarionhub.com/u/johan_rademan)\ **Replies:** 24\ **Last updated:** [September 10, 2025, 3:37am UTC](https://clarionhub.com/t/sqlite-where-does-it-fit/8129 "2025-09-10T03:37:02Z")
Hi, Never gave SQLite a thought, always thought when I jump to SQL it would be postgres. 5 desktop users working on windows server 2022 in data centre via RDP + a NTWS , on the same dataset The NTWS might ramp up to q… --- ## [Bandwidth Throttling from a Clarion app to Cloud Server or Dept SQL Server](https://clarionhub.com/t/bandwidth-throttling-from-a-clarion-app-to-cloud-server-or-dept-sql-server/8567)
**Author:** [@RchdR](https://clarionhub.com/u/RchdR)\ **Replies:** 0\ **Last updated:** [September 5, 2025, 11:16am UTC](https://clarionhub.com/t/bandwidth-throttling-from-a-clarion-app-to-cloud-server-or-dept-sql-server/8567 "2025-09-05T11:16:32Z")
Has anyone tried to do bandwidth throttling to a cloud server or dept SQL server before? If so any pointers, besides using a firewall to force the issue? I'd like to be able to limit by Meter and maybe using the Backgr… --- ## [CW SQL Query Add-on](https://clarionhub.com/t/cw-sql-query-add-on/7650)
**Author:** [@Bostjan\_Laba](https://clarionhub.com/u/Bostjan_Laba)\ **Replies:** 5\ **Last updated:** [September 4, 2025, 8:08am UTC](https://clarionhub.com/t/cw-sql-query-add-on/7650 "2025-09-04T08:08:15Z")
I would like my app to have sort of procedure which would act as a SQL query script editor. Meaning I would type some SQL query, execute it, see results (error, updated, table from select). I would protect this proc to b… --- ## [Dictionary Synchronizer Wizard](https://clarionhub.com/t/dictionary-synchronizer-wizard/3056)
**Author:** [@DonnEdwards](https://clarionhub.com/u/DonnEdwards)\ **Replies:** 3\ **Last updated:** [May 2, 2025, 11:47am UTC](https://clarionhub.com/t/dictionary-synchronizer-wizard/3056 "2025-05-02T11:47:10Z")
In Lesson 7 - Dictionary Synchronization there is a section as follows: Create an SQL Database Definition Starting Point: The \\SyncLesson\\Master.dct is open and you have a valid SQL based target in mind. 1.In the DC… --- ## [SQL Trace Log Oddness](https://clarionhub.com/t/sql-trace-log-oddness/8036)
**Author:** [@totalhip](https://clarionhub.com/u/totalhip)\ **Replies:** 3\ **Last updated:** [March 27, 2025, 2:30am UTC](https://clarionhub.com/t/sql-trace-log-oddness/8036 "2025-03-27T02:30:15Z")
Why would a trace file NOT include an Insert statement but would include a Delete statement? Both are to the same Postgres table. Test has been repeated multiple times with changes coded to a click of a button. --- ## [Slowness in SQL C11.1 vs C9](https://clarionhub.com/t/slowness-in-sql-c11-1-vs-c9/8031)
**Author:** [@tmcdonald](https://clarionhub.com/u/tmcdonald)\ **Replies:** 3\ **Last updated:** [March 26, 2025, 7:51pm UTC](https://clarionhub.com/t/slowness-in-sql-c11-1-vs-c9/8031 "2025-03-26T19:51:06Z")
We have just completed upgradeing our main application from C9 to C11.1 We use SAP Sybase ASE SQL as our database and have for ever. The only change is the version of Clarion. We are running exact same codeset, same … --- ## [SQLROWSET with CALL SP() gets error 90 syntax error](https://clarionhub.com/t/sqlrowset-with-call-sp-gets-error-90-syntax-error/7926)
**Author:** [@Niels\_Larsen](https://clarionhub.com/u/Niels_Larsen)\ **Replies:** 7\ **Last updated:** [February 20, 2025, 9:50am UTC](https://clarionhub.com/t/sqlrowset-with-call-sp-gets-error-90-syntax-error/7926 "2025-02-20T09:50:03Z")
Hi I know it has been discussed before but I can't really find a solution to my particular challenge. The challenge actually consists of two things. The syntax for the call and the smartest way to solve it. I need to… --- ## [Invalid Record Declaration (47) on MariaDB table](https://clarionhub.com/t/invalid-record-declaration-47-on-mariadb-table/7919)
**Author:** [@RSchofield](https://clarionhub.com/u/RSchofield)\ **Replies:** 10\ **Last updated:** [February 18, 2025, 7:55am UTC](https://clarionhub.com/t/invalid-record-declaration-47-on-mariadb-table/7919 "2025-02-18T07:55:04Z")
I am trying to access a MariaDB table in a database. I have access to most of them, but there are a couple that I am having problems. I am getting The declaration in Clarion 11 ENGINE\_CODE\_YEARS FILE,DRIVER('… [Next page](https://clarionhub.com/tag/sql/8.md?match_all_tags=true&page=1&tags%5B%5D=sql)