Re: [sqlite] .lib file?

[Brodie Thiesfield]

>> -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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if you
>> want to use it.  Since we can't post files to the newsgroup, I'll append it
>> here.
>>
>> Doug

Easy to generate the .def file too.

http://www.google.com/search?q=create+.lib+from+.dll
http://support.microsoft.com/kb/131313

Regards,
Brodie
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite from ASP?

[Roosevelt Anderson]

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
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Harold Wood & Meyuni Gani]

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 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 column list and use that indtead of *
>
> Woody
>
> -Original Message-
> From: Stef Mientki 
> Sent: Saturday, July 25, 2009 3:19 PM
> To: SQLite List 
> Subject: [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
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Sqlite from ASP?

[Olaf Schmidt]

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

Olaf



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Fred Williams]

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'
Subject: 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
> Williams
> Sent: Saturday, July 25, 2009 4:44 PM
> To: General Discussion of SQLite Database
> Subject: 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 hold a big enough caliber gun to my head,
> I'm going to learn something about the "Visual" development world.  I
> installed the C++ "Express" version and was so underwhlmed by the
> performance I started look for that person with a giant gun :-(
>
> Fred
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
> Sent: Saturday, July 25, 2009 1:13 PM
> To: General Discussion of SQLite Database
> Subject: 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,
> >
> > 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
> > [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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if
> you
> > want to use it.  Since we can't post files to the newsgroup, I'll append
> it
> > here.
> >
> > Doug
> >
> > 
> > EXPORTS
> > sqlite3_aggregate_context
> > sqlite3_aggregate_count
> > sqlite3_auto_extension
> > sqlite3_bind_blob
> > sqlite3_bind_double
> > sqlite3_bind_int
> > sqlite3_bind_int64
> > sqlite3_bind_null
> > sqlite3_bind_parameter_count
> > sqlite3_bind_parameter_index
> > sqlite3_bind_parameter_name
> > sqlite3_bind_text
> > sqlite3_bind_text16
> > sqlite3_bind_value
> > sqlite3_bind_zeroblob
> > sqlite3_blob_bytes
> > sqlite3_blob_close
> > sqlite3_blob_open
> > sqlite3_blob_read
> > sqlite3_blob_write
> > sqlite3_busy_handler
> > sqlite3_busy_timeout
> > sqlite3_changes
> > sqlite3_clear_bindings
> > sqlite3_close
> > sqlite3_collation_needed
> > sqlite3_collation_needed16
> > sqlite3_column_blob
> > sqlite3_column_bytes
> > sqlite3_column_bytes16
> > sqlite3_column_count
> > sqlite3_column_decltype
> > sqlite3_column_decltype16
> > sqlite3_column_double
> > sqlite3_column_int
> > sqlite3_column_int64
> > sqlite3_column_name
> > sqlite3_column_name16
> > sqlite3_column_text
> > sqlite3_column_text16
> > sqlite3_column_type
> > sqlite3_column_value
> > sqlite3_commit_hook
> > sqlite3_complete
> > sqlite3_complete16
> > sqlite3_create_collation
> > sqlite3_create_collation16
> > sqlite3_create_collation_v2
> > sqlite3_create_function
> > sqlite3_create_function16
> > sqlite3_create_module
> > sqlite3_create_module_v2
> > sqlite3_data_count
> > sqlite3_db_handle
> > sqlite3_declare_vtab
> > sqlite3_enable_load_extension
> > sqlite3_enable_shared_cache
> > sqlite3_errcode
> > sqlite3_errmsg
> > sqlite3_errmsg16
> > sqlite3_exec
> > sqlite3_expired
> > sqlite3_extended_result_codes
> > sqlite3_file_control
> > sqlite3_finalize
> > sqlite3_free
> > sqlite3_free_table
> > sqlite3_get_autocommit
> > sqlite3_get_auxdata
> > sqlite3_get_table
> > sqlite3_global_recover
> > sqlite3_interrupt
> > sqlite3_last_insert_rowid
> > sqlite3_libversion
> > sqlite3_libversion_number
> > sqlite3_load_extension
> > sqlite3_malloc
> > sqlite3_memory_alarm
> > sqlite3_memory_highwater
> > sqlite3_memory_used
> > sqlite3_mprintf
> > 

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

[Stef Mientki]

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 column list and use that indtead of *
>
> Woody
>
> -Original Message-
> From: Stef Mientki 
> Sent: Saturday, July 25, 2009 3:19 PM
> To: SQLite List 
> Subject: [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
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
>
>   
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Harold Wood & Meyuni Gani]

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 
Sent: Saturday, July 25, 2009 3:19 PM
To: SQLite List 
Subject: [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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[Stef Mientki]

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

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

[An]

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:

> 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.
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Roger Binns]

-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 dll so you don't have to rely on a hand
maintained def file.  It also has dlltool which can take that def file
and generate a lib but I don't know if it is a generic lib file or in
MinGW format.

Roger

-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.9 (GNU/Linux)

iEYEARECAAYFAkprfSAACgkQmOOfHg372QRjkgCeJVX6cpXGQrEC1yvk94q98Evm
D+gAoJ9j3AzwbS2YKzQGcdjPAHUuEBVd
=fCCI
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite v2.8 console for windows

[An]

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.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Paul Claessen]

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
> Williams
> Sent: Saturday, July 25, 2009 4:44 PM
> To: General Discussion of SQLite Database
> Subject: 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 hold a big enough caliber gun to my head,
> I'm going to learn something about the "Visual" development world.  I
> installed the C++ "Express" version and was so underwhlmed by the
> performance I started look for that person with a giant gun :-(
> 
> Fred
> 
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
> Sent: Saturday, July 25, 2009 1:13 PM
> To: General Discussion of SQLite Database
> Subject: 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,
> >
> > 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
> > [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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if
> you
> > want to use it.  Since we can't post files to the newsgroup, I'll append
> it
> > here.
> >
> > Doug
> >
> > 
> > EXPORTS
> > sqlite3_aggregate_context
> > sqlite3_aggregate_count
> > sqlite3_auto_extension
> > sqlite3_bind_blob
> > sqlite3_bind_double
> > sqlite3_bind_int
> > sqlite3_bind_int64
> > sqlite3_bind_null
> > sqlite3_bind_parameter_count
> > sqlite3_bind_parameter_index
> > sqlite3_bind_parameter_name
> > sqlite3_bind_text
> > sqlite3_bind_text16
> > sqlite3_bind_value
> > sqlite3_bind_zeroblob
> > sqlite3_blob_bytes
> > sqlite3_blob_close
> > sqlite3_blob_open
> > sqlite3_blob_read
> > sqlite3_blob_write
> > sqlite3_busy_handler
> > sqlite3_busy_timeout
> > sqlite3_changes
> > sqlite3_clear_bindings
> > sqlite3_close
> > sqlite3_collation_needed
> > sqlite3_collation_needed16
> > sqlite3_column_blob
> > sqlite3_column_bytes
> > sqlite3_column_bytes16
> > sqlite3_column_count
> > sqlite3_column_decltype
> > sqlite3_column_decltype16
> > sqlite3_column_double
> > sqlite3_column_int
> > sqlite3_column_int64
> > sqlite3_column_name
> > sqlite3_column_name16
> > sqlite3_column_text
> > sqlite3_column_text16
> > sqlite3_column_type
> > sqlite3_column_value
> > sqlite3_commit_hook
> > sqlite3_complete
> > sqlite3_complete16
> > sqlite3_create_collation
> > sqlite3_create_collation16
> > sqlite3_create_collation_v2
> > sqlite3_create_function
> > sqlite3_create_function16
> > sqlite3_create_module
> > sqlite3_create_module_v2
> > sqlite3_data_count
> > sqlite3_db_handle
> > sqlite3_declare_vtab
> > sqlite3_enable_load_extension
> > sqlite3_enable_shared_cache
> > sqlite3_errcode
> > sqlite3_errmsg
> > sqlite3_errmsg16
> > sqlite3_exec
> > sqlite3_expired
> > sqlite3_extended_result_codes
> > sqlite3_file_control
> > sqlite3_finalize
> > sqlite3_free
> > sqlite3_free_table
> > sqlite3_get_autocommit
> > sqlite3_get_auxdata
> > sqlite3_get_table
> > sqlite3_global_recover
> > sqlite3_interrupt
> > sqlite3_last_insert_rowid
> > sqlite3_libversion
> > sqlite3_libversion_number
> > sqlite3_load_extension
> > sqlite3_malloc
> > sqlite3_memory_alarm
> > sqlite3_memory_highwater
> > sqlite3_memory_used
> > sqlite3_mprintf
> > sqlite3_mutex_alloc
> > sqlite3_mutex_enter
> > sqlite3_mutex_free
> > sqlite3_mutex_leave
> > sqlite3_mutex_try
> > sqlite3_open
> > sqlite3_open16
> > sqlite3_open_v2
> > sqlite3_overload_function
> > sqlite3_prepare
> > sqlite3_prepare16
> > sqlite3_prepare16_v2
> > sqlite3_prepare_v2
> > sqlite3_profile
> > 

Re: [sqlite] .lib file?

[Fred Williams]

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 hold a big enough caliber gun to my head,
I'm going to learn something about the "Visual" development world.  I
installed the C++ "Express" version and was so underwhlmed by the
performance I started look for that person with a giant gun :-(

Fred

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Mihai Limbasan
Sent: Saturday, July 25, 2009 1:13 PM
To: General Discussion of SQLite Database
Subject: 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,
>
> 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
> [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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if
you
> want to use it.  Since we can't post files to the newsgroup, I'll append
it
> here.
>
> Doug
>
> 
> EXPORTS
> sqlite3_aggregate_context
> sqlite3_aggregate_count
> sqlite3_auto_extension
> sqlite3_bind_blob
> sqlite3_bind_double
> sqlite3_bind_int
> sqlite3_bind_int64
> sqlite3_bind_null
> sqlite3_bind_parameter_count
> sqlite3_bind_parameter_index
> sqlite3_bind_parameter_name
> sqlite3_bind_text
> sqlite3_bind_text16
> sqlite3_bind_value
> sqlite3_bind_zeroblob
> sqlite3_blob_bytes
> sqlite3_blob_close
> sqlite3_blob_open
> sqlite3_blob_read
> sqlite3_blob_write
> sqlite3_busy_handler
> sqlite3_busy_timeout
> sqlite3_changes
> sqlite3_clear_bindings
> sqlite3_close
> sqlite3_collation_needed
> sqlite3_collation_needed16
> sqlite3_column_blob
> sqlite3_column_bytes
> sqlite3_column_bytes16
> sqlite3_column_count
> sqlite3_column_decltype
> sqlite3_column_decltype16
> sqlite3_column_double
> sqlite3_column_int
> sqlite3_column_int64
> sqlite3_column_name
> sqlite3_column_name16
> sqlite3_column_text
> sqlite3_column_text16
> sqlite3_column_type
> sqlite3_column_value
> sqlite3_commit_hook
> sqlite3_complete
> sqlite3_complete16
> sqlite3_create_collation
> sqlite3_create_collation16
> sqlite3_create_collation_v2
> sqlite3_create_function
> sqlite3_create_function16
> sqlite3_create_module
> sqlite3_create_module_v2
> sqlite3_data_count
> sqlite3_db_handle
> sqlite3_declare_vtab
> sqlite3_enable_load_extension
> sqlite3_enable_shared_cache
> sqlite3_errcode
> sqlite3_errmsg
> sqlite3_errmsg16
> sqlite3_exec
> sqlite3_expired
> sqlite3_extended_result_codes
> sqlite3_file_control
> sqlite3_finalize
> sqlite3_free
> sqlite3_free_table
> sqlite3_get_autocommit
> sqlite3_get_auxdata
> sqlite3_get_table
> sqlite3_global_recover
> sqlite3_interrupt
> sqlite3_last_insert_rowid
> sqlite3_libversion
> sqlite3_libversion_number
> sqlite3_load_extension
> sqlite3_malloc
> sqlite3_memory_alarm
> sqlite3_memory_highwater
> sqlite3_memory_used
> sqlite3_mprintf
> sqlite3_mutex_alloc
> sqlite3_mutex_enter
> sqlite3_mutex_free
> sqlite3_mutex_leave
> sqlite3_mutex_try
> sqlite3_open
> sqlite3_open16
> sqlite3_open_v2
> sqlite3_overload_function
> sqlite3_prepare
> sqlite3_prepare16
> sqlite3_prepare16_v2
> sqlite3_prepare_v2
> sqlite3_profile
> sqlite3_progress_handler
> sqlite3_realloc
> sqlite3_release_memory
> sqlite3_reset
> sqlite3_reset_auto_extension
> sqlite3_result_blob
> sqlite3_result_double
> sqlite3_result_error
> sqlite3_result_error16
> sqlite3_result_error_nomem
> sqlite3_result_error_toobig
> sqlite3_result_int
> sqlite3_result_int64
> sqlite3_result_null
> sqlite3_result_text
> sqlite3_result_text16
> sqlite3_result_text16be
> sqlite3_result_text16le
> sqlite3_result_value
> sqlite3_result_zeroblob
> sqlite3_rollback_hook
> sqlite3_set_authorizer
> sqlite3_set_auxdata
> sqlite3_sleep
> sqlite3_snprintf
> sqlite3_soft_heap_limit
> sqlite3_sql
> sqlite3_step
> sqlite3_thread_cleanup
> sqlite3_threadsafe
> sqlite3_total_changes
> sqlite3_trace
> sqlite3_transfer_bindings
> 

Re: [sqlite] .lib file?

[Mihai Limbasan]

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,
>
> 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
> [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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if you
> want to use it.  Since we can't post files to the newsgroup, I'll append it
> here.
>
> Doug
>
> 
> EXPORTS
> sqlite3_aggregate_context
> sqlite3_aggregate_count
> sqlite3_auto_extension
> sqlite3_bind_blob
> sqlite3_bind_double
> sqlite3_bind_int
> sqlite3_bind_int64
> sqlite3_bind_null
> sqlite3_bind_parameter_count
> sqlite3_bind_parameter_index
> sqlite3_bind_parameter_name
> sqlite3_bind_text
> sqlite3_bind_text16
> sqlite3_bind_value
> sqlite3_bind_zeroblob
> sqlite3_blob_bytes
> sqlite3_blob_close
> sqlite3_blob_open
> sqlite3_blob_read
> sqlite3_blob_write
> sqlite3_busy_handler
> sqlite3_busy_timeout
> sqlite3_changes
> sqlite3_clear_bindings
> sqlite3_close
> sqlite3_collation_needed
> sqlite3_collation_needed16
> sqlite3_column_blob
> sqlite3_column_bytes
> sqlite3_column_bytes16
> sqlite3_column_count
> sqlite3_column_decltype
> sqlite3_column_decltype16
> sqlite3_column_double
> sqlite3_column_int
> sqlite3_column_int64
> sqlite3_column_name
> sqlite3_column_name16
> sqlite3_column_text
> sqlite3_column_text16
> sqlite3_column_type
> sqlite3_column_value
> sqlite3_commit_hook
> sqlite3_complete
> sqlite3_complete16
> sqlite3_create_collation
> sqlite3_create_collation16
> sqlite3_create_collation_v2
> sqlite3_create_function
> sqlite3_create_function16
> sqlite3_create_module
> sqlite3_create_module_v2
> sqlite3_data_count
> sqlite3_db_handle
> sqlite3_declare_vtab
> sqlite3_enable_load_extension
> sqlite3_enable_shared_cache
> sqlite3_errcode
> sqlite3_errmsg
> sqlite3_errmsg16
> sqlite3_exec
> sqlite3_expired
> sqlite3_extended_result_codes
> sqlite3_file_control
> sqlite3_finalize
> sqlite3_free
> sqlite3_free_table
> sqlite3_get_autocommit
> sqlite3_get_auxdata
> sqlite3_get_table
> sqlite3_global_recover
> sqlite3_interrupt
> sqlite3_last_insert_rowid
> sqlite3_libversion
> sqlite3_libversion_number
> sqlite3_load_extension
> sqlite3_malloc
> sqlite3_memory_alarm
> sqlite3_memory_highwater
> sqlite3_memory_used
> sqlite3_mprintf
> sqlite3_mutex_alloc
> sqlite3_mutex_enter
> sqlite3_mutex_free
> sqlite3_mutex_leave
> sqlite3_mutex_try
> sqlite3_open
> sqlite3_open16
> sqlite3_open_v2
> sqlite3_overload_function
> sqlite3_prepare
> sqlite3_prepare16
> sqlite3_prepare16_v2
> sqlite3_prepare_v2
> sqlite3_profile
> sqlite3_progress_handler
> sqlite3_realloc
> sqlite3_release_memory
> sqlite3_reset
> sqlite3_reset_auto_extension
> sqlite3_result_blob
> sqlite3_result_double
> sqlite3_result_error
> sqlite3_result_error16
> sqlite3_result_error_nomem
> sqlite3_result_error_toobig
> sqlite3_result_int
> sqlite3_result_int64
> sqlite3_result_null
> sqlite3_result_text
> sqlite3_result_text16
> sqlite3_result_text16be
> sqlite3_result_text16le
> sqlite3_result_value
> sqlite3_result_zeroblob
> sqlite3_rollback_hook
> sqlite3_set_authorizer
> sqlite3_set_auxdata
> sqlite3_sleep
> sqlite3_snprintf
> sqlite3_soft_heap_limit
> sqlite3_sql
> sqlite3_step
> sqlite3_thread_cleanup
> sqlite3_threadsafe
> sqlite3_total_changes
> sqlite3_trace
> sqlite3_transfer_bindings
> sqlite3_update_hook
> sqlite3_user_data
> sqlite3_value_blob
> sqlite3_value_bytes
> sqlite3_value_bytes16
> sqlite3_value_double
> sqlite3_value_int
> sqlite3_value_int64
> sqlite3_value_numeric_type
> sqlite3_value_text
> sqlite3_value_text16
> sqlite3_value_text16be
> sqlite3_value_text16le
> sqlite3_value_type
> sqlite3_version
> sqlite3_vfs_find
> sqlite3_vfs_register
> sqlite3_vfs_unregister
> sqlite3_vmprintf
> 
>
>
>
>> -Original Message-
>> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
>> boun...@sqlite.org] On Behalf Of Paul Claessen
>> Sent: Saturday, July 25, 2009 10:49 AM
>> To: sqlite-users@sqlite.org
>> Subject: Re: [sqlite] .lib file?
>>
>> Thanks Pavel.
>>
>> Two points though:
>>
>> 1. The amalgated sources were, apparently, not written with MS 

Re: [sqlite] .lib file?

[Fred Williams]

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
[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 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 haven't kept my sqlite3.def file up to date, but it's fairly recent if you
want to use it.  Since we can't post files to the newsgroup, I'll append it
here.

Doug


EXPORTS
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_auto_extension
sqlite3_bind_blob
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_changes
sqlite3_clear_bindings
sqlite3_close
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_complete
sqlite3_complete16
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_db_handle
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_exec
sqlite3_expired
sqlite3_extended_result_codes
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_interrupt
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_load_extension
sqlite3_malloc
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_mprintf
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_leave
sqlite3_mutex_try
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_overload_function
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare_v2
sqlite3_profile
sqlite3_progress_handler
sqlite3_realloc
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_rollback_hook
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_sleep
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_sql
sqlite3_step
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_transfer_bindings
sqlite3_update_hook
sqlite3_user_data
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Paul Claessen
> Sent: Saturday, July 25, 2009 10:49 AM
> To: sqlite-users@sqlite.org
> Subject: 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 can fix all the pointer casts (shouldn't be necessary if the
> code used more consistent types!), but that would take me a
> lot of time, plus, there should be a way to simply use the .dll: since
> there IS a windows console app, there must be either a .lib
> file somewhere, or there is an alternative way of using DLL's from a
> windows console app, that I'm not aware of.
>
> Kind regards,
>
> ~ Paul Claessen
>
>
> > -Original Message-
> > From: Pavel 

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

[Jim Showalter]

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 tag1 join t.tags as tag2 where tag1 = some value and 
tag2 = some value.

- Original Message - 
From: "Jay A. Kreibich" 
To: ; "General Discussion of SQLite Database" 

Sent: Friday, July 24, 2009 9:21 PM
Subject: Re: [sqlite] a system for arbitrarily tagging rows in a table


> On Fri, Jul 24, 2009 at 09:20:29PM -0500, P Kishor scratched on the 
> wall:
>> I am trying to develop a "tagging" system, whereby each row in a 
>> table
>> can be tagged with arbitrary number of tags.
>
>  This smells of a Relational division problem.  If you're dealing 
> with
>  tags you might want to have a look at that (Celko has a few good
>  articles on it).  Since SQL lacks a native Relational division
>  operator, chances are a solution in that direction is going to be
>  more complex -- at least for this problem.  But any time I've done
>  tags or attributes, sooner or later I find myself needing to do a
>  division.  They come in handy any time you say "my data is vertical
>  but I need it horizontal."  You might want to read up on them just 
> to
>  have that knowledge available.
>
>
>> TABLE foo (f_id INTEGER PRIMARY KEY, f_name TEXT);
>> TABLE tag (t_id INTEGER PRIMARY KEY, t_name TEXT);
>> TABLE foo_tag (f_id INTEGER, t_id INTEGER);
>
>
>> I have the following solution. Could I do better or differently?
>
>  I'm not sure about "better", but here's different:
>
> sqlite> SELECT foo.f_name, tag.t_name
>   ...> FROM tag AS target
>   ...>   NATURAL JOIN foo_tag AS target_ft
>   ...>   NATURAL JOIN foo
>   ...>   NATURAL JOIN foo_tag
>   ...>   NATURAL JOIN tag
>   ...> WHERE target.t_name = 'bar'
>   ...>   AND tag.t_id != target.t_id
>   ...> ORDER BY foo.f_name, tag.t_name;
>
>  This basically folds your IN sub-select back into the main query.
>  We join "foo" to the tag table in two directions... one to find
>  the search target tag id and the other to produce the output.
>
>  "tag AS target" with the first WHERE clause should return one row.
>  We join that through "foo_tag AS target_ft" to get a list of foo 
> ids
>  that have the search target tag.  We then build the normal output
>  list by joining that back through the foo_tag bridge table to the
>  tags, and throw out any rows with an output tag id that matches the
>  search target tag id.
>
>  Simple!
>
>  Best of all, the target only appears in the query once, and your 
> name
>  convention means we can use NATURAL JOINs to keep things clean.  It
>  also totally falls apart if you need to search on more than one 
> tag.
>  That's where Relational division comes in.
>
>   -j (who had to draw a picture to get it right)
>
> -- 
> Jay A. Kreibich < J A Y  @  K R E I B I.C H >
>
> "Our opponent is an alien starship packed with atomic bombs.  We 
> have
> a protractor."   "I'll go home and see if I can scrounge up a ruler
> and a piece of string."  --from Anathem by Neal Stephenson
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Doug]

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 haven't kept my sqlite3.def file up to date, but it's fairly recent if you
want to use it.  Since we can't post files to the newsgroup, I'll append it
here.

Doug


EXPORTS
sqlite3_aggregate_context
sqlite3_aggregate_count
sqlite3_auto_extension
sqlite3_bind_blob
sqlite3_bind_double
sqlite3_bind_int
sqlite3_bind_int64
sqlite3_bind_null
sqlite3_bind_parameter_count
sqlite3_bind_parameter_index
sqlite3_bind_parameter_name
sqlite3_bind_text
sqlite3_bind_text16
sqlite3_bind_value
sqlite3_bind_zeroblob
sqlite3_blob_bytes
sqlite3_blob_close
sqlite3_blob_open
sqlite3_blob_read
sqlite3_blob_write
sqlite3_busy_handler
sqlite3_busy_timeout
sqlite3_changes
sqlite3_clear_bindings
sqlite3_close
sqlite3_collation_needed
sqlite3_collation_needed16
sqlite3_column_blob
sqlite3_column_bytes
sqlite3_column_bytes16
sqlite3_column_count
sqlite3_column_decltype
sqlite3_column_decltype16
sqlite3_column_double
sqlite3_column_int
sqlite3_column_int64
sqlite3_column_name
sqlite3_column_name16
sqlite3_column_text
sqlite3_column_text16
sqlite3_column_type
sqlite3_column_value
sqlite3_commit_hook
sqlite3_complete
sqlite3_complete16
sqlite3_create_collation
sqlite3_create_collation16
sqlite3_create_collation_v2
sqlite3_create_function
sqlite3_create_function16
sqlite3_create_module
sqlite3_create_module_v2
sqlite3_data_count
sqlite3_db_handle
sqlite3_declare_vtab
sqlite3_enable_load_extension
sqlite3_enable_shared_cache
sqlite3_errcode
sqlite3_errmsg
sqlite3_errmsg16
sqlite3_exec
sqlite3_expired
sqlite3_extended_result_codes
sqlite3_file_control
sqlite3_finalize
sqlite3_free
sqlite3_free_table
sqlite3_get_autocommit
sqlite3_get_auxdata
sqlite3_get_table
sqlite3_global_recover
sqlite3_interrupt
sqlite3_last_insert_rowid
sqlite3_libversion
sqlite3_libversion_number
sqlite3_load_extension
sqlite3_malloc
sqlite3_memory_alarm
sqlite3_memory_highwater
sqlite3_memory_used
sqlite3_mprintf
sqlite3_mutex_alloc
sqlite3_mutex_enter
sqlite3_mutex_free
sqlite3_mutex_leave
sqlite3_mutex_try
sqlite3_open
sqlite3_open16
sqlite3_open_v2
sqlite3_overload_function
sqlite3_prepare
sqlite3_prepare16
sqlite3_prepare16_v2
sqlite3_prepare_v2
sqlite3_profile
sqlite3_progress_handler
sqlite3_realloc
sqlite3_release_memory
sqlite3_reset
sqlite3_reset_auto_extension
sqlite3_result_blob
sqlite3_result_double
sqlite3_result_error
sqlite3_result_error16
sqlite3_result_error_nomem
sqlite3_result_error_toobig
sqlite3_result_int
sqlite3_result_int64
sqlite3_result_null
sqlite3_result_text
sqlite3_result_text16
sqlite3_result_text16be
sqlite3_result_text16le
sqlite3_result_value
sqlite3_result_zeroblob
sqlite3_rollback_hook
sqlite3_set_authorizer
sqlite3_set_auxdata
sqlite3_sleep
sqlite3_snprintf
sqlite3_soft_heap_limit
sqlite3_sql
sqlite3_step
sqlite3_thread_cleanup
sqlite3_threadsafe
sqlite3_total_changes
sqlite3_trace
sqlite3_transfer_bindings
sqlite3_update_hook
sqlite3_user_data
sqlite3_value_blob
sqlite3_value_bytes
sqlite3_value_bytes16
sqlite3_value_double
sqlite3_value_int
sqlite3_value_int64
sqlite3_value_numeric_type
sqlite3_value_text
sqlite3_value_text16
sqlite3_value_text16be
sqlite3_value_text16le
sqlite3_value_type
sqlite3_version
sqlite3_vfs_find
sqlite3_vfs_register
sqlite3_vfs_unregister
sqlite3_vmprintf



> -Original Message-
> From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-
> boun...@sqlite.org] On Behalf Of Paul Claessen
> Sent: Saturday, July 25, 2009 10:49 AM
> To: sqlite-users@sqlite.org
> Subject: 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 can fix all the pointer casts (shouldn't be necessary if the
> code used more consistent types!), but that would take me a
> lot of time, plus, there should be a way to simply use the .dll: since
> there IS a windows console app, there must be either a .lib
> file somewhere, or there is an alternative way of using DLL's from a
> windows console app, that I'm not aware of.
> 
> Kind regards,
> 
> ~ Paul Claessen
> 
> 
> > -Original Message-
> > From: Pavel Ivanov [mailto:paiva...@gmail.com]
> > Sent: Saturday, July 25, 2009 11:31 AM
> > To: p...@claessen.com; General Discussion of SQLite Database
> > Subject: 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 

Re: [sqlite] .lib file?

[Paul Claessen]

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 can fix all the pointer casts (shouldn't be necessary if the code 
used more consistent types!), but that would take me a
lot of time, plus, there should be a way to simply use the .dll: since there IS 
a windows console app, there must be either a .lib
file somewhere, or there is an alternative way of using DLL's from a windows 
console app, that I'm not aware of.

Kind regards,

~ Paul Claessen


> -Original Message-
> From: Pavel Ivanov [mailto:paiva...@gmail.com]
> Sent: Saturday, July 25, 2009 11:31 AM
> To: p...@claessen.com; General Discussion of SQLite Database
> Subject: 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 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 created
> when creating a DLL. Where can I
> > find that file?
> >
> > Or are there other ways to actually build the above mentioned app, without 
> > such a library?
> >
> > There is a windows test console app, but I can't find the project files for 
> > it. Does anyone have
> them, and knows how to build a
> > simple console app, using the dell, in Visual Studio?
> >
> >
> >
> > Kind regards,
> >
> >
> >
> > ~ Paul Claessen
> >
> >
> >
> >
> >
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Sqlite from ASP?

[Paul Claessen]

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
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] .lib file?

[Pavel Ivanov]

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 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 created when creating a DLL. Where can I
> find that file?
>
> Or are there other ways to actually build the above mentioned app, without 
> such a library?
>
> There is a windows test console app, but I can't find the project files for 
> it. Does anyone have them, and knows how to build a
> simple console app, using the dell, in Visual Studio?
>
>
>
> Kind regards,
>
>
>
> ~ Paul Claessen
>
>
>
>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] .lib file?

[Paul Claessen]

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 created when creating a DLL. Where can I
find that file?

Or are there other ways to actually build the above mentioned app, without such 
a library?

There is a windows test console app, but I can't find the project files for it. 
Does anyone have them, and knows how to build a
simple console app, using the dell, in Visual Studio?

 

Kind regards,

 

~ Paul Claessen

 

 

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Float comparision problem

[Mihai Limbasan]

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: 
http://docs.sun.com/source/806-3568/ncg_goldberg.html

On 07/25/2009 01:32 AM, Guidosss wrote:
> 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-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Float comparision problem

[Guidosss]

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-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Port to C#; Progress report

[Noah Hart]

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
VDBE_PROFILE_OFF


I am currently compiling with the following OMIT options:
SQLITE_MUTEX_OMIT
SQLITE_OMIT_AUTHORIZATION 
SQLITE_OMIT_GET_TABLE 
SQLITE_OMIT_INCRBLOB 
SQLITE_OMIT_LOOKASIDE 
SQLITE_OMIT_SHARED_CACHE 
SQLITE_OMIT_UTF16 
SQLITE_OMIT_VIRTUALTABLE 

I have not ported support for
SQLITE_ENABLE_FTS3
SQLITE_ENABLE_ICU
SQLITE_ENABLE_MEMORY_MANAGEMENT
SQLITE_ENABLE_MEMSYS3
SQLITE_ENABLE_MEMSYS5
SQLITE_ENABLE_RTREE

I now get 0 errors out of 28079 tests in the test harness;
Only 35 more tasks before initial release;

Initial project page is now setup at http://code.google.com/p/sqlitecs/

Full MSVC C# Solution will be released with 2 projects; the shell and the
testharness;
The C# TCL port has also been included as part of the testharness project

I am currently waiting for google to approve changing licensing terms 
from " Artistic License/GPL" to "Public Domain" 


I would anticipating posting the full C# code in the next few weeks

Regards,

Noah Hart

-- 
View this message in context: 
http://www.nabble.com/Pros-and-cons-of-various-online-code-sharing-sites-tp24413069p24655194.html
Sent from the SQLite mailing list archive at Nabble.com.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users