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-----




Reply via email to