First, who said that you had to keep all 6 sets of languages in your head
at once? I've never been told that, and I've been doing software
development since I was 8, taken several training courses in elementary,
high school, college, and while employed by three different companies (At
different ti
I can see why they're doing it as well. Some people have different
preferences to grab the repo. I have a script running on one of my linux
boxes that checks periodically (Once a week? Once a month? I can't
remember) for all links on the SQLite download page. If I don't have the
URL or file si
On Tue, Jun 2, 2015 at 7:34 AM, Richard Warburton <
richard at skagerraksoftware.com> wrote:
> 1) Do I need UID? I'm currently using it to ensure a unique Id for when
> the user is creating a new entry. This however means two operations, an
> Insert, then an Update to set the record's Id to matc
Something JUST changed within the last 60 seconds. I saw what the OP said,
but, it reverted back to the list of download links. Weird.
On Sat, May 30, 2015 at 8:44 PM, Jeff Steinkamp wrote:
> Yep, You will need to download the version best suited for your version
> of .NET. If you have a cur
SQLite4 is a dev "toy". It isn't going to be released any time soon.
On Sat, May 23, 2015 at 6:09 AM, Mikael wrote:
> SQLite4 looks neat!
>
> Last code commit was in September, is this because it's so stable or
> because other priorities took over?
>
> (https://sqlite.org/src4/tree?ci=trunk)
>
{{I just got a bounced message.. Reposting}}
I've been watching this thread from the beginning with great interest, and
I still don't see the difference between using a UUID or an auto-inc
integer as a PK at the very raw, basic level. The database will only see
them as a string of bits or bytes an
I've been watching this thread from the beginning with great interest, and
I still don't see the difference between using a UUID or an auto-inc
integer as a PK at the very raw, basic level. The database will only see
them as a string of bits or bytes and handle accordingly. IMO, using UUID
is an e
On Thu, May 7, 2015 at 12:25 PM, John McKown
wrote:
> On Thu, May 7, 2015 at 10:01 AM, Stephen Chrzanowski
> wrote:
>
> > Although I can understand the sarcasm you're sending out, a client/server
> > infrastructure would be an interesting task for SQLite to do, but
Although I can understand the sarcasm you're sending out, a client/server
infrastructure would be an interesting task for SQLite to do, but to answer
the OP, no, SQLite isn't inherently designed to be a client/server.
But, think of how torrents work. Everyone is a server, everyone is a
client. E
No... Skype doesn't come with ALL versions of Win 7 or later. I've
purchased three copies of 8.1 since Dec and none of them come with Skype.
Two Notebooks with the OS installed as well as an OEM I've downloaded from
MSoft.
I'm not saying that MSoft doesn't have an application or two that uses
SQL
TL;DR
Get SQLite away from networks entirely when you start throwing multiple
machines at the problem. Your last paragraph is probably the best bet if
you're not willing to get into a real client/server setup, and yes, you're
going to run into aggravated users, but, then, which is more important
I'm no where near the level of an overlord, except maybe to the wifes dog.
I'm in a debate mood, so why not? I'm open to the firing squad today. :]
IMHO, there are four (I initially started with two) problems with this
request in making it part of the core dealings Dr Hipp provides us all. I
sa
>From what I understand;
- Read-Only data
- Data doesn't change frequently
- Central repository for data
- Network latency causing issues
My two cents on this is to keep a database revision ID kicking around and
do a SQLite backup of the remote data to a local storage medium. At
application launc
I think the confusion comes down to where the subslect only refers to
exactly one table. That single query has nothing to do with any other
table. There isn't a join, there isn't a reference to any other table, so
the fuzzy question is why would an ambiguous error come up if there is
exactly only
Do you have a working database object that has its hands on the physical
database? At application initilization when opening the database, perform
a simple query against this table, or another, and verify that you are
indeed pulling from the CORRECT database. Do a search on the local file
system
I've not been having problems with duplicates, but I have been randomly
having commoners end up in my spam bucket for one reason or another over
the last 48 hours or so. I've specifically set a filter in GMail that if
anything comes in for this mailing list to NOT go to spam, yet
On Fri, Feb
Dr Hipp;
If you're doing a PR stunt, you should take a lot of these emails and put
them on a "What users say" page and link them to the email thread (If it is
accessible by the public -- I get this list in my email). That way you'd
get real comments about the stability of SQLite against real worl
AFAIK, you can't do 'nested insert', or, insert to multiple tables in one
call. Not from a single command line, or, from a view. You're pretty much
stuck with updating one table at a time.
It would be nice, however, problems can come up with a many-to-many
situation where the engine isn't sure wh
GMail has constantly and randomly flagged different messages from this
mailing list as spam. I set a specific mail rule to force the mail to NOT
be flagged as spam. The nice thing is, GMail also tells me when the
message SHOULD have been put into spam but because of my mail rule, the
message ende
Maybe with a query or two extra, you can determine a temp table, then build
on that. Do an initial distinct look up on the primary fields you want as
the fields in your temp table and create it, then do the required queries
to get the raw data into the temp table, then do the finalized query to ge
Wrong answer.
He's asking how many bytes a table takes up within the database. That
would depend on a whole lot of factors including what is stored, the number
of fields, etc.
Is there SQL code to get requested result?
Short answer, No. Not easily.
Long answer, a table isn't a certain number
On Fri, Jan 30, 2015 at 8:07 AM, Mario M. Westphal wrote:
>
> When a user encounters the problem he/she restores the last working
> backup. I have a few users who faced this problem more than once. Here I
> always assumed some hardware glirch, a shaky USB connection, disk trouble,
> network probl
On Thu, Jan 29, 2015 at 2:07 PM, Mario M. Westphal wrote:
> Most database damaged errors encountered over time could be pinned to
> power failures, disk or *network problems*.
>
>
Network problems? I might have missed a good chunk of this thread, but,
this begs to be asked Are you runnin
In the 8.3 days, I routinely gave directories an underscore as a delimiter
for version information, prior to my actually using a version control
package. So "game" would be the main thing, and if I wanted to test,
"game_1" became the new WIP folder. If I liked what I did, I'd move "game"
to "game
What kind of times are you looking at, and, what is the data being written
to?
On Sun, Jan 18, 2015 at 9:49 PM, Wei, Catherine
wrote:
> Hi, I'm running a software in a set-up box with linux system and find
> that every time when I commit transaction, sqlite takes too much time
> when it executes
Although SQLite can be used in a server type situation, it is more geared
towards being an embeded database solution.
A couple of links you should read over:
- http://sqlite.org/whentouse.html
- http://sqlite.org/howtocorrupt.html
On Mon, Jan 5, 2015 at 8:04 PM, Saffa Kemokai wrote:
> Hi Ever
Maybe the question is "How do I make SQLite do this when accessing a
database?" and the 3 just got dropped inadvertently. If that is the case,
as Dr. Hipp said, SQLite has never done it, and I'll add on that it has
never done it "stock".
On the other hand, that link you posted, Dr. Hipp, is rathe
For your second point, SQLite4 "may" never be released, or if it is going
to be, not for a few years yet. 4 is a toy for the devs to try things out
without borking things up in 3. 3 is being used by millions (or is it
billions?) of devices and applications that the dev team is (very right) in
not
That'd depend on the size of the database, the medias speed you're writing
to, and what kind of actions are happening during the backup.
If your file size is in the GB range, and you're transferring over a
100mbit switch, if you have a SINGLE write per minute, your backup is going
to restart. Rea
You didn't provide the data set, so it'll be a guess.
You'll need to look at the data and do some mental work on comparing what
you expect versus what your query result comes back with, and prove what is
in the database is what your query is EXACTLY asking for. (Returning on
last names of Smith?)
yet, so I might be missing a few
tidbits of information both in what I've written above, as well as the
mental think-through when I wrote it. :]
On Wed, Dec 3, 2014 at 9:23 AM, Simon Slavin wrote:
>
> On 3 Dec 2014, at 2:20pm, Stephen Chrzanowski wrote:
>
> > Although I thi
Although I think there is already an error result, one situation might be
when the DB is in a read only state.
On Wed, Dec 3, 2014 at 6:15 AM, RSmith wrote:
>
> On 2014/12/03 13:00, Jonathan Moules wrote:
>
>> Hi,
>> Just a quick request/suggestion.
>>
>> Currently SQLITE_BUSY events return an e
Try? Don't use a network. It isn't safe due to file locking mechanisms
(As you've noted) at the server side, not the client side. The other
option is to either build a SQLite server where the local database store
is, or, get MySQL/MSSQL up and running.
https://www.sqlite.org/whentouse.html
Spe
If you're using SQLite3.exe (or equivalent CLI - Command Line Interface)
then by default the database id written to memory, not to the disk. Doing
something like [ sqlite3.exe test.db3] will create a test.db3 file once you
do an actual transaction like creating a table. I THINK even doing a
selec
>From a mathematical standpoint in your example, going back to grade 4 math
(35 years ago for me. *sigh*. I'm so sad), where clause works based
off of standard order of operations based on BEDMAS and eventually working
things down to booleans. In your example, the math would be processed as
3
As mentioned, temp tables are connection based, not database based.
I can think of two ways of getting around this.
Expose your child thread database object to your main thread. Then have
your main thread do what it needs to do with it. I wouldn't entirely
recommend this as it breaks scope, not
If you're asking "if a field on a row contains a value that was previously
defined a value due to the DEFAULT value in the schema, would this value be
changed if the in the schema later changed", then no, it doesn't change.
There is no reference to the default value in the schema once the data has
Another method beyond what was suggested above/below would be that since
the / could be considered a delimiter, you could consider each field a word
and insert each word into a separate table and index each word. Have
another table reference the indexed word to match whatever table you've
mentione
You did that per connection?
On Sat, Oct 25, 2014 at 10:02 AM, Ali Jawad wrote:
> Thanks for the input, I did add PRAGMA busy_timeout=1500; before any query
> but I am still getting loads of locked database errors, please advice
>
___
sqlite-users mail
Perfect. Thanks guys.
On Sat, Oct 25, 2014 at 10:03 AM, Simon Davies wrote:
> On 25 October 2014 14:49, Stephen Chrzanowski wrote:
> > I've got a table that has defaults set for all fields
> >
> > CREATE TABLE [tEvents] (
> > [EventID] INTEGER NO
I've got a table that has defaults set for all fields
CREATE TABLE [tEvents] (
[EventID] INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
[Airline] CHAR DEFAULT '',
[TicketID] INTEGER DEFAULT 0,
[Resolved] BOOL DEFAULT 0);
Seems to me it'd be a bit redundant to do an "insert into tEvents
(Tic
Ahh.. Thanks Richard. So if you were to have blobs live at the front of
the row, it'll have to read through that blob to get that byte in the next
field, correct?
On Sat, Oct 25, 2014 at 8:31 AM, Richard Hipp wrote:
> On Sat, Oct 25, 2014 at 8:15 AM, Stephen Chrzanowski
https://www.sqlite.org/vtab.html
I was trying to understand what Virtual Tables are, and how they'd benefit
me in a new app I'm building, but I noticed that the numbering system on
the page is incorrect, or, they slipped something into my coffee this AM.
(I should thank them if they did!)
The Imp
Make sure H11 has an index on it. Also ensure that ToricCY doesn't have
blobs attached to it. Throw the blobs into a different table and use a 1:1
relationship to link them, then only pull the blobs when needed.
SQLite apparently will load an entire row of data out of the database, even
if the q
Saying I 'would like this type of join' is something I say very lightly.
By that I mean it'd be good to see them, but, really, I'm not going to put
any pressure on anyone to get it implemented.
I'd been using these joins in SQL2K for years before I found out about
SQLite and a lot of what I was do
I have no idea what is 100% required in the database, but I THINK you can
include some compiler directives that REMOVE certain features. I know FTS
is an optional thing, but I don't know if it is included as part of the
default build or not. CTE (I think that is it?) might also be something
you c
Careful with the timing. You may be looking at OS memory caching the
result set instead of pulling from the drive. For best bets, either re-run
both queries several times, ditch the longest and shortest times, then take
the mean or average times and do the comparison that way.
On Wed, Oct 15, 20
I've got three options, two of which require an internet connection, one
part time, the other full time. The third option has the constraint on the
size of the data in question.
- Have your preference of a resultant hash check in a plain text file
sitting somewhere on your web server. The applic
Views, yes. Stored Procedures, no.
On Thu, Oct 9, 2014 at 1:04 PM, Omprakash Kolluri
wrote:
> Hi,
>
> I am new to SQLite. I am working on an app that I am developing and plan to
> use SQLite as an embedded database. My Question - Does SQLite support
> stored procedures similar to those in MS SQ
I'm assuming you're measuring something from each unit (I'm guessing
device?) out on the field?
Taking a quick glance at your table, I could see three tables being created
to normalize things out. You have particular units at a particular
location. That can be one table. Another table would be
I wouldn't call it 'magical' if the definition is right on the field
declaration, and depending on the 'worth' of that particular bit of data
(Booleans in this case, and I've got absolutely zero concern to the actual
state of said boolean, but taking into consideration the typeless nature of
SQLite
If the field def'n were to be changed to [ col2 NUMBER DEFAULT ON NULL 0 ]
and then when I insert/update something that becomes NULL and the result
becomes 0 for that field, then yeah, bingo.
On Wed, Oct 8, 2014 at 2:14 PM, Petite Abeille
wrote:
>
> On Oct 8, 2014, at 6:14
On Wed, Oct 8, 2014 at 1:26 AM, Simon Slavin wrote:
>
> You could probably use a TRIGGER that detects the type of row you don't
> want and replaces it with your preferred form. This doesn't do exactly
> what you want, but it is something like it.
>
>
That'd work, but extra effort and more potent
I'm making up a small database (for yet another tool I never plan on
releasing) and during the table creation, I had a thought about the "Not
Null" and "On Conflict" resolution mechanism.
When adding a NULL value to a table that has the NOT NULL flag set on that
field, instead of raising an except
I've read through the rest of the thread on this so far. I like the linked
list idea, as updating three rows seems to be the better way of doing
things, but the question does remain 'what drives the sort reasoning?',
however, if you don't want to get that deep into CTEs and stuff for the
linked li
In the vein of configurability, and in a day dream I just had, it would be
nice (But probably not possible as there could be compiler directives you
can't use at the same time) that we could have a single output
DLL/SO/whatever dumped from the compiler that had everything available,
then, via defau
I disagree with adding version info or dates of inclusion for things are
added to the language. The fact that the code is there should be good
enough, and if you need to know when something was added/removed/modified,
the aforementioned doc will tell you. When something was added isn't as
importa
I, as well, wish to thank you for this tool Dr. Hipp. I've never published
a public application using this engine, but, at my place of employment,
where my primary responsibility is to just monitor servers world wide, I've
coded a few tidbit web and desktop applications that have made my job SO
mu
When you do add scripts, put them on pastebin or something of the sort as
this mailing list doesn't always allow attachments. (I've seen one or two
slip through the cracks)
On Fri, Sep 19, 2014 at 1:20 AM, Prakash Premkumar
wrote:
> Thanks a lot Richard for your help. I apologize for not includ
I've run into this kind of issue with another IDE, not dealing with
SQLite. The issue came down to package/code/something-or-other that was
once upon a time on an old installation of the IDE that I ported in then,
but now, after a fresh install of the same IDE, it wouldn't work. My only
resolutio
Wouldn't it come down to the compiler you're using that'd indicate the
number of bytes associated to an integer type, or at least tell the
compiler to compile integer types to 64-bit?
On Sun, Sep 7, 2014 at 1:02 PM, skywind mailing lists <
mailingli...@skywind.eu> wrote:
> Hello,
>
> I have seen
Chances are its Windows UAC that is coming into play. You've got three
choices;
- Disable UAC entirely (UAC - User Authentication Control or some jazz like
that)
- Have the installer put your program that is NOT in a protected directory
(c:\Program Files; c:\Program Files (x86) for instance)
- Pu
Untested, but first whack at it;
select * from yourtables order by ifnull(billdate,bdate)
Criteria met:
- A date posted prioritizing billdate and then bdate
- Sorted based on date
On Mon, Sep 1, 2014 at 1:55 AM, Keith Medcalf wrote:
>
> >>I have to create some reporting and I need to report
*thinks back to IE1 and Netscape*
Its just starting??
On Tue, Aug 12, 2014 at 7:15 PM, jose isaias cabrera <
jic...@cinops.xerox.com> wrote:
> "Stephen Chrzanowski" wrote...
>
> Thanks Jose, this looks to be like a browser issue. Tried with Chrome and
>> th
erBird and
even gone with Outlook, but after a few UI decisions on their end, decided
to just stick with the browser. I loath ribbons.
On Mon, Aug 11, 2014 at 4:40 PM, jose isaias cabrera <
jic...@cinops.xerox.com> wrote:
> "Stephen Chrzanowski" wrote...
>
>
> Ok,
Ok, this IS NOT about SQLite itself in ANY regard, but specifically about
this particular mailing list and how GMail is handling itself.
When I joined this mailing list years ago, I put anything that goes through
here into its own label via the same means that I've got for other email I
regularly
It "smells" like that you're running into general timing issues, especially
if you're consistent with how long it takes to put info into the database.
If we were to take your scenario of 100 threads of writing to memory,
bashing the hell out of the database for writes, the first thread is going
to
om inside a large company, whereas using client-based logic
> avoids this.
>
>
> On 2 August 2014 09:27, Stephen Chrzanowski wrote:
>
> > I understand that with routing and such, you can end up outside where you
> > really are (With my IP, I'm shown just outside of Toronto
I understand that with routing and such, you can end up outside where you
really are (With my IP, I'm shown just outside of Toronto when I'm actually
two hours out), but the chances of showing up in Taiwan when you're in
Tennessee is doubtful. The point of the matter is that you'll get real
time d
Attachments aren't permitted in this group. Please put the upload
somewhere else and provide a public link.
Step-Trace your application to make sure that you're not spamming up
'opening' connections. I've written a lot of programs with Sqlite3 (Up to
3.7 I think, haven't upgraded as of yet, but
Looking back at the clarification of what the OP wanted to do, I've got
this to recommend;
If your users are talking to your server via the internet and not via a VPN
connection, instead of relying on what time zone your users browser is
giving you, look at what IP they're calling in from and do a
Of course, I've not seen the code, but, I'd throw in that a command line
option be added that'll force a particular mode. By default, it is 'as is'
right now being platform dependent, but, if a CLO is added, either mode is
forced, or toggled. I'd ask for separate toggles for forced or toggle. :]
I took a course back in the day when MSSQL-2000 was just coming out, or
just had come out. I learned the nuts and bolts (Right down to the freak'n
file format used at the time -- Ironically, that was the best part and I
did enjoy that the most), the concepts, the attitude, and the mentality of
MS-
By the sounds of it, the OP wants a spreadsheet app, that isn't a
spreadsheet app, acts like a database, but isn't quite a database, looks
simple to use, but provide editable information in a reasonable format.
To bring up a point about Google that RSmith brought up, Google Docs has a
spreadsheet
I agree with Simon, there is no direct way to export your data as SQL
commands. But there are a few things you can do;
1> Code it out yourself, but you'll need to be aware of how you're dealing
with the order you need
2> As you're making changes to the database, write out the
inserts/updates/dele
Caching or not, I don't experience the same thing with opening a read only
text file in Notepad. For S'n'Gs, I had a random text file sitting on my
desktop (A config file for a game, and it is pure text) and decided to use
it as a subject of abuse. Its original attribute is set so read only is
OF
SQLite is a desktop application, not a network aware application. The file
locking mechanisms lie to SQLite which makes it an EXTREMELY HIGH CHANCE
that connectivity and any WRITE statements WILL cause data corruption.
This isn't the fault of SQLite but the network file system locking. AFAIK,
th
Read Only mode is going to cause initial lag. I've written an analysis to
what I saw at least on a Windows machine several months ago. I didn't try
a Linux machine I don't think, but I can re-do it if anyone is interested.
That analysis was done on a local drive (RAID-0 SSD setup), not on a
netwo
@OP: This isn't meant as something to be meant as mean, but I'd recommend
taking an online course for SQL in general. There are some free sites,
there are a lot more paid sites. I did my SQL training back when SQL 2000
was just coming out, and I paid 5 digits for the course. Those five digits
we
You shouldn't access a SQLite database remotely, except maybe for read only
access, but that could come under fire. Any network file action can't
guarantee that write locks happen.
If you attempt to access a file in READ-ONLY mode, you'll be greeted with a
1-5 second delay (I don't remember what
Technically, SQLite thinks STRING = INTEGER as far as field definitions are
concerned, but either int or integer will do the job.
On Thu, May 15, 2014 at 2:22 AM, Werner Kleiner wrote:
> What I mean is: The original MySQL DB has columns with int(10). And the
> converting tool converts all these
SQLite isn't OS dependent. It also isn't directly subject to a virus, so
to speak. Think of it as a plugin for a web browser, or DLC for a game, or
similar sorts. You take the SQLite Library and either compile the source
code into your program, or, you link it to DLL files. SQLite already
relie
Short of writing a server type application that listens for incoming
communication, I'm not aware of anything of the sort. SQLite is an
embedded library which compiles with your code, or, with references to
external libraries installed on your local machine. SQLite doesn't behave
well with ANY so
SQLite Expert has a free version that can be used. Certain UI features are
missing, but, it does allow for excel like table editing. Its also MUCH
cheaper than anything Microsoft has put out, even with their "dealer
discounts" and "oem" sales with proper hardware purchases.
On Tue, Mar 11, 2014
Apologies for the interruption and sort of off topic, but, is .timer part
of the CLI only or is it part of the SQL language? Can I get the result of
a timer from a call, or do I have to put a wrapper on my wrapper?
On Sun, Mar 9, 2014 at 8:17 PM, Keith Medcalf wrote:
>
> sqlite> create virtual
Its gotta be great to see your code end up in a TV show and have an actor
say "There's you're problem" and you get to say "Not in my code!". That
would have been epic to be sitting there for that particular event as a
bystander. heh
On Sun, Mar 2, 2014 at 6:39 PM, Darren Duncan wrote:
> On 3/2
Information on how to open SQLite files:
http://www.sqlite.org/c3ref/open.html
How the locking mechanisms work: http://sqlite.org/lockingv3.html
Specifically, it'll depend on the language or wrapper you're using to
access the database. In my case (Delphi) there is an option in the open
function t
If you write your information to the cheap* USB key instead of the SD card,
from a mile-high view, you're looking at a bad data disk instead of a bad
OS disk. You could backup daily your USB version of the database to the SD
card, or to a network drive (If available) so then you're only writing to
There are a few reasons for the two-database method would be useful versus
a single database connection, depending on the volume of data in the pot.
1> Having a single hourly database will keep the database size minimal.
~8000 entries holding just temperature data, it'll be small so I can't see
a
Three thoughts;
*First*, buy a bulk amount of cheap, inexpensive USB keys and start
throwing your data at the key instead of your OS's card. I'm not 100%
clear on how a USB key handles itself as far as writing to certain parts of
its memory, but you could partition off chunks of space and just mo
Lets not throw honey at the problem when a bear is around. Some of the
things I've seen in this thread just makes it sound like the kitchen sink
should be included in this application.
I don't like the idea of letting the software decide what should be done
based on a configuration file. Linux a
Personally, I don't buy that DropBox is the culprit as I've done this kind
of thing a few times in a few applications of my own, however, I'm the
single user that works on that single account, and any app that uses DB is
usually under development and "closed" on any other geographical site.
However
I was just going to suggest that John. Short of hitting CTRL-C to break
out of the program, the user may have to "double-quit" if no file path has
been given to be saved to, just for confirmation.
> .q
!!Warning - In-Memory Database not saved. Quit again to exit without saving
> .q
C:\Users\Defa
Jan 31, 2014 at 8:49 PM, Stephen Chrzanowski
> wrote:
>
> > I've not done anything to 'generate' a SQL statement, but I can see the
> use
> > of this just as a debugging tool to figure out why something is taking so
> > long. I might just implement that i
On Fri, Jan 31, 2014 at 12:05 PM, Simon Slavin wrote:
>
> However, you also mention that your app generates its own commands.
> Unless you can predict things about these commands ("90% of the time users
> are going to want to sort by date") you're not in a good place to figure
> out what indexes
ing of some of the syntax. But this is great! thanks.
>
> Stephen Chrzanowski" wrote...
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I don't use .NET anything, so I can't speak on it. However, with my
wrapper in Delphi, if I store a value as 1 or '1', returning a .AsInteger
will succeed. The wrapper is smart enough to decide if it is actually a
number. I don't recall if it'll throw an exception if the value in the
database is
Untested and only from the SQL compiler in my brain -- This compiler is
known to have a few bugs -- It may also be too late to go use this, so this
might be something to look at if you plan on upgrading;
This is the first way I'd do it;
create table Projects (ProjectID INTEGER PRIMARY KEY AUTOINC
What exact Disk I/O error are you getting? There are many different types.
- Permissions to read are denied
- Invalid characters in the filename
- Corrupted database
etc
On Thu, Jan 30, 2014 at 10:19 AM, Akintoye Olorode (BLOOMBERG/ 731 LEXIN) <
aolor...@bloomberg.net> wrote:
> Hi,
>
> We have
Just to make it crystal clear, to a developer actually calling the SQLite
functions (I'm talking about [ PrepareSQL_v2 ] and such, not [ select *
from table ]), SQLite is TYPELESS which means there is no data type that is
kept track of for any field. This means that even if you define a column
as
301 - 400 of 509 matches
Mail list logo