I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
--
F:\2013 YearTech\Yearbook Tools\Resourcesqlite3 -version
3.7.3
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
Who can guarantee what characters are used in all their text strings,
much less guarantee what unnamed transformations windows is helpfully
doing to pipe data.
But that doesn't explain the difference between redirecting to a file
and redirecting to a pipe.
using .output file works
using to direct stdout to a file works and produces the same file as .output
using .read file works
using file does not work.
using | to shortcut and doesn't work.
.once '| sqlite3 new.db'
.dump
.Once is not a command in the version of sqlite3 I use.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
The fcntl.h has been in shell.c since 3.8.6. We are on 3.8.8. Why
not upgrade?
--
Here in the real world, when everything is working, we ask why upgrade.
___
sqlite-users mailing list
sqlite-users@sqlite.org
OK. Dave, please try this patch at let us know if it works better for
you: https://www.sqlite.org/src/info/80541e8b94b7
It needs #include fcntl.h to compile in my sources.
With that, it seems to fix the problem.
___
sqlite-users mailing list
I have a class of database for which using sqlite3 to create
a copy via the pipe method fails. Using an explicit intermediate
file seems to work ok.
I can supply a sample database to anyone interested in investigating.
--
F:\2013 YearTech\Yearbook Tools\Resourcesqlite3 -version
3.7.3
Rather than the full database, can you show us the full schema of this
database, including triggers?
It's a very simple database, no triggers or coalitions. The
problem is most likely a buffer overrun because of a very long
literal string field.
I've sent a minimal sample to drh
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically means the pipe method shouldn't ever be
used on windows.
The pipe method works fine for me on Linux.
I'm guess this is a case of the windows command-line shell doing some
character translations in the pipe, rather than just shipping the
bytes through the pipe unaltered.
Ouch. That basically means the pipe method shouldn't ever be
used on windows.
Not, at least, when your database contains string data with unusual
characters that Windows feels like it should translate for you...
Who can guarantee what characters are used in all their text strings,
much less guarantee what unnamed transformations windows is helpfully
doing to pipe data.
it wasn't possible to drop the index in question
what happened when you tried ? Were you using your own code or the SQLite
shell tool ?
sqlite shell tool. Same complaint, database corrupted.
My guess is that you actually have file-level corruption which just happened
to corrupt data in
The likely cause of corruption is that this is probably a
database being accessed on a networked disk.
--
sqlite select * from preference_table where preferenceset='foo';
sqlite drop index preferenceindex;
(11) database corruption at line 52020 of [2677848087]
(11) statement aborts at 24: [drop
I have a case of a damaged database, where the only damage appears to be
that somehow the index uniqueness constraint is violated. As long as the
operations don't touch the index, the db operates without complaint.
I was eventually able to construct a copy with good indexes, but
1) the generic
Try doing: sqlite3 old-database .dump | sqlite3 fixed-database
Then verify that fixed-database still contains all of your data.
This doesn't work on these databases, even undamaged ones. I think
it's a buffer size problem with sqlite3. The databases contain some
rather long text strings.
...@sqlite.org] On Behalf Of Billy Huynh
...
Hi Dave,
Thank you for info. I'm aware of this. in fact, you could
built an app that run all version of Windows with vs2012 but
you have to install vs2008, vs2010, then vs2012. Since
acquiring license from microsoft with older version of visual
studio
...@sqlite.org] On Behalf Of Billy Huynh
Sent: Thursday, October 30, 2014 11:15 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] New kids on block the SQLite Master Suite.
Thanks Dave,
I have update 3 (there is no service pack anymore with
vs2012) installed. I only see two items
FYI, you can support XP when building with VS2012 if you have VS2012 SP3
installed (which you probably do if you've installed current stuff), and set
the 'platform toolset' (under project properties, configuration properties,
general) to 'v110_xp' (I don't have it in front of me, this is from
as a
convenience. I don't know if you have the capabilty to build on-hand, but a
quick web search revealed this
http://stackoverflow.com/questions/1818678/compiling-the-icu-sqlite-extensio
n-statically-linked-to-icu
Which might give you a leg-up on the process, in particular related to the
ICU extension.
-dave
...
Simon, FYI: this is the 'main' db aliasing problem i
brought up a couple
months ago, which we solved by using your suggestion: re-attach the db
directly after opening it, so that (as Dave said) all DBs
have well-known
internal names regardless of what order they get opened
-steps init()' logic is done for some reason I don't understand.
Otherwise, it looks like a logic error to me. Any advice appreciated.
tia,
-dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
being an alias
for main, and effectively translate the query shown to it's functional
equivalent of:
insert or replace into main.dest ( name, value ) values ('allow',(select
value from main.source where name = 'allow'));
which does work (or both to 'aux' as well)?
Thanks!
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Simon Slavin
...
On 24 Oct 2014, at 9:54pm, dave d...@ziggurat29.com wrote:
Can locking be made more clever to know about aux being an alias
for main, and effectively
aux.source where name = 'allow'));
SQL error: database is locked
sqlite
Looking forward to hearing back from folks. Maybe I should have put this
thread on 'dev', too, so I am dong so now. (Dev q.v. thread on users for
context -- it's short)
-dave
___
sqlite
vendors targetting Windows made their own version of it.
I don't know what the feature is for, but a cursory scan seems to show it's
for a background sorter. I'm also a little surprised there is not a
SQLITE_OMIT_XXX around it, as well.
Oh well, there's always 3.8.6 while you wait for a fix.
-dave
tables.
-dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
, and return an error
SQLITE_CONSTRAINT_UNIQUE, which I presume is the right thing to do.
So, my question is, is this the right thing to do to get INSERT OR REPLACE
on a virtual table, or something else, or maybe that syntax is not supported
on virtual tables?
Thanks,
-dave
...
On 10/18/2014 01:07 AM, dave wrote:
I have a virtual table implementation, and I would like to
use the INSERT OR
REPLACE syntax to simplify actions for the user. In my
xUpdate method, for
the case where insertion is occuring,
...
on a virtual table, or something else, or maybe
Hi,
Is it a reasonable assumption that immediately following a VACUUM command
the freelist_count will always be 0, or maybe 1?
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com http://www.ward
and Wales.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Richard Hipp
Sent: 09 October 2014 17:29
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Freelist count after Vacuum
On Thu, Oct 9, 2014 at 12:25 PM, Dave
smith_waterman_gotoh
soundex_phonetics
metaphone_phonetics
double_metaphone_phonetics
sqlite
//
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org
than
gcc_blabblahblah.)
Even if your checking in of the dll binary was a error, you might consider
continuing it, since it makes it possible for folks like Gert to try it out
(since he is user rather than a developer).
Thanks for making it!
-dave
-Original Message-
From: sqlite-users
easily be wrong; I can't take a peek
at the lib myself right now; but I mention this now on the chance that it
saves some time debugging.
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche
Sent: Thursday
.
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of dave
Sent: Thursday, September 25, 2014 11:59 AM
To: 'General Discussion of SQLite Database'
Subject: Re: [sqlite] A new extension for sqlite to analyze
the existing dll for the benefit
of the community.
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Gert Van Assche
Sent: Thursday, September 25, 2014 12:47 PM
To: General Discussion of SQLite Database
Subject: Re
It does sound like that, like an Object Relational Mapping. And maybe
someone has already done this.
Googling ORM sqlite c++
Yields a lot of existing ORM projects that support sqlite, so maybe Prakash
doesn't need to work so hard on implementing that part of his project
himself.
-dave
sqlite_column functions by type. Then your
record binding would be a vector of those, and you could wrap sqlite_step()
to additionally invoke all transfer() methods.
Have fun hacking!
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun
Hi,
If you can insert into another table then you might want to use a trigger
on the target table. I've done that with good effect (only on low volumes
though, I don't know what would happen on larger volume and if you have
larger volumes).
Cheers,
Dave
Ward Analytics Ltd - information
by 0 result in an error?
Many thanks,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United
that there will be
differences between dbms's, but now that I'm starting to use sqlite I'm
surprised by some of the differences.
Thanks for the info.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address
Yep, same one as me, glad the info helped. I think I may file a bug on
that.
Delphi, I do remember that, and have had rare occasion to use it, though
I've never linked c obj in (or are you using sqlite as a dll?).
Good luck on the rest of you implementation!
-dave
-Original Message
of that behaviour.
Good luck!
-dave
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of
Dominique Devienne
Sent: Wednesday, September 10, 2014 7:14 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Error
There's a class of errors that affect lots of programs, where
backup and/or antivirus software have a file open unexpectedly,
which causes routine operations such as delete and rename to
fail unexpectedly.
I once promoted a fix for sqlite that combatted these problems
by retrying such
There's a class of errors that affect lots of programs, where
backup and/or antivirus software have a file open unexpectedly,
which causes routine operations such as delete and rename to
fail unexpectedly.
I once promoted a fix for sqlite that combatted these problems
by retrying such
version. My apologies if it's starting me in
the face.
Many thanks,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road
, it works really well.
Many thanks to all.
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR
Registered company number
, I know that I could select the rows back to my application, generate
the numbers and then insert rows back into the table but I'm trying to do
this within the dbms.
All help or ideas gratefully received.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118
ROWIDs will be increasing but not that they will be sequential.
I need the values to be sequential.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road
containing tokens starting with any (and
ending with any sequence of characters).
What if I want docids of documents containing the exact literal token any*?
Dave
Sent with [inky: http://inky.com?kme=signature]
___
sqlite-users mailing list
sqlite
than
a suggestion.)
Thanks for an amazing piece of software.
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi,
Why not use the create table if not exists syntax, that way any error must
be classed as 'other'.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road
HI Ulrich,
Sorry I should have made that clearer. I want to save all the data in one
database, not just see it.
Thanks for the idea though.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered
Simon, Many thanks for the clarification.
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR
Registered company
got databases db1 and db2
attached, can I use something like 'insert into db1.t1 select * from
db2.t1;' (assuming that the 't1' definitions are the same !)?
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward
://github.com/koush/sqlite-net/blob/master/src/SQLite.cs#L150
- dave
On Thu, Sep 19, 2013 at 6:22 PM, Joe Mistachkin sql...@mistachkin.comwrote:
Dave Protasowski wrote:
I'm using this library the relevant code snippet is:
https://github.com/koush/sqlite-net/blob/master/src/SQLite.cs#L150
curious if anyone else has encountered this issue.
- dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
.vsix)
- dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
to an equivalent list of products from
the previous week - this then forms the basis of a lot of useful analysis.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road
syntax would fail.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1
?
- especially compared to (say): select field1, sum(field3) group by field1;
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United
, and also the value of field2 that corresponds to the maximum field3
now that is useful.
Many thanks.
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road
contain our 'version
number'.
Yes, there are other ways of doing this. But with a myriad of changes
possible (indexes, column definitions, triggers etc) we've found that the
use of a single place to store our version number makes the checking much
easier.
Regards,
Dave
Ward Analytics Ltd
Thanks Clemens, that is probably a workable option (at least for me).
As someone else noted, the PRAGMA user_version will not work for us as it is
one value per db file and we want to set this per table.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44
Hi Igor,
Many thanks for that.
For this example I'm updating a single column (c2). If I needed to update
multiple columns in the table would I need to use the SELECT construct for
each column?
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118
Ok, thanks.
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR
Registered company number: 3917021 Registered
) as dt1
set c2 = dt1.c2
where t1.c1 = dt1.c2 - 1;
Or
update t1 as a
set c2 = t1.c2
where a.c1 = t1.c2 - 1;
I can't see either of these syntax options in the documentation.
All pointers greatly appreciated.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel
,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR
Registered company
Hi Richard,
Many thanks, that works.
Why do I need the () around my calculation? (apart from 'because that
makes it work' !) I've used other dbms's and don't need them there.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http
that gives me the answer that I'm expecting.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford, Surrey,
United Kingdom, GU1 3SR Registered company
Hi Clemens,
Thanks for the pointer although I'm doing this the other way around. I'm
casting an INTEGER to a TEXT value.
I think Michael is probably on the right track here, this is to do with
operator precedence.
Cheers,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118
an intermediate layer dll (the
sqlite3 plus com dll from eztools). I changed my ' parameterised insert ' so
that I build the QUERYID value into the sql text itself - but I'd like to
try and understand what happened.
All help much appreciated.
Cheers,
Dave
Ward Analytics Ltd
suggestions. I think the typeof, len and hex functions
will probably give me what I need.
Regards,
Dave
Ward Analytics Ltd - information in motion
Tel: +44 (0) 118 9740191
Fax: +44 (0) 118 9740192
www: http://www.ward-analytics.com
Registered office address: The Oriel, Sydenham Road, Guildford
By definition, A % B B. Thus, if B fits into an int (be it 32-bit or
16-bit or otherwise), then A % B would too.
I'm not sure this is *strictly* true if negative numbers are involved; e.g.
-4 % -3 = -1.
But it's still true to say it's closer to zero, and thus should always fit
into an int.
losslessly maintained in a dump - load cycle?
Is there anything else that would negatively affect database performance,
the results of SQL queries or the databases configuration (e.g. WAL mode)?
Thanks in advance,
Dave.
___
sqlite-users mailing list
Is it possible to use triggers for this?
Yes.
Triggers may be created on views, as well as ordinary tables, by
specifying INSTEAD OF in the CREATE TRIGGER statement. If one or more ON
INSERT, ON DELETE or ON UPDATE triggers are defined on a view, then it is
not an error to execute an INSERT,
I can see situations in which you might want to create a new table with a
name that wasn't already taken: at which point simple knowledge would let
you reconsider your choice of table name without affecting the db in any
way, success or fail.
On Thu, Dec 6, 2012 at 10:57 AM, Hick Gunter
If you get no rows returned, you could query SELECT COUNT(*) FROM table1;
(If you get rows returned, you know that the number skipped is the size of
your offset.)
On Thu, Dec 6, 2012 at 11:44 AM, Steffen Mangold
steffen.mang...@balticsd.de wrote:
Hi,
I want to know if there is a possibility
:
m1.b, m1.c, m2.b, m2.c
1,2,1,2
1,2,2,3
2,3,1,2
2,3,2,3
and it compares the middle two columns.
Hope this helps,
Dave.
(PS: I'm not particularly knowledgeable about SQLite, so this might well be
factually incorrect in important minor ways.)
On Tue, Dec 4, 2012 at 1:26 AM, YAN HONG YE yanhong
on the table.
Dave.
sqlite create table jam (valid int);
sqlite insert into jam values (12);
sqlite select [invalid] from [jam];
Error: no such column: invalid
sqlite select `invalid` from jam;
Error: no such column: invalid
sqlite select invalid from jam;
Error: no such column: invalid
sqlite select
On 07/07/2012 22:33, Joe Mistachkin wrote:
Dave Edwards wrote:
Anyone know of any bugs with Mono 2.6 or debian 6 that could cause this
as it might be there rather than here I should be looking?
I seem to recall that System.Data.SQLite does not work correctly on Mono
less than about 2.8
a long time on this and fed up enough to join the users list
(which I should have done at the beginning!) so any pointers greatly
appreciated.
Another note; .isdisposed not in the sqlite.connection ? Testing for is
nothing does not pick up that it is disposed but not nothing
Regards
Dave
On 07/07/2012 17:28, Joe Mistachkin wrote:
Dave Edwards wrote:
For Linux I have recompiled the managed only dll from the .081 source
using: build.bat ReleaseManagedOnly (so no need for the interlop.dll to
be placed in the root folder)
And I have had to mod the built.bat so it runs:
%_AECHO
--
..
Dave Edwards (G7RAU)
email:
d...@g7rau.co.uk
Web:
http://g7rau.demon.co.uk/
..
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Once you have ascertained whether the table exists, what are you wanting to
do next?
Exit?
Or create it and then continue with inserts and so on?
If the latter, you can just do CREATE TABLE IF NOT EXISTS and then keep
going.
~~~
On Sun, Mar 11, 2012 at 8:21 AM, Wei Song 2
Did you mean something like
SELECT ''||text_field||'' FROM table;
so that your column's data is quoted?
~~~
Dave Watkinson
On Wed, Feb 22, 2012 at 6:26 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 2/22/2012 6:03 PM, Bill McCormick wrote:
What is the easiest way to return a text
for free and some
costing in the thousands.
Dave
On 11/29/2011 6:17 AM, Black, Michael (IS) wrote:
I'll note a few things here...
#1 If you want to learn about database design or how to code in language X
get a book on those and not on a particular product (you may want the product book too
.
Small world.
Thanks,
Dave
On 11/29/2011 8:57 AM, Black, Michael (IS) wrote:
You don't need to pay moneythe concepts are available all over the place
For example:
http://search.4shared.com/postDownload/AHGWfQwG/Database_Design_For_Mere_Morta.html
If you ran a BBS on a C64 you may have
Michael,
I found the info on your BBS there too:
http://www.zimmers.net/bbs/aabbs.html
Dave
On 11/29/2011 8:57 AM, Black, Michael (IS) wrote:
You don't need to pay moneythe concepts are available all over the place
For example:
http://search.4shared.com/postDownload/AHGWfQwG
:
SQLite Error
no such table: MyTableName
I have the database in the project folder on my Win7 64 Pro system. The
app, when run, creates an empty database file of the same name as my
database file which is 13KB in size. My SQLconnect.ConnectionString =
data source =C:\Users\Dave\Documents
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit
On 11/28/2011 3:59 PM, Igor Tandetnik wrote:
On 11/28/2011 4:52 PM, Dave wrote:
I am trying to learn VB.Net and SQLite at the same time. I have used VB6
Classic in the past. I have VB Studio 2010 Pro and am just trying to
open a small simple database and have made some progress but hit
that is created just has an icon that looks like a sheet
of paper.
Dave
On 11/28/2011 4:09 PM, Igor Tandetnik wrote:
On 11/28/2011 5:08 PM, Dave wrote:
I just checked and the 0K file that is created is the same name except
it has .db3 added to it's name.
Why is this suprising? Your connection
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
Thanks,
Dave
On 11/28/2011 4:14 PM, Igor Tandetnik wrote:
On 11/28/2011 5:13 PM, Dave wrote:
I just looked again and renamed my original database file back to add
the .db3
Thanks John.
On 11/28/2011 4:18 PM, John Drescher wrote:
You probably have Hide extensions for known types enabled in windows
When this is enabled windows does not display the extension for known
types so that if you have more than 1 file with the same base name they
will appear as the same
and that
doesn't help any.
Cheers,
Dave
On 11/28/2011 4:32 PM, Igor Tandetnik wrote:
On 11/28/2011 5:23 PM, Dave wrote:
Ok, I switched that and now my original database file has a .db added
whereas the one created by my app stays the same.
It doesn't have .db added. It had it all along, you just
Thanks Simon,
Actually, I knew that. Just having a bit of a multiple crash
course...all at once. I just recently built this pc and have been on XP
until recently too. I do some graphic stuff and have many same named
pics with the various .jpg, .bmp, .gif extensions.
Dave
On 11/28/2011 4:37
On 11/28/2011 4:59 PM, Simon Slavin wrote:
On 28 Nov 2011, at 10:44pm, Dave wrote:
On 11/28/2011 4:37 PM, Simon Slavin wrote:
Just to stress that the filename includes the bit after the '.'. You can have
any number of files with the same part before the '.' but different extensions
Thanks Taleeb,
That will get me going until the next question. :-)
Dave
On 11/21/2011 11:25 PM, Taleeb Anwar wrote:
Download the x64 mixed-mode assembly compiled statically against the .NET
Framework 3.5 (as you are using VS2010 on a 64 bit computer). Regarding
targetting x86 users you can
of the installers and kept getting the
following error message:
Which download would be the correct one for me?
Thanks,
Dave
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
of the installers and kept getting the
following error message:
Failed to Install Microsoft Visual C++ Runtime
vcredist_x64_2010_SP1.exe, Asia
Which download would be the correct one for me?
Thanks,
Dave
___
sqlite-users mailing list
sqlite-users
1 - 100 of 353 matches
Mail list logo