How to insert into SQLite database?

[HezzelQuartz]

I tried to copy some script from somewhere, then modify it like this:
 

#include <Array.au3>
#include <SQLite.au3>
#include <SQLite.dll.au3>

_SQLite_Startup(@ScriptDir & "\" & "sqlite3.dll", False, 1)
If @error Then
    MsgBox(16, "SQLite Error", "SQLite3.dll Can't be Loaded! - " & $__g_hPrintCallback_SQLite & @CRLF & @CRLF & "Exiting application")
    Exit -1
EndIf

Local $sDatabase = @ScriptDir & "\" & "Funfield_Database.db"
Local $hDatabase = _SQLite_Open($sDatabase)

_SQLite_Exec($hDatabase, 'insert into Transaction_Report (Chat_Name, Transfer_Name, Payment_Method) Values ("John", "Doe", "Paypal")')

_SQLite_Close($hDatabase)
_SQLite_Shutdown()

But then, nothing happened

Where should I put SQLite.au3 and SQLite.dll.au3?
I currently put it inside include folder in autoit folder

Where should I put sqlite3.dll and sqlite3_x64.dll?
I currently put it inside this script folder

[Jos]

  On 8/29/2024 at 8:36 AM, HezzelQuartz said:

But then, nothing happened

Expand  

What does that exactly mean?

Also add return/@error tests after each performed function to check what is failing!

[ioa747]

simplicity of using SQLite can be found in the link below
https://www.autoitscript.com/forum/topic/210140-bulldozer

[HezzelQuartz]

  On 8/29/2024 at 8:42 AM, Jos said:

What does that exactly mean?

Also add return/@error tests after each performed function to check what is failing!

Expand  

The Value I tried to add is not added into my database

Nothing happened to my database, Nothing was added

What function should I use to add a row of value to my database?

[jchd]

Again follow @Jos' advice and add @error checking after every SQLite function call, ConsoleWrite anything != 0.

Use sqlite3.dll if compiling for x86 or sqlite3_x64.dll when compiling for x64.

Also string literals in SQL (and SQLite as well) use single quotes; double quotes are reserved for schema names.

Remove line

#include <SQLite.dll.au3>

Edited August 29, 2024 by jchd

[Zedna]

Try to use/run _SQLite_ErrMsg() to get potential more detailed error message, typically after _SQLite_Exec().