Class SQLite3
Syntax
public static class SQLite3
Methods
BindBlob(IntPtr, Int32, Byte[], Int32, IntPtr)
Declaration
public static extern int BindBlob(IntPtr stmt, int index, byte[] val, int n, IntPtr free)
Parameters
Returns
BindDouble(IntPtr, Int32, Double)
Declaration
public static extern int BindDouble(IntPtr stmt, int index, double val)
Parameters
Returns
BindInt(IntPtr, Int32, Int32)
Declaration
public static extern int BindInt(IntPtr stmt, int index, int val)
Parameters
Returns
BindInt64(IntPtr, Int32, Int64)
Declaration
public static extern int BindInt64(IntPtr stmt, int index, long val)
Parameters
Returns
BindNull(IntPtr, Int32)
Declaration
public static extern int BindNull(IntPtr stmt, int index)
Parameters
Returns
BindParameterIndex(IntPtr, String)
Declaration
public static extern int BindParameterIndex(IntPtr stmt, string name)
Parameters
Returns
BindText(IntPtr, Int32, String, Int32, IntPtr)
Declaration
public static extern int BindText(IntPtr stmt, int index, string val, int n, IntPtr free)
Parameters
Returns
BusyTimeout(IntPtr, Int32)
Declaration
public static extern SQLite3.Result BusyTimeout(IntPtr db, int milliseconds)
Parameters
Returns
Changes(IntPtr)
Declaration
public static extern int Changes(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
Close(IntPtr)
Declaration
public static extern SQLite3.Result Close(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
ColumnBlob(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnBlob(IntPtr stmt, int index)
Parameters
Returns
ColumnByteArray(IntPtr, Int32)
Declaration
public static byte[] ColumnByteArray(IntPtr stmt, int index)
Parameters
Returns
ColumnBytes(IntPtr, Int32)
Declaration
public static extern int ColumnBytes(IntPtr stmt, int index)
Parameters
Returns
ColumnCount(IntPtr)
Declaration
public static extern int ColumnCount(IntPtr stmt)
Parameters
Type |
Name |
Description |
IntPtr |
stmt |
|
Returns
ColumnDouble(IntPtr, Int32)
Declaration
public static extern double ColumnDouble(IntPtr stmt, int index)
Parameters
Returns
ColumnInt(IntPtr, Int32)
Declaration
public static extern int ColumnInt(IntPtr stmt, int index)
Parameters
Returns
ColumnInt64(IntPtr, Int32)
Declaration
public static extern long ColumnInt64(IntPtr stmt, int index)
Parameters
Returns
ColumnName(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnName(IntPtr stmt, int index)
Parameters
Returns
ColumnName16(IntPtr, Int32)
Declaration
public static string ColumnName16(IntPtr stmt, int index)
Parameters
Returns
ColumnString(IntPtr, Int32)
Declaration
public static string ColumnString(IntPtr stmt, int index)
Parameters
Returns
ColumnText(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnText(IntPtr stmt, int index)
Parameters
Returns
ColumnText16(IntPtr, Int32)
Declaration
public static extern IntPtr ColumnText16(IntPtr stmt, int index)
Parameters
Returns
ColumnType(IntPtr, Int32)
Declaration
public static extern SQLite3.ColType ColumnType(IntPtr stmt, int index)
Parameters
Returns
Config(SQLite3.ConfigOption)
Declaration
public static extern SQLite3.Result Config(SQLite3.ConfigOption option)
Parameters
Returns
EnableLoadExtension(IntPtr, Int32)
Declaration
public static extern SQLite3.Result EnableLoadExtension(IntPtr db, int onoff)
Parameters
Returns
Errmsg(IntPtr)
Declaration
public static extern IntPtr Errmsg(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
ExtendedErrCode(IntPtr)
Declaration
public static extern SQLite3.ExtendedResult ExtendedErrCode(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
Finalize(IntPtr)
Declaration
public static extern SQLite3.Result Finalize(IntPtr stmt)
Parameters
Type |
Name |
Description |
IntPtr |
stmt |
|
Returns
GetErrmsg(IntPtr)
Declaration
public static string GetErrmsg(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
Initialize()
Declaration
public static extern SQLite3.Result Initialize()
Returns
LastInsertRowid(IntPtr)
Declaration
public static extern long LastInsertRowid(IntPtr db)
Parameters
Type |
Name |
Description |
IntPtr |
db |
|
Returns
LibVersionNumber()
Declaration
public static extern int LibVersionNumber()
Returns
Open(Byte[], out IntPtr, Int32, IntPtr)
Declaration
public static extern SQLite3.Result Open(byte[] filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Returns
Open(String, out IntPtr)
Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db)
Parameters
Returns
Open(String, out IntPtr, Int32, IntPtr)
Declaration
public static extern SQLite3.Result Open(string filename, out IntPtr db, int flags, IntPtr zvfs)
Parameters
Returns
Open16(String, out IntPtr)
Declaration
public static extern SQLite3.Result Open16(string filename, out IntPtr db)
Parameters
Returns
Prepare2(IntPtr, String)
Declaration
public static IntPtr Prepare2(IntPtr db, string query)
Parameters
Returns
Prepare2(IntPtr, String, Int32, out IntPtr, IntPtr)
Declaration
public static extern SQLite3.Result Prepare2(IntPtr db, string sql, int numBytes, out IntPtr stmt, IntPtr pzTail)
Parameters
Returns
Reset(IntPtr)
Declaration
public static extern SQLite3.Result Reset(IntPtr stmt)
Parameters
Type |
Name |
Description |
IntPtr |
stmt |
|
Returns
SetDirectory(UInt32, String)
Declaration
public static extern int SetDirectory(uint directoryType, string directoryPath)
Parameters
Type |
Name |
Description |
UInt32 |
directoryType |
|
String |
directoryPath |
|
Returns
Shutdown()
Declaration
public static extern SQLite3.Result Shutdown()
Returns
Step(IntPtr)
Declaration
public static extern SQLite3.Result Step(IntPtr stmt)
Parameters
Type |
Name |
Description |
IntPtr |
stmt |
|
Returns
Did you find this page useful? Please give it a rating:
Thanks for rating this page!
What kind of problem would you like to report?
Thanks for letting us know! This page has been marked for review based on your feedback.
If you have time, you can provide more information to help us fix the problem faster.
Provide more information
You've told us this page needs code samples. If you'd like to help us further, you could provide a code sample, or tell us about what kind of code sample you'd like to see:
You've told us there are code samples on this page which don't work. If you know how to fix it, or have something better we could use instead, please let us know:
You've told us there is information missing from this page. Please tell us more about what's missing:
You've told us there is incorrect information on this page. If you know what we should change to make it correct, please tell us:
You've told us this page has unclear or confusing information. Please tell us more about what you found unclear or confusing, or let us know how we could make it clearer:
You've told us there is a spelling or grammar error on this page. Please tell us what's wrong:
You've told us this page has a problem. Please tell us more about what's wrong:
Thank you for helping to make the Unity documentation better!
Your feedback has been submitted as a ticket for our documentation team to review.
We are not able to reply to every ticket submitted.