Re: [sqlite] C# - SQLite - and other things
Incongruous wrote: > > After downloading sqlite-netFx451-static-binary-x64-2013-1.0.90.0 and uncompressing > it, I got this list of file: > I think using the System.Data.SQLite NuGet package would be better in this case. The package is here (it can also be found by searching in the Visual Studio IDE): https://nuget.org/api/v2/package/System.Data.SQLite/1.0.91.0 -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
RE: [sqlite] C++ SQLite
I did try the ODBC driver, but I found it was quite a bit slower. RBS > RB Smissaert uttered: > >> Yes, that looks to be the way to do it. Basically will have to learn how >> to >> translate C defines to VB declares. > > > Why not just use ODBC? > > http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc > http://www.ch-werner.de/sqliteodbc/ > > That way, you're not even tied to SQLite. > > >> >> RBS >> >> -Original Message- >> From: John Stanton [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 21:58 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> Maybe all you have to do is to make yourself a list og VB types cross >> referenced to the fundamental type used in the Win32 and Sqlite APIs. >> Then you could link any library into your VB programs. >> >> RB Smissaert wrote: >>> You might be right, but with the Win32 API you have loads of nice >>> documents/programs (I like the API guide from KPD) that help you out. >>> All I have to do is copy their declares straight to VB and look at the >> data >>> types I have to provide. Is the same available for the SQLite API? >>> >>> RBS >>> >>> -Original Message- >>> From: John Stanton [mailto:[EMAIL PROTECTED] >>> Sent: 28 November 2006 18:43 >>> To: sqlite-users@sqlite.org >>> Subject: Re: [sqlite] C++ SQLite >>> >>> If you can use the Win32 API you can use the Sqlite API. Just because >>> they can be called from C programs does not make them "all to do with >>> C". >>> >>> RB Smissaert wrote: >>> >>>> Will have a look, but I was looking for a text geared towards VB. I >>>> take >>> >>> it >>> >>>> the documentation that comes with SQLite is all to do with C. >>>> In fact I already have a wrapper that seems to work well, the one from >>>> TerraInformatica, but maybe there was more control if I could write my >>> >>> own. >>> >>>> RBS >>>> >>>> -Original Message- >>>> From: Clay Dowling [mailto:[EMAIL PROTECTED] >>>> Sent: 28 November 2006 18:19 >>>> To: sqlite-users@sqlite.org >>>> Subject: Re: [sqlite] C++ SQLite >>>> >>>> >>>> [EMAIL PROTECTED] said: >>>> >>>> >>>>> Thanks. Would you know any VB source code that wraps all the possible >>>>> declares in a class? Or do you know where to find the documentation >>>>> to make all the possible declares in VB/VBA? >>>>> >>>>> RBS >>>> >>>> >>>> The SQLite documentation will give you everything you need to write >>>> the >>>> wrapper. The sqlite.h file in the source bundle would also be a great >>>> help. You may also be able to find a wrapper already written linked >>>> on >>>> the SQLite web site. >>>> >>>> Clay Dowling >>>> >>>> >>>> >>>>>> Yes. It's a regular windows DLL, so it will behave like all other >>>>>> Windows >>>>>> DLLs. >>>>>> >>>>>> Clay Dowling >>>>>> >>>>>> [EMAIL PROTECTED] said: >>>>>> >>>>>> >>>>>>> Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>>> VB or do I need the wrapper? So, could it work from VB with >>>>>>> declares >>>>>>> as I use for the Windows API? >>>>>>> >>>>>>> RBS >>>>>>> >>>>>>> >>>>>>> >>>>>>>> sebcity wrote: >>>>>>>> >>>>>>>> >>>>>>>>> How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>>> display >>>>>>>>> SQLite tables. C++ wrappers? >>>>>>>> >>>>>>>> You should be able to call the Sqlite3 API directly. >>>>>>>> >>>>>>>> >>>> >>>> >>> >> >>> >>>> - >>>> >>>> >>>>>>>> To unsubscribe, send email to [EMAIL PROTECTED]
RE: [sqlite] C++ SQLite
RB Smissaert uttered: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. Why not just use ODBC? http://www.sqlite.org/cvstrac/wiki?p=SqliteOdbc http://www.ch-werner.de/sqliteodbc/ That way, you're not even tied to SQLite. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- /"\ \ /ASCII RIBBON CAMPAIGN - AGAINST HTML MAIL X - AGAINST MS ATTACHMENTS / \ - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
There us very little to learn, just equivalent names for types. RB Smissaert wrote: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Check that the version of VB, or VB itself supports calling external functions using 'cdecl' calling convention (instead of WINAPI stdcall). On 28/11/06, RB Smissaert <[EMAIL PROTECTED]> wrote: Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
Yes, that looks to be the way to do it. Basically will have to learn how to translate C defines to VB declares. RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:58 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the data > types I have to provide. Is the same available for the SQLite API? > > RBS > > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: > >>Will have a look, but I was looking for a text geared towards VB. I take > > it > >>the documentation that comes with SQLite is all to do with C. >>In fact I already have a wrapper that seems to work well, the one from >>TerraInformatica, but maybe there was more control if I could write my > > own. > >>RBS >> >>-Original Message----- >>From: Clay Dowling [mailto:[EMAIL PROTECTED] >>Sent: 28 November 2006 18:19 >>To: sqlite-users@sqlite.org >>Subject: Re: [sqlite] C++ SQLite >> >> >>[EMAIL PROTECTED] said: >> >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >>The SQLite documentation will give you everything you need to write the >>wrapper. The sqlite.h file in the source bundle would also be a great >>help. You may also be able to find a wrapper already written linked on >>the SQLite web site. >> >>Clay Dowling >> >> >> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > > >>- >> >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > > >>- >> >> >>>>>> >>>>> >>>>> >>>>> > > >>- >> >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > > >>- >> >> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > > >>- >> >> >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> >> >> > > >>- >> >> >>>> >>> >>> >>> > > >>- >> >> >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> >> >> > > >>- >> >> >> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Maybe all you have to do is to make yourself a list og VB types cross referenced to the fundamental type used in the Win32 and Sqlite APIs. Then you could link any library into your VB programs. RB Smissaert wrote: You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
> In the amount of time that you've spent asking for an import > library on this list you could have written all of the imports. If you say so. Thanks in any case. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 21:39 To: sqlite-users@sqlite.org Subject: RE: [sqlite] C++ SQLite RB Smissaert said: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the > data > types I have to provide. Is the same available for the SQLite API? > http://www.sqlite.org/capi3ref.html That's the page you want. It declares everything you need. In the amount of time that you've spent asking for an import library on this list you could have written all of the imports. The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare them as such. Everything else is a fundamental type. Now you're good to go. Combine that with my article in a previous message about how to use the API and you're on the same footing as the C programmers who use the library. Clay Dowling > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: >> Will have a look, but I was looking for a text geared towards VB. I take > it >> the documentation that comes with SQLite is all to do with C. >> In fact I already have a wrapper that seems to work well, the one from >> TerraInformatica, but maybe there was more control if I could write my > own. >> >> RBS >> >> -Original Message- >> From: Clay Dowling [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 18:19 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> >> [EMAIL PROTECTED] said: >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >> The SQLite documentation will give you everything you need to write the >> wrapper. The sqlite.h file in the source bundle would also be a great >> help. You may also be able to find a wrapper already written linked on >> the SQLite web site. >> >> Clay Dowling >> >> >>> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > >> - >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > >> - >> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >> > >> - >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > >> - >> >>>>> >>>> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > >> - >> >>
RE: [sqlite] C++ SQLite
RB Smissaert said: > You might be right, but with the Win32 API you have loads of nice > documents/programs (I like the API guide from KPD) that help you out. > All I have to do is copy their declares straight to VB and look at the > data > types I have to provide. Is the same available for the SQLite API? > http://www.sqlite.org/capi3ref.html That's the page you want. It declares everything you need. In the amount of time that you've spent asking for an import library on this list you could have written all of the imports. The sqlite3* and sqlite3_stmt* types are just pointers, so you can declare them as such. Everything else is a fundamental type. Now you're good to go. Combine that with my article in a previous message about how to use the API and you're on the same footing as the C programmers who use the library. Clay Dowling > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:43 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > If you can use the Win32 API you can use the Sqlite API. Just because > they can be called from C programs does not make them "all to do with C". > > RB Smissaert wrote: >> Will have a look, but I was looking for a text geared towards VB. I take > it >> the documentation that comes with SQLite is all to do with C. >> In fact I already have a wrapper that seems to work well, the one from >> TerraInformatica, but maybe there was more control if I could write my > own. >> >> RBS >> >> -Original Message- >> From: Clay Dowling [mailto:[EMAIL PROTECTED] >> Sent: 28 November 2006 18:19 >> To: sqlite-users@sqlite.org >> Subject: Re: [sqlite] C++ SQLite >> >> >> [EMAIL PROTECTED] said: >> >>>Thanks. Would you know any VB source code that wraps all the possible >>>declares in a class? Or do you know where to find the documentation >>>to make all the possible declares in VB/VBA? >>> >>>RBS >> >> >> The SQLite documentation will give you everything you need to write the >> wrapper. The sqlite.h file in the source bundle would also be a great >> help. You may also be able to find a wrapper already written linked on >> the SQLite web site. >> >> Clay Dowling >> >> >>> >>>>Yes. It's a regular windows DLL, so it will behave like all other >>>>Windows >>>>DLLs. >>>> >>>>Clay Dowling >>>> >>>>[EMAIL PROTECTED] said: >>>> >>>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>>as I use for the Windows API? >>>>> >>>>>RBS >>>>> >>>>> >>>>>>sebcity wrote: >>>>>> >>>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>>display >>>>>>>SQLite tables. C++ wrappers? >>>>>> >>>>>>You should be able to call the Sqlite3 API directly. >>>>>> >>>>>> >> >> > >> - >> >>>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>>> >> >> > >> - >> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> >> > >> - >> >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> >> >> > >> - >> >>>>> >>>> >>>>-- >>>>Simple Content Management >>>>http://www.ceamus.com >>>> >>>> >>>> >> >> > >> - >> >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> >> >> > >> - >> >>>> >>>> >>> >>> >>> >>> >> > >> - >> >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> >> >> > >> - >> >>> >> >> > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > > - > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
You might be right, but with the Win32 API you have loads of nice documents/programs (I like the API guide from KPD) that help you out. All I have to do is copy their declares straight to VB and look at the data types I have to provide. Is the same available for the SQLite API? RBS -Original Message- From: John Stanton [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:43 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: > Will have a look, but I was looking for a text geared towards VB. I take it > the documentation that comes with SQLite is all to do with C. > In fact I already have a wrapper that seems to work well, the one from > TerraInformatica, but maybe there was more control if I could write my own. > > RBS > > -Original Message- > From: Clay Dowling [mailto:[EMAIL PROTECTED] > Sent: 28 November 2006 18:19 > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] C++ SQLite > > > [EMAIL PROTECTED] said: > >>Thanks. Would you know any VB source code that wraps all the possible >>declares in a class? Or do you know where to find the documentation >>to make all the possible declares in VB/VBA? >> >>RBS > > > The SQLite documentation will give you everything you need to write the > wrapper. The sqlite.h file in the source bundle would also be a great > help. You may also be able to find a wrapper already written linked on > the SQLite web site. > > Clay Dowling > > >> >>>Yes. It's a regular windows DLL, so it will behave like all other >>>Windows >>>DLLs. >>> >>>Clay Dowling >>> >>>[EMAIL PROTECTED] said: >>> >>>>Can I call the SQLite API (as in the dll SQLite.dll) directly from >>>>VB or do I need the wrapper? So, could it work from VB with declares >>>>as I use for the Windows API? >>>> >>>>RBS >>>> >>>> >>>>>sebcity wrote: >>>>> >>>>>>How would one go about using c++ (Visual Studio.NET) to call and >>>>>>display >>>>>>SQLite tables. C++ wrappers? >>>>> >>>>>You should be able to call the Sqlite3 API directly. >>>>> >>>>> > > > - > >>>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>>> > > > - > >>>>> >>>>> >>>> >>>> >>>> >>>> > > - > >>>>To unsubscribe, send email to [EMAIL PROTECTED] >>>> > > > - > >>>> >>> >>>-- >>>Simple Content Management >>>http://www.ceamus.com >>> >>> >>> > > > - > >>>To unsubscribe, send email to [EMAIL PROTECTED] >>> > > > - > >>> >>> >> >> >> >> > > - > >>To unsubscribe, send email to [EMAIL PROTECTED] >> > > > - > >> > > - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
If you can use the Win32 API you can use the Sqlite API. Just because they can be called from C programs does not make them "all to do with C". RB Smissaert wrote: Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: Thanks. Would you know any VB source code that wraps all the possible declares in a class? Or do you know where to find the documentation to make all the possible declares in VB/VBA? RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
RE: [sqlite] C++ SQLite
Will have a look, but I was looking for a text geared towards VB. I take it the documentation that comes with SQLite is all to do with C. In fact I already have a wrapper that seems to work well, the one from TerraInformatica, but maybe there was more control if I could write my own. RBS -Original Message- From: Clay Dowling [mailto:[EMAIL PROTECTED] Sent: 28 November 2006 18:19 To: sqlite-users@sqlite.org Subject: Re: [sqlite] C++ SQLite [EMAIL PROTECTED] said: > Thanks. Would you know any VB source code that wraps all the possible > declares in a class? Or do you know where to find the documentation > to make all the possible declares in VB/VBA? > > RBS The SQLite documentation will give you everything you need to write the wrapper. The sqlite.h file in the source bundle would also be a great help. You may also be able to find a wrapper already written linked on the SQLite web site. Clay Dowling > > >> Yes. It's a regular windows DLL, so it will behave like all other >> Windows >> DLLs. >> >> Clay Dowling >> >> [EMAIL PROTECTED] said: >>> Can I call the SQLite API (as in the dll SQLite.dll) directly from >>> VB or do I need the wrapper? So, could it work from VB with declares >>> as I use for the Windows API? >>> >>> RBS >>> >>>> sebcity wrote: >>>>> How would one go about using c++ (Visual Studio.NET) to call and >>>>> display >>>>> SQLite tables. C++ wrappers? >>>> You should be able to call the Sqlite3 API directly. >>>> >>>> - >>>> To unsubscribe, send email to [EMAIL PROTECTED] >>>> - >>>> >>>> >>>> >>> >>> >>> >>> >>> - >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> - >>> >>> >> >> >> -- >> Simple Content Management >> http://www.ceamus.com >> >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Yes. It's a regular windows DLL, so it will behave like all other Windows DLLs. Clay Dowling [EMAIL PROTECTED] said: > Can I call the SQLite API (as in the dll SQLite.dll) directly from > VB or do I need the wrapper? So, could it work from VB with declares > as I use for the Windows API? > > RBS > >> sebcity wrote: >>> How would one go about using c++ (Visual Studio.NET) to call and >>> display >>> SQLite tables. C++ wrappers? >> You should be able to call the Sqlite3 API directly. >> >> - >> To unsubscribe, send email to [EMAIL PROTECTED] >> - >> >> >> > > > > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Can I call the SQLite API (as in the dll SQLite.dll) directly from VB or do I need the wrapper? So, could it work from VB with declares as I use for the Windows API? RBS > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > You should be able to call the Sqlite3 API directly. > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Remember the first rule of IT. "If you don't have time do do it right, you don't have time to do it twice". sebcity wrote: Time constraints Craig Morrison-2 wrote: sebcity wrote: Thanks, Could you supply an example? I'm not going to be as nice as everyone else, go here: http://www.sqlite.org/cvstrac/wiki Do some research and then come back instead of asking for handouts. We've all been where you are now, the difference is that we tried on our own and _then_ came here asking questions when we got stuck. Trying to do a little work on your own will do you a world of good. Clay Dowling wrote: sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] - -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You. - To unsubscribe, send email to [EMAIL PROTECTED] - - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You should be able to call the Sqlite3 API directly. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity said: > > Thanks, Could you supply an example? > http://www.linuxjournal.com/article/7803 Clay -- Simple Content Management http://www.ceamus.com - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity <[EMAIL PROTECTED]> was heard to say: > > Time constraints > Good point. I've got time constraints too. Could everyone else please start to solve all my problems right now too please? Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
Time constraints Craig Morrison-2 wrote: > > sebcity wrote: >> Thanks, Could you supply an example? > > I'm not going to be as nice as everyone else, go here: > > http://www.sqlite.org/cvstrac/wiki > > Do some research and then come back instead of asking for handouts. > > We've all been where you are now, the difference is that we tried on our > own and _then_ came here asking questions when we got stuck. Trying to > do a little work on your own will do you a world of good. > >> >> Clay Dowling wrote: >>> sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? >>> You could just use the API directly. Myself, I've put a wrapper around >>> it, but there's nothing saying that you have to. >>> >>> Clay >>> -- >>> CeaMuS >>> http://www.ceamus.com >>> Simple Content Management >>> >>> - >>> To unsubscribe, send email to [EMAIL PROTECTED] >>> - >>> >>> >>> >> > > > > -- > Craig Morrison > =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= > http://pse.2cah.com >Controlling pseudoephedrine purchases. > > http://www.mtsprofessional.com/ >A Win32 email server that works for You. > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7578545 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] Re:[sqlite] C++ SQLite
u have to search sqlite++. :) -- Linker M Lin [EMAIL PROTECTED] ※ ※※我思故我在※※ ※ - 原始邮件 发件人: sebcity <[EMAIL PROTECTED]> 收件人: sqlite-users@sqlite.org 已发送: 2006/11/28(周二), 下午7:52:07 主题: Re: [sqlite] C++ SQLite Thanks, Could you supply an example? Clay Dowling wrote: > > sebcity wrote: >> How would one go about using c++ (Visual Studio.NET) to call and display >> SQLite tables. C++ wrappers? > > You could just use the API directly. Myself, I've put a wrapper around > it, but there's nothing saying that you have to. > > Clay > -- > CeaMuS > http://www.ceamus.com > Simple Content Management > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > > > -- View this message in context: http://www.nabble.com/C%2B%2B-SQLite-tf2717819.html#a7577870 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, send email to [EMAIL PROTECTED] - ___ 抢注雅虎免费邮箱-3.5G容量,20M附件! http://cn.mail.yahoo.com
Re: [sqlite] C++ SQLite
sebcity wrote: Thanks, Could you supply an example? I'm not going to be as nice as everyone else, go here: http://www.sqlite.org/cvstrac/wiki Do some research and then come back instead of asking for handouts. We've all been where you are now, the difference is that we tried on our own and _then_ came here asking questions when we got stuck. Trying to do a little work on your own will do you a world of good. Clay Dowling wrote: sebcity wrote: How would one go about using c++ (Visual Studio.NET) to call and display SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] - -- Craig Morrison =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= http://pse.2cah.com Controlling pseudoephedrine purchases. http://www.mtsprofessional.com/ A Win32 email server that works for You. - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] C++ SQLite
sebcity wrote: > How would one go about using c++ (Visual Studio.NET) to call and display > SQLite tables. C++ wrappers? You could just use the API directly. Myself, I've put a wrapper around it, but there's nothing saying that you have to. Clay -- CeaMuS http://www.ceamus.com Simple Content Management - To unsubscribe, send email to [EMAIL PROTECTED] -