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] >>>>>>>> >>>> >>>> >>> >> ---------------------------------------------------------------------------- >>> >>>> - >>>> >>>> >>>>>>>> >>>>>>> >>>>>>> >>>>>>> >>> >> ---------------------------------------------------------------------------- >>> >>>> - >>>> >>>> >>>>>>> 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] > ----------------------------------------------------------------------------- > > > ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
