I added to the wiki (http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers)
an entry for Fortran. It links to a page on my web site,
http://danial.org/sqlite/fortran/, that has an example of a Fortran program
that calls C wrapper functions which in turn call functions in the SQLite
library. The dem
> I suppose I could copy the data table into a temporary
> table ... documenataion quarantees AUTOINCREMENT fields
> to be "monotonically increasing" ...
"Monotonically increasing" does not mean that for every key k
there will be a key (k-1). In fact, if you ever delete a row in
an autoincrement t
Thanks for everyones help, I'm actually building the
query dynamically based on what the user inputs, must
be my string handling functionality in Borland that
causing probs Thanks again.
--- Jay Sprenkle <[EMAIL PROTECTED]> wrote:
> > Put mulitple record into your table and see what
> > occu
> Put mulitple record into your table and see what
> occurs.
D:\temp\convention>sqlite3 test.db
SQLite version 3.0.8
Enter ".help" for instructions
sqlite> create table t (a, b);
sqlite> insert into t (a, b) values ('foo', 'bar');
sqlite> insert into t (a, b) values ('test', '2');
sqlite> se
Put mulitple record into your table and see what
occurs.
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
> Nicholas Choate wrote:
> > Tried that, same result. Any other ideas?
>
> here is what I get
>
> D:\user\punkish>sqlite3 test.db
> SQLite version 3.2.1
> Enter ".help" for instruction
Nicholas Choate wrote:
Put mulitple record into your table and see what
occurs.
sure thing. We were at
sqlite> select * from t;
foo;qux|barr
after that I did the following...
sqlite> insert into t (a, b) values ('qux', 'baz');
sqlite> select * from t;
foo;qux|barr
qux|baz
sqlite> update
> -Original Message-
> From: Dennis Cote [mailto:[EMAIL PROTECTED]
> Sent: Monday, July 18, 2005 11:55 AM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Newbie Help Please
>
> Wood, Lee wrote:
>
> >I tried to do the quick-start example and I could not get it
> to work. It is not
Nicholas Choate wrote:
Tried that, same result. Any other ideas?
here is what I get
D:\user\punkish>sqlite3 test.db
SQLite version 3.2.1
Enter ".help" for instructions
sqlite> create table t (a, b);
sqlite> insert into t (a, b) values ('foo', 'bar');
sqlite> select * from t;
foo|bar
sqlit
Tried that, same result. Any other ideas?
Newly revised code:
Update sys_list set pass = 'abcdf;456' where
sys_id = 'testboxa' and user_id = 'testuserid';
--- Puneet Kishor <[EMAIL PROTECTED]> wrote:
>
> On Jul 18, 2005, at 10:57 AM, Nicholas Choate wrote:
>
> > Sorry forgot the SQL on th
Wood, Lee wrote:
I tried to do the quick-start example and I could not get it to work. It is not
explicit enough for some like me. First off, the quickstart doesn't specify
that you need to include the source (just the external interface header). But
since it does not come with a *.lib I trie
I'll try that, thanks for the suggestion.
Puneet Kishor <[EMAIL PROTECTED]> wrote:
On Jul 18, 2005, at 10:57 AM, Nicholas Choate wrote:
> Sorry forgot the SQL on the previous email.
>
> Update sys_list set pass = "abcdf;456" where sys_id = "testboxa" and
> user_id = "testuserid";
afaik, the
On Jul 18, 2005, at 10:57 AM, Nicholas Choate wrote:
Sorry forgot the SQL on the previous email.
Update sys_list set pass = "abcdf;456" where sys_id = "testboxa" and
user_id = "testuserid";
afaik, the SQL way is to use single quotes to delimit text. With double
quotes it is likely inte
Sorry forgot the SQL on the previous email.
Update sys_list set pass = "abcdf;456" where sys_id = "testboxa" and user_id =
"testuserid";
Note, the update command works great, as long as a semicolon is not in the text
being updated.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
You should post
Jay Sprenkle <[EMAIL PROTECTED]> wrote:You should post your sql
On 7/18/05, Nicholas Choate wrote:
> I have noticed a quirk with the Update command and was just wondering if
> there was a way to fix it. I am attempting to update two fields in my
> database and I've noticed that if there is a "
You should post your sql
On 7/18/05, Nicholas Choate <[EMAIL PROTECTED]> wrote:
> I have noticed a quirk with the Update command and was just wondering if
> there was a way to fix it. I am attempting to update two fields in my
> database and I've noticed that if there is a ";" in the text field
I have noticed a quirk with the Update command and was just wondering if there
was a way to fix it. I am attempting to update two fields in my database and
I've noticed that if there is a ";" in the text field for one of the fields I'm
updating, it updates every record with the same information
I have had this message in the past when I can executed an SQL query
before my previous query had Completed.
Ben
Roushan Ali wrote:
Hi all,
I got an error message "library routine called out of sequence"
during sqlite_step . Can anybody tell me what this error message does
mean ?
Reg
Hi all,
I got an error message "library routine called out of sequence"
during sqlite_step . Can anybody tell me what this error message does
mean ?
Regards,
Roushan
18 matches
Mail list logo
