Re: [sqlite] .lib file?

>> -Original Message- >> From: sqlite-users-boun...@sqlite.org >> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Doug >> Sent: Saturday, July 25, 2009 11:24 AM >> To: 'General Discussion of SQLite Database' >> Subject: Re: [sqlite] .lib file? >> >> >> Hi Paul -- >> >> When I build

Re: [sqlite] Sqlite from ASP?

Try this... http://sqlite.phxsoftware.com/ On Sat, Jul 25, 2009 at 11:50 AM, Paul Claessen wrote: > Greetings, > > > > Does anyone have any (simple) examples on how to use sqlite from .ASP scripts > for me? Or C# code, for that matter? > > > > ~ Paul Claessen > > > >

Re: [sqlite] Is there an easy way to concatenate 2 views ?

Yw, anytime. -Original Message- From: Stef Mientki Sent: Saturday, July 25, 2009 4:16 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is there an easy way to concatenate 2 views ? thanks Woody ( Harold ?), that works perfect. cheers, Stef Harold Wood & Meyuni

Re: [sqlite] Sqlite from ASP?

"Paul Claessen" schrieb im Newsbeitrag news:005601ca0d3f$af8748e0$0e95da...@com... > Does anyone have any (simple) examples on how > to use sqlite from .ASP scripts for me? Since you have CreateObject() available in these scripts, any COM-based SQLite wrapper should do...

Re: [sqlite] .lib file?

Good! I just told my wife to put the gun down... But she's not listening... -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Paul Claessen Sent: Saturday, July 25, 2009 4:35 PM To: 'General Discussion of SQLite Database'

Re: [sqlite] Is there an easy way to concatenate 2 views ?

thanks Woody ( Harold ?), that works perfect. cheers, Stef Harold Wood & Meyuni Gani wrote: > Concantenate or join? > > To concantenate use the > Select * from a > Union all > Select * from b > > Only use * if columns all columns in a are identical to all columns in b, if > not then build a

Re: [sqlite] Is there an easy way to concatenate 2 views ?

Concantenate or join? To concantenate use the Select * from a Union all Select * from b Only use * if columns all columns in a are identical to all columns in b, if not then build a column list and use that indtead of * Woody -Original Message- From: Stef Mientki

[sqlite] Is there an easy way to concatenate 2 views ?

hello, I've 2 views ( or maybe tables) with same columns, is there an easy way to concatenate those 2 views to 1 new view ? thanks, Stef Mientki ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] sqlite v2.8 console for windows

Nevermind, I found one... for those interested i found a useful program here, that also let's you convert DBF files into SQLite2.8: http://www.geocities.com/SiliconValley/Board/5300/sqlite/hbsqlite_es.htm thank you all ! An M On Sat, Jul 25, 2009 at 5:09 PM, An wrote:

Re: [sqlite] .lib file?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Paul Claessen wrote: > Actually, I was able to generate a .lib file from the DLL using Doug's > suggesting (link /lib /def:sqlite3.def). > Works fine now! MinGW comes with a tool named 'pexports.exe' that can generate the def file directly from any

[sqlite] sqlite v2.8 console for windows

Hi, I'm using XAMPP on windows, and I'm developing a proyect using sqlite2.8 (the one bundled with XAMPP). Do you know an sqlite2.8 console for Windows (not necessarily GUI), to be able to access my database and issue SQL commands ? Thank you all, An Michel R.

Re: [sqlite] .lib file?

Actually, I was able to generate a .lib file from the DLL using Doug's suggesting (link /lib /def:sqlite3.def). Works fine now! Thanks all! ~ Paul Claessen > -Original Message- > From: sqlite-users-boun...@sqlite.org > [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Fred >

Re: [sqlite] .lib file?

Hum. So Mickeysoft does not supply a lib converter/creator utility? I even have a "Make" and "Grep" utility when I get nostalgic for my limited Unix days. My generator has an "-a" option to, "Add '_' alias for MS flavor cdecl functions." Is that what you mean? Someday if I can find someone to

Re: [sqlite] .lib file?

Fred, Unfortunately, .lib (or, for that matter, .obj) files created by Borland compilers are not compatible with the Microsoft toolchain, and vice-versa. Borland uses a variant of the OMF object format, and Microsoft uses a variant of COFF. On 07/25/2009 08:09 PM, Fred Williams wrote: > Paul,

Re: [sqlite] .lib file?

Paul, If you wish I can send yoou a SQLite3.lib file I just generated using my old Borland C++ Builder 5 Lib utility. Can't attach it here so contact me: fwillia...@gmail.com And I'll attach it to a reply. Fred -Original Message- From: sqlite-users-boun...@sqlite.org

Re: [sqlite] a system for arbitrarily tagging rows in a table

You can have the tags in a separate table that has a foreign-key to the table with the rows in in you want to tag, and then do a select from that table to find the tagged rows. If you need to search for multiple tags at a time, each requires a join: select t from tagged as t join t.tags as

Re: [sqlite] .lib file?

Hi Paul -- When I build SQLite (from the amalgamation) into a DLL VS2008 (and earlier as I recall) automatically creates an import library in the same directory as the .DLL file. I also _used_ to run the following command separately to create the import lib: link /lib /def:sqlite3.def I

Re: [sqlite] .lib file?

Thanks Pavel. Two points though: 1. The amalgated sources were, apparently, not written with MS Visual Study in mind, since compiling it results in over 100 errors (mostly invalid pointer conversions) 2. If I have a number of apps, it would really be more efficient to use the DLL. I'm sure I

[sqlite] Sqlite from ASP?

Greetings, Does anyone have any (simple) examples on how to use sqlite from .ASP scripts for me? Or C# code, for that matter? ~ Paul Claessen ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] .lib file?

You can take sqlite3.c from amalgamation package and include it into your project. This way SQLite will be included into your application and you won't need any .dll or .lib files. Pavel On Sat, Jul 25, 2009 at 10:41 AM, Paul Claessen wrote: > Greetings, > > > > I'm trying to

[sqlite] .lib file?

Greetings, I'm trying to build and use the short sample C code on the quick start page (http://www.sqlite.org/quickstart.html) for windows as a simple win32 console app, using Visual Studio 2008. In order to provide linkage to the DLL, I need to link with the .lib file that is usually

Re: [sqlite] Float comparision problem

Floating point representation issues. This is nothing out of the ordinary, expect stuff like that to happen in any programming language on any system. See David Goldberg's seminal paper "What Every Computer Scientist Should Know About Floating-Point Arithmetic" here for details:

[sqlite] Float comparision problem

Hi, i need some help... what i am doing wrong?? This works fine SELECT 1 WHERE CAST(14.8 AS REAL) = CAST(14.8 AS REAL) But this doesn't SELECT 1 WHERE CAST(14.8 AS REAL) = CAST(0.1+14.7 AS REAL) Thanks. ___ sqlite-users mailing list

[sqlite] Port to C#; Progress report

A progress report because people keep asking ... Yes, it is Version 3.6.16 I am currently compiling with the following OMIT options: DEBUG_CLASS_NONE TRACE SQLITE_ASCII SQLITE_DEBUG SQLITE_ENABLE_COLUMN_METADATAS SQLITE_ENABLE_OVERSIZE_CELL_CHECK SQLITE_SYSTEM_MALLOC SQLITE_TEST