Hi,
Perhaps you can do this in TWO SQL STATEMENTS - see below. However,
this way you inefficiently check the existence twice:
On 6/2/09, robinsmathew robinsmat...@hotmail.com wrote:
IF EXISTS (SELECT prod_batch_code FROM stock_tab WHERE prod_batch_code=1000)
UPDATE stock_tab
Sorry, I don't see EXISTS in SQLite documentation.
On 8/20/09, Asif Lodhi asif.lo...@gmail.com wrote:
Hi,
Perhaps you can do this in TWO SQL STATEMENTS - see below. However,
this way you inefficiently check the existence twice:
On 6/2/09, robinsmathew robinsmat...@hotmail.com wrote
Hi Christophe,
On 12/9/08, Christophe Leske [EMAIL PROTECTED] wrote:
the difference between a normal where-clause and the Group by, and
having
I used www.sqlcourse.com and sqlcourse2.com probably in the year 2000.
They had very good tutorials and also let your actually practice the
SQL
Hi All,
On 10/10/08, Jay A. Kreibich [EMAIL PROTECTED] wrote:
On Fri, Oct 10, 2008 at 12:59:31PM -0400, Igor Tandetnik scratched on the
wall:
Shaun R. [EMAIL PROTECTED] wrote:
It is true that on most systems char is signed, but it is worth
remembering that this is not universally true.
Hi Chris,
On 8/15/08, Chris Brown [EMAIL PROTECTED] wrote:
Can you offer any further help/suggestions?
AFAIK, how the system() passes the command-string to the command-processor
is implementation defined. I would suggest that you also pass the shell
(e.g. /bin/sh) to system() in addition to
Hi Ken,
On 6/6/08, Ken [EMAIL PROTECTED] wrote:
Some numbers can be represented exactly using the
floating point type. .
Here is a reference from The C++ Programming Language, 3rd Edition
by Bjarne Stroustrup, Page 835, section - C.6.2.6:
Hi Christophe,
On 6/4/08, Christophe Leske [EMAIL PROTECTED] wrote:
..
AND (latitude_DDS BETWEEN 44.261771 and 44.424779)
You might want to check if you can somehow store this data *without*
the decimal point (with the point implied - counting six digits from
right to left) and
Hi Vincent,
On 11/21/07, Mitchell Vincent [EMAIL PROTECTED] wrote:
I have a primary key that auto increments and has apparently
overlapped back on to itself.
INSERT into mytable(id,name) values(NULL,'test');
.. is giving me primary key must be unique errors.
How can I reset the sequence
Hi,
On 11/15/07, Andreas Volz [EMAIL PROTECTED] wrote:
Am Tue, 13 Nov 2007 12:46:11 -0800 (PST) schrieb Ken:
I think your blob file performance may greatly depend upon the file
system that it used and the workload.
I found this article:
Hi Darren,
On 11/3/07, Darren Duncan [EMAIL PROTECTED] wrote:
At 9:42 AM -0400 11/2/07, Samuel R. Neff wrote:
I think the real problem here is virtual is a broad enough term ...
I immediately think about MySQL when you use terms like federated
and data engine. With the word federated, anyone
Hi,
I've been just glancing over the Unicode related posts. However, I
would like to know how it's possible for me to insert text in
different languages in an Sqlite database. Can you fixate the type
of the language for any particular database? I would be thankful if
any of you guys could explain
Hi Shilpa,
On 8/28/07, Shilpa Sheoran [EMAIL PROTECTED] wrote:
Eg. I create sqlite db file say mysqlitedb.db and now I have MySQL
installed. Can it access mysqlitedb.db
IIRC, I did read about Linked Servers in MS-SQL-Server documentation
where, if your SQL Server is being used in an NT
Hi maitong,
On 7/16/07, maitong uy [EMAIL PROTECTED] wrote:
The scenario would be the sqlite database is managed using CGI C, resides in
Linux environment, and accessed through the web. Then the sql server would
be replicating whatever changes would occur in the sqlite database (both
sqlite and
Hi maitong,
On 7/11/07, maitong uy [EMAIL PROTECTED] wrote:
I see...any idea as to how exactly? I really am out of ideas regarding
this... :(
I think I did see some UnixODBC files on a Linux environment (Fedora Core 6,
to be exact) and if you have the same kind of UnixODBC files on your
Hi Rob,
On 7/13/07, Rob Richardson [EMAIL PROTECTED] wrote:
Greetings!
But I'm wondering if I can use an in-memory database to improve this
dramatically. The data is collected by a Windows service that collects
data and adds it to the database once a minute. If the service would
also store
Hi Gilles,
On 6/20/07, Gilles Ganault [EMAIL PROTECTED] wrote:
At 16:49 19/06/2007 -0700, Medi Montaseri wrote:
The context is that, until now, our apps were almost used on stand-alone
hosts with only a few customers hosting the (small) SQLite database file on
a shared drive on the LAN, so
Hi Everybody,
I have just joined this mailing list as Sqlite looks like a good
software solution to my needs. What I need right now is RE-assurance
of crash-recovery that is mentioned on your front page. So, I would
be thankful if you experts would give me an accurate and fair
picture of the
Hi Kees,
Thanks for replying.
On 6/17/07, Kees Nuyt [EMAIL PROTECTED] wrote:
... thankful if you experts would give me an accurate and fair
picture of the crash-recovery aspects of SQLite - without any hype.
I'm not sure if you would qualify this as hype, but sqlite is
used in many end-user
18 matches
Mail list logo