Autoit sqlite - 편집 역사

Devcafe: /* 또다른 예제 */

2025-07-23T17:03:17Z

또다른 예제

← 이전 판		2025년 7월 24일 (목) 02:03 판
90번째 줄:		90번째 줄:
	Exit		Exit
	</source>		</source>
	== ~~또다른~~ 예제==		== sqlite 입력 수정 삭제 예제==
	<source lang=autoit>		<source lang=autoit>

Devcafe: /* sqlite이용 하여 그룹별로 저장하고 그룹별 탭을 클릭시 해당룹의 내용을 보여주는 예제 */

2025-03-13T12:36:09Z

sqlite이용 하여 그룹별로 저장하고 그룹별 탭을 클릭시 해당룹의 내용을 보여주는 예제

@@ 89번째 줄: / 89번째 줄: @@
 _SQLite_Shutdown()
 Exit
 </source>
 [[category:autoit]]

Devcafe: /* autoit sqlite 예제 */

2024-11-04T09:38:15Z

autoit sqlite 예제

@@ 23번째 줄: / 23번째 줄: @@
 _SQLite_Shutdown()
 </source>
 [[category:autoit]]

Devcafe: 새 문서: == autoit sqlite 예제 == #include #include _SQLite_Startup() ; Load the DLL If @error Then Exit MsgBox(0, "Error", "Unable to start SQLite, Please verify your DLL") Local $sDatabase = @ScriptDir & '\SQLiteTestDatabase.db' Local $hDatabase = _SQLite_Open($sDatabase) ; Create the database file and get the handle for the database _SQLite_Exec($hDatabase, 'CREATE TABLE People (first_name, last_name);') ; CREATE a TABLE with the nam...

2024-10-04T17:22:23Z

새 문서: == autoit sqlite 예제 == <source lang=autoit> #include <Array.au3> #include <SQLite.au3> _SQLite_Startup() ; Load the DLL If @error Then Exit MsgBox(0, "Error", "Unable to start SQLite, Please verify your DLL") Local $sDatabase = @ScriptDir & '\SQLiteTestDatabase.db' Local $hDatabase = _SQLite_Open($sDatabase) ; Create the database file and get the handle for the database _SQLite_Exec($hDatabase, 'CREATE TABLE People (first_name, last_name);') ; CREATE a TABLE with the nam...

새 문서

== autoit sqlite 예제 ==
<source lang=autoit>

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

_SQLite_Startup() ; Load the DLL
If @error Then Exit MsgBox(0, "Error", "Unable to start SQLite, Please verify your DLL")

Local $sDatabase = @ScriptDir & '\SQLiteTestDatabase.db'
Local $hDatabase = _SQLite_Open($sDatabase) ; Create the database file and get the handle for the database

_SQLite_Exec($hDatabase, 'CREATE TABLE People (first_name, last_name);') ; CREATE a TABLE with the name "People"
_SQLite_Exec($hDatabase, 'INSERT INTO People VALUES ("Timothy", "Lee");') ; INSERT "Timothy Lee" into the "People" TABLE
_SQLite_Exec($hDatabase, 'INSERT INTO People VALUES ("John", "Doe");') ; INSERT "John Doe" into the "People" TABLE

Local $aResult, $iRows, $iColumns ; $iRows and $iColuums are useless but they cannot be omitted from the function call so we declare them

_SQLite_GetTable2d($hDatabase, 'SELECT * FROM People;', $aResult, $iRows, $iColumns) ; SELECT everything FROM "People" TABLE and get the $aResult
_ArrayDisplay($aResult, "Results from the query")

_SQLite_Close($hDatabase)
_SQLite_Shutdown()
</source>
[[category:autoit]]