System.Data.SQLite
Artifact Content
Not logged in

Artifact 8749ebd2513afcaa4d1b1a2d76e2921978d538cc:

Ticket change [8749ebd251] - Closed ticket [b400a24aab]: How to use REGEXP extension... plus 8 other changes by mistachkin 2019-08-10 23:34:50.
D 2019-08-10T23:34:50.481
J foundin 1.0.111.0
J icomment In\sorder\sto\suse\sthe\sREGEXP\sextension,\sit\smust\sbe\senabled\sfirst\s(i.e.\ssince\sit\sis\r\nan\sextension).\s\sThe\sfollowing\sC#\scode\ssnippet\sshows\sroughly\swhat\sis\srequired:\r\n\r\n<verbatim>\r\n\s\susing\s(SQLiteConnection\sconn\s=\snew\sSQLiteConnection())\r\n\s\s{\r\n\s\s\s\s\s\sconn.ConnectionString\s=\s"Data\sSource=:memory:;";\r\n\s\s\s\s\s\sconn.Open();\r\n\s\s\s\s\s\sconn.EnableExtensions(true);\r\n\s\s\s\s\s\sconn.LoadExtension("SQLite.Interop.dll",\s"sqlite3_regexp_init");\r\n\r\n\s\s\s\s\s\s//\r\n\s\s\s\s\s\s//\sFurther\scode\shere...\r\n\s\s\s\s\s\s//\r\n\s\s}\r\n</verbatim>
J login mistachkin
J mimetype text/x-fossil-wiki
J priority Medium
J resolution Works_As_Designed
J status Closed
J subsystem Connection
J title How\sto\suse\sREGEXP\sextension...
K b400a24aab4a529e80cabf6cdf815d8d6c9eadea
U mistachkin
Z 0d41b65711b69dc46cf0c10ed37d96b0