UE · 2023年9月5日 0

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

This plug -in can use a blueprint to operate the SQLite…

1. Node Description

Execute SQLite

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

Perform the SQL statement directly on the SQLite3 file. After the execution of this operation, the file will be released without occupying the file.

File Path :File absolute path

SQL :Sentences that need to be executed

No Result : It will not return a record set for ‘Ture’. If the execution statement has a ‘INSERT’ statement, you need to hook it, otherwise the data may be added repeatedly.

Success :Return to TRUE successfully

Error No :Error coding returns in execution failure

Error Msg :Error information about the failure of execution

Result :Returned record set


DT SQLlite Object

This object can operate the SQLite3 file and keep the file occupation. If you need to operate frequently for a file, this method is recommended.

Create DT SQLite Object

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

Open

Open the sqlite3 file

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

Execute

Execute SQL statement

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

Close

Close file

[UE Unreal Engine] DTSQLite plugin description: Blueprints manipulate SQLite3 files and execute SQL statements.

Return to record set operation

The result set of Result is an array of a MAP, a array is equal to a line of information, and the data of this line is stored in a MAP.

You can also use this plug -in to convert the output set to JSON.


2. Case Display


3. Download Link

SQLite3 in Code Plugins – UE Marketplace (unrealengine.com)