System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: 8749ebd2513afcaa4d1b1a2d76e2921978d538cc
Ticket: b400a24aab4a529e80cabf6cdf815d8d6c9eadea
How to use REGEXP extension...
User & Date: mistachkin 2019-08-10 23:34:50
Changes

  1. foundin changed to: "1.0.111.0"
  2. icomment:
    In order to use the REGEXP extension, it must be enabled first (i.e. since it is
    an extension).  The following C# code snippet shows roughly what is required:
    
    <verbatim>
      using (SQLiteConnection conn = new SQLiteConnection())
      {
          conn.ConnectionString = "Data Source=:memory:;";
          conn.Open();
          conn.EnableExtensions(true);
          conn.LoadExtension("SQLite.Interop.dll", "sqlite3_regexp_init");
    
          //
          // Further code here...
          //
      }
    </verbatim>
    
  3. login: "mistachkin"
  4. mimetype: "text/x-fossil-wiki"
  5. priority changed to: "Medium"
  6. resolution changed to: "Works_As_Designed"
  7. status changed to: "Closed"
  8. subsystem changed to: "Connection"
  9. title changed to: "How to use REGEXP extension..."