Hi, I was just wondering when creating a view, if you could declare a column
as primary key on the view or add in an extra column like viewID?
The reason being is that I am working with the finisar ADO.Net wrapper which
is unable to build commands on tables/views that do not contain primary
keys.
Hi all, thanks for the infor on foreign keys, helps a lot.
Thanks again
John
On 10/08/06, A. Pagaltzis <[EMAIL PROTECTED]> wrote:
* John Newby <[EMAIL PROTECTED]> [2006-08-10 00:25]:
> it recognises them if you put them in your create table
> statement but it does not enf
FOREIGN KEY constraints are parsed but are not enforced.
Hi, what does the above statement on the SQLite website mean?
Call me stupid but I do not understand the word "parsed", I was thinking it
meant, it recognises them if you put them in your create table statement but
it does not enforce them
Hi Jay, I will be writing about the technical details within the
implementation stage of my report, but I wanted to write about the
architecture in the design part of the report.
Thanks for your advice.
John
On 07/08/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 8/7/06, John Newby &
logic. Additionally
you have a set of predefined functions, which perform queries upon the
data
sources and return the results as objects. In most cases these are only
access layers, which use a database server and stored procedures.
HTH,
Mike
-Ursprüngliche Nachricht-
Von: John Newby [
Hi, this is probably a stupid question and it has nothing to do with SQlite
per se so I apologise in advance for hijacking the emails withmy question
plus I don't even know if this is the right place to ask the question.
I have created a GUI to SQLite using VB.Net for my University project and it
Hi Gerry, thanks for this info, much appreciated.
John.
On 07/08/06, Gerry Snyder <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, can anyone direct me to the right page relating to the sqlite_master
> table please, I am unable to find it on the website.
I do not know of a sin
Hi, can anyone direct me to the right page relating to the sqlite_master
table please, I am unable to find it on the website.
Many thanks
John
Hi Igor, thanks for your help.
Is the 'WHEN' clause used very often when creating triggers or do you think
I could get away with leaving it out?
I am unsure as what to put in the expression part of the WHEN clause in
order to test it thoroughly.
Also does anyone have a test database I could use
Hi, I am creating a GUI to SQLite for my final year projectat University so
that the user need not know SQL in order to create a database.
I am having trouble when trying to create triggers. The example shown on th
SQLite website only shows one example for "UPDATE OF" which seems to be the
easis
Hi Nuno and John, thanks for the tips, I'll look into it.
John
On 27/07/06, John Stanton <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, I was wondering how I could use the commands specific to the
> command-line interface with the dll version.
>
> The commands I a
26/07/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
Dennis Cote <[EMAIL PROTECTED]> wrote:
> John Newby wrote:
> >
> > Is there any other names I need to look out for other than the
> > "sqlite_" and
> > "table" that SQLite doesn't like as
Hi, I was wondering how I could use the commands specific to the
command-line interface with the dll version.
The commands I am wanting to use are as follows :-
.dump
.import
.output
.read
Any help would be greatly appreciated
Many thanks
John
Hi Dennis, thanks for this, I've just spent the last 30 mins typing in every
word I could think of that might have come up with a conflict, it was
nowhere near as big as the list in the link.
Thanks for the tips.
John
On 26/07/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
John
Hi Jonathan, yes you are right, thanks for this, I'll just put a check for
them all as you never know what a user is going to do its better to try and
fix it beforehand.
thanks again
John
On 26/07/06, Jonathan Ballet <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi Jonathan,
names I need to look out for other than the "sqlite_" and
"table" that SQLite doesn't like as being a table name that anyone knows of?
Thanks again
John
On 26/07/06, [EMAIL PROTECTED] <
[EMAIL PROTECTED]> wrote:
"John Newby" <[EMAIL PROTECTED]> writ
Hi, I've took the following quote from the SQLite website stating that
"Tables names that begin with "*sqlite_*" are reserved for use by the
engine" and if you try to create a table beginning with this it lets you
know about it, but what about tables called "TABLE", this throws back an
error stat
ve a more
significant change to make, I've found it more useful to rename the original
table, create the new table, select data from old to new, and drop the
old. But that requires knowing both the old and new schemas.
-Clark
- Original Message
From: John Newby <[EMAIL
http://www.sqlite.org/faq.html#q13
Hi, the above link goes to an FAQ on the SQLite website stating that the
ALTER TABLE command has limited functionality and recommends creating a temp
table and copying everything there, dropping the original table, re-creating
it with the desired changes and cop
Hi all, I would like to thank you all for helping me with my problems. I
have managed to obtain the details from the SQLite DBMS that I required.
The problems I am having now are predominantly VB.Net(and my lack of
understanding of the language) related so I will leave you all now as this
thread
nd its Container classes...
Mike
-Ursprüngliche Nachricht-
Von: John Newby [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 13. Juli 2006 18:10
An: sqlite-users@sqlite.org
Betreff: Re: [sqlite] How do you find out the names of the fields within a
table?
Hi Craig, thanks for your comments, but I c
x27;s "Daddy" (Quick Basic) years ago.
> -Original Message-
> From: Martin Jenkins [mailto:[EMAIL PROTECTED]
> Sent: Thursday, July 13, 2006 8:08 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] How do you find out the names of the
> fields within
> a ta
Hi Fred, I am using vb.net 2002. I am not sure about dynamic arrays, I am
looking into it now
Many thanks
John
On 13/07/06, Fred Williams <[EMAIL PROTECTED]> wrote:
What language are you using? Can't you do a dynamic array?
> -Original Message-
> From: John New
Catch es As Exception
MessageBox.Show(es.Message)
End Try
i += 1
End While
sqlite_datareader.Close()
Return fieldNames
End Function
On 13/07/06, Martin Jenkins <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> I would still need to
help
John
On 13/07/06, Craig Morrison <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi Craig, I have looked into the dictionary that you suggested, but
> wouldn't
> this be the same as the array as I would still need to know how many
times
> to go through the while loop t
n my array.
Do you know of a way I can do a select on the information brought back with
the pragma command?
Many thanks
John
On 13/07/06, Christian Smith <[EMAIL PROTECTED]> wrote:
John Newby uttered:
> Hi Martin, I'm not sure, I don't use VB that often, I just need to use
i
wrote:
On 7/13/06, John Newby <[EMAIL PROTECTED]> wrote:
> Hi Nuno, I'm using VB.Net 2002 so I don't think I can use these
commands.
And what about doing a "SELECT * FROM your_table_name LIMIT 0" ?
Does your sqlite wrapper returns the column names?
If it doesn't,
ich I already
know how to do with an array.
Many thanks
John
On 13/07/06, Craig Morrison <[EMAIL PROTECTED]> wrote:
Martin Jenkins wrote:
> John Newby wrote:
>> Yeah I can get the names, but I need to put them in an array, and to
put
>> them in an array I need to know the
ECTED]> wrote:
John Newby wrote:
> Yeah I can get the names, but I need to put them in an array, and to put
> them in an array I need to know the size of the array to store them in,
> so I
> need to get a count first, then store this number as the size of the
array
> before I store
/06, Christian Smith <[EMAIL PROTECTED]> wrote:
John Newby uttered:
> Hi, how can I find out the names of the fields within a given table?
>
> I've tried "pragma table_info(test);"
>
> but this brings back too much info, I just require the names as I'l
Hi Nuno, I'm using VB.Net 2002 so I don't think I can use these commands.
Many thanks
John
On 12/07/06, Nuno Lucas <[EMAIL PROTECTED]> wrote:
On 7/12/06, John Newby <[EMAIL PROTECTED]> wrote:
> Hi, how can I find out the names of the fields within a given tabl
Hi Kees, I'm writing it in VB.Net 2002.
I think I've got somethign nearly working now, but I need to somehow get a
count of how many fields is in the table, or how many rows the pragma
command brings back so that I can give the array a number before I can fill
it. Does anyone know the name of th
Hi, how can I find out the names of the fields within a given table?
I've tried "pragma table_info(test);"
but this brings back too much info, I just require the names as I'll be
storing them in an array within my application.
Many thanks
John
Hi Dennis,
Yeah I know, I have posted several VB forums regarding this matter, I was
just hoping there might have been an SQLite user that may have came accross
this in the past. Sorry to have bothered you all.
Thanks again
John.
On 11/07/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
use proprietary programming languages
and can not provide assistance with Visual Basic.
On Tue, 11 Jul 2006 12:00:34 +0100, John Newby wrote:
>Hi, thanks for your speedy reply,
>Yes, you have understood my code correctly, this is the create table
>statement, and at the time of execution all
he create table statement execution until all columns
are
known and can be included inside the parentheses, or
2. perform the create for the first column and then use the alter
table
statement to append remaining columns, perhaps one at a time.
---
On Tue, 11 Ju
Hi, I am creating a front-end to the sqlite DBMS using VB.Net 2002. I have
managed to get the name of the table, field names and types from user input
displayed into a listview but I can only get the Create table command to
accept the last input values, so if the table has more than one field(whic
http://www.sqlite.org/faq.html#q13
Hi, SQLite FAQ recommends creating temp tables and copying the data from the
original table into it then deleting the old table then recreating the old
table (with the desired new column) then copying the data back and deleting
the temp table.
On 19/06/06, Anis
Yes please, I am using vb.net but I should be able to work through and see
whats going on and transfer it to my project.
Many thanks for your help.
John
On 15/06/06, Noel Frankinet <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, I don't know if you can remember but I
your
virtual listview please.
Also would the virtual listview allow for amendments/deletion/insertion of
data and recognise the change and update the database accordingly.
Many thanks
John
On 10/05/06, Noel Frankinet <[EMAIL PROTECTED]> wrote:
John Newby wrote:
>Hi, I am trying to a
no
On 04/06/06, Dave Dyer <[EMAIL PROTECTED]> wrote:
>
>I think this is a very reasonable assumption.
It's a lot easier to drive if you assume you're the only
car on the road.
works fine for me, obviously as it says, it is not yet available in your
country, I live in the UK and it works here.
On 04/06/06, imcs ee <[EMAIL PROTECTED]> wrote:
the url returns
"
Currently, the playback feature of Google Video isn't available in your
country.
We hope to make this feature
yeah didnt even notice that, glad i got it right, thank god for the spell
checker!! lol.
On 31/05/06, Bob Dankert <[EMAIL PROTECTED]> wrote:
Especially considering they are all spelling the word wrong with the
same mis-spelling.
-Original Message-
From: John Newby [mailto:
whats with all these unsubscribe messages, they're beginning to do my head
in now!!!
On 31/05/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]>
wrote:
unsuscribe
Hi, I am trying to open a database, using the input database name given by
the user, if I run the testDB() function where the source of the database is
given, it works fine, but if I try to use the createNewdatabase() function,
passing back the string with the filename from the input and it doesn'
Hi Robin, have you looked here, there are many wrappers for SQLite
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
this one in particular mentions "any ActiveX language such Visual Basic"
http://vfornazin.ipdz.com/
hope this is of help to you
john
On 22/05/06, [EMAIL PROTECTED] <[EMAIL PR
Hi, I have managed to display the data into the datagrid using a dataset,
many thanks for all your help.
John.
On 10/05/06, John Newby <[EMAIL PROTECTED]> wrote:
>
> Hi Michael, I am already using the Finisar.SQLite wrapper, I can
> successfully connect to the database, create
Hi, I know how to create a databse from a DOS prompt by going to the
directory the .exe file is and by typing sqlite3 name.db which then creates
the database, but what I do not know is how to create a database from my
application I am building using VB.Net using the .dll file, I can
successfully co
e one single issue with it - look for the
> subject "Transactions and 'library routine called out of sequence' locks
> the database" in this list).
>
>
> /Michael
>
> -Original Message-
> From: John Newby [mailto:[EMAIL PROTECTED]
> Sent: 9.
Hi, I am trying to access a SQLite database using the ADO.Net provider and
bring all the data back in a tabular form, I can bring back the data using a
datareader but I don't know if I can put the data into a datset or a
datagrid.
Does anyone know if you can do this?
Many thanks.
John.
Hi, I am having some trouble displaying the data from a database in my
VB.Net application, I am using the Finisar ADO.Net wrapper to connect to the
SQLite database. I can display the data using messageboxes and textboxes so
I know it's working, I just can't figure out how to display it in somethi
Hi Dennis, thanks for this.
John.
On 05/05/06, Dennis Cote <[EMAIL PROTECTED]> wrote:
John Newby wrote:
> Hi, how do you get a list of all the table names within SQLite?
>
> Many thanks.
>
> John.
>
John,
From the sqlite shell use the .tables command.
From SQL code
Hi, how do you get a list of all the table names within SQLite?
Many thanks.
John.
]> wrote:
- Original Message -----
From: "John Newby" <[EMAIL PROTECTED]>
>Hi Robert, thanks for the advice. I'm using either the 2002 or 2003
>version
>(not sure what the University registers to) My supervisor recommended I
>use
>the finisar one instead of yours
ion 2 (correct me
if im wrong)
So do you recommend I replace the older dll version?
On 05/05/06, Robert Simpson <[EMAIL PROTECTED]> wrote:
- Original Message -----
From: "John Newby" <[EMAIL PROTECTED]>
>No sure with the one Robert recommended but the one I used has bu
<[EMAIL PROTECTED]> wrote:
Excellent - thanks for the recommendation. I'm assuming the wrapper dll
doesn't contain the sqllite dll embedded in it?
John Newby wrote:
> I was having this problem also but I just copied the dll file into the
> directory, and it worked fine with
I was having this problem also but I just copied the dll file into the
directory, and it worked fine with the ado.net wrapper at
http://adodotnetsqlite.sourceforge.net/
John
On 04/05/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> I'm trying to add sqlite3.dll ot my application in VS 2005. I
>
There are wrappers here to connect to SQLite from loads of different
languages and toolkits :-
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
On 02/05/06, Aaron Jones <[EMAIL PROTECTED]> wrote:
Windows XP, don't know what compiler to use.
I am creating a GUI to SQLite, so need my interfa
Hi Christian, thanks for the explanation, when you explain it like that it's
so simple, the index in the book concept didnt even come to me. lol.
John.
On 21/04/06, Christian Smith <[EMAIL PROTECTED]> wrote:
>
> On Fri, 21 Apr 2006, Rusty Conover wrote:
>
> >Hi,
> >
> >Is there an easy way to get
A little off subject I know, but what is the purpose of an index?
On 21/04/06, Rusty Conover <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> Is there an easy way to get an estimate on the space used by an
> existing index? If not what is a good guess on how to estimate the
> size?
>
> My guess would be (a
I said I was not sure if my answer was correct or not, so he probably just
wanted re-assuring that my answer was correct, give him a break, he'll be
under enough stress doing his project for uni without us getting on his
back.
On 13/04/06, Fred Williams <[EMAIL PROTECTED]> wrote:
>
> It would appe
I think Object Oriented databases came in with the SQL-99 standard and
SQLite is the SQL-92 standard so it may be structured but I'm not sure at
all
On 06/04/06, Aaron Jones <[EMAIL PROTECTED]> wrote:
>
> Hi, I am doing a project for University where I am creating a
> cross-platform, open-sour
OK thank you.
John
On 13/03/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
>
> "john.newby" <[EMAIL PROTECTED]> wrote:
> > Hi, I sent this request yesterday from my other address but wasn't sure
> if
> > anyone had received it as my other email address didn't receive it but
> both
> > address a
Hi, does anyone know where I can get some academic journals on SQLite? I
require them for my University project.
Many thanks.
John.
P.S. I can't start to build it until I have done the analysis of what I am
trying to build, that is why I am asking what people would like out of a
GUI.
John.
On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote:
>
> So in a nutshell you are asking the community to do your homework. What
> a shame.
No, I'm not asking the community to do my homework for me, I need to do a
user analysis phase for my dissertation, and as I don't know anyone who uses
SQLite this is the only place I can get my questions answered.
Many thanks.
John.
On 13/12/05, juan perez <[EMAIL PROTECTED]> wrote:
>
> So in a
Hi, I am doing my final year project/dissertation on "Creating a GUI to
SQLite"
I am after help for my analysis phase and would like any comments/help from
anyone or if you could put me in the right direction as to where I could
find out this information.
I would like information regarding SQLite
67 matches
Mail list logo