Riz Posted June 21, 2006 Share Posted June 21, 2006 Hi all, This is my first post. I have looked at sqlite UDF and other staffs. Its really amazing work, I just wonder can I use GUI from to insert data to the database. Regards Link to comment Share on other sites More sharing options...
Norky Posted June 21, 2006 Share Posted June 21, 2006 Hi all, This is my first post. I have looked at sqlite UDF and other staffs. Its really amazing work, I just wonder can I use GUI from to insert data to the database. Regards Maybe this code will helps you but I don't know about GUI from, somebody else will help you don't worry. Dim $sReturn $sql = DllOpen ("SQLiteAU3.dll") $result = DllCall($sql, "int", "SQLite_Open", "str", "myDB.db") $result = DllCall($sql, "int", "SQLite_Exec", "str", "CREATE TABLE tbTrids (id integer, descr varchar(20));", "str", $sReturn) $result = DllCall($sql, "int", "SQLite_Exec", "str", "INSERT INTO tbTrids SELECT 5, 'aaaaaa';", "str", $sReturn) $result = DllCall($sql, "int", "SQLite_Exec", "str", "INSERT INTO tbTrids SELECT 6, 'bbbbbbbb';", "str", $sReturn) $result = DllCall($sql, "int", "SQLite_Exec", "str", "INSERT INTO tbTrids SELECT 7, '123456789012345678901234567890';", "str", $sReturn) $result = DllCall($sql, "int", "SQLite_Exec", "str", "SELECT * FROM tbTrids;", "str", $sReturn) MsgBox (0, "title", $result[2]) DllCall($sql, "int", "SQLite_Close") DllClose($sql) Link to comment Share on other sites More sharing options...
Riz Posted June 21, 2006 Author Share Posted June 21, 2006 Thanks for you reply. but really need form. like this from below. when press add the data insert to myDB.db #include <GuiConstants.au3> GuiCreate("MyGUI", 392, 316,-1, -1 , BitOR($WS_OVERLAPPEDWINDOW, $WS_CLIPSIBLINGS)) $Input_1 = GuiCtrlCreateInput("Input1", 60, 60, 110, 20) $Input_2 = GuiCtrlCreateInput("Input2", 60, 100, 110, 20) $Input_3 = GuiCtrlCreateInput("Input3", 60, 140, 110, 20) $Button_4 = GuiCtrlCreateButton("Add", 220, 90, 70, 30) GuiSetState() While 1 $msg = GuiGetMsg() Select Case $msg = $GUI_EVENT_CLOSE ExitLoop Case Else ;;; EndSelect WEnd Exit Link to comment Share on other sites More sharing options...
Riz Posted June 21, 2006 Author Share Posted June 21, 2006 Any Idea, Advice, suggestion plesae? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now