i'm trying tu use sqli3 with vb. net
he create the db but not the table..
what is the mistake ?
i've this code
Imports System.Runtime.InteropServices
Public Class Form1
<StructLayout(LayoutKind.Sequential, CharSet:=CharSet.Ansi)> _
Public Structure sqlite_callback
Public Void As Long
Public I1 As Long
Public s1 As String
Public s2 As String
End Structure
Public Declare Function sqlite3_open Lib "sqlite3.dll" (ByVal
Filename As String, ByRef Handle As Long) As Long
Public Declare Function sqlite3_exec Lib "sqlite3.dll" (ByVal Handle
As Long, ByVal Query As String, ByRef CallbackFunction As
sqlite_callback, ByRef CallBackArgs As Long, ByRef Erreur As String) As Long
Public Declare Function sqlite3_close Lib "sqlite3.dll" (ByVal
Handle As Long) As Long
Public Declare Function sqlite3_errmsg Lib "sqlite3.dll" (ByVal
Handle As Long) As String
Public Sub Main()
Dim lRet As Long
Dim lHandle As Long
Dim sErreur As String
Dim sSQL As String
lRet = sqlite3_open("c:\test.db", lHandle)
sSQL = "CREATE Table Toto(titi varchar(15));"
lRet = sqlite3_exec(lHandle, sSQL, Nothing, Nothing, sErreur)
sqlite3_close(lHandle)
End Sub
End Class
Darren Lodge a écrit :
Thankyou!
Darren Lodge
Software Engineer
CAP
0113 222 2058 (direct)
0113 222 2000 (switchboard)
0113 222 2001 (fax)
-----Original Message-----
From: Peter Berkenbosch [mailto:[EMAIL PROTECTED]
Sent: 28 October 2005 09:19
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Dotnet C# support
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Sigh..
http://www.google.com/search?hl=nl&q=SQLite+C%23&btnG=Google+zoeken&meta
=
Darren Lodge wrote:
Hi there,
Is there a version which will work for dotnot?
Darren Lodge
Software Engineer
CAP
0113 222 2058 (direct)
0113 222 2000 (switchboard)
0113 222 2001 (fax)
- --
+-------------------------------+--------------------------+
: Peter Berkenbosch : :
: : t: +31 (0) 64 84 61653 :
: PeRo ICT Solutions : f: +31 (0) 84 22 09880 :
: Koemaad 26 : m: [EMAIL PROTECTED] :
: 8431 TM Oosterwolde : w: www.pero-ict.nl :
+-------------------------------+--------------------------+
: OpenPGP 0x0F655F0D (random.sks.keyserver.penguin.de) :
+----------------------------------------------------------+
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (MingW32)
iD8DBQFDYd7g9bwznA9lXw0RAnb4AJ9oRUkvbXX5aX0HhXZEl6Lv4KNPyACgiUrq
yXTEUWDFVPk97iM5u14V1B4=
=0ECQ
-----END PGP SIGNATURE-----