urseid = 0;
BUT what a surprise, i got an empty result (i expect to get
rows No 1 to 3) !
any suggestions?
Yes :
SELECT P1.statid
FROM plan P1
WHERE P1.statid = 0;
instead of your query...
but you'll get only what you asked for : only O ;)
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor
that is to create a trigger that would "calculate"
the field content.
But be careful not to fire the same trigger.
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
SQLite have to take in charge what a developper doesn't want to do himself
(ie removing leading and trailing spaces) ?
IMHO, i would let things like they're now.
Regards,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EM
from table_name;
you can also have the exact count for each value with :
select name, count(name)
from table_name
group by name;
HTH,
Best regards,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED
es, use only single quotes.
in your second case, it will consider Column(nick)=Column(Nick)
which are obviously the same :)
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
DB ?
then, instead of spending too much time seeking for a tool that could
open the database, "re invent the wheel" and build yourself, with tcl, a
tool that would export the DB in a format that you could then import.
IMHO, it's the easiest and fastest way...
HTH,
Best regards,
so be able to force not to behave like that.
Hi Bjørn ,
Have you tried to use single quotes instead of double quotes ?
varchar values have to be encapsulated wihtin single quotes...
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53
dex on those columns.
HTH,
Best regards,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
y to get the fastest full table scan :) )
if restricting in the where clause on VehicleID, then you should create
an index on VehicleID.
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73 50
e-mail : [EMAIL PROTECTED] - Web : http://nauteus.com
,
a better request would be :
select count(VehicleID) as CountVehicle from tx where VehicleID = ' +
QuotedStr(VehicleID)
then you get the field "CountVehicle" value.
HTH,
--
Guillaume MAISON - [EMAIL PROTECTED]
83, Cours Victor Hugo
47000 AGEN
Tél : 05 53 87 91 48 - Fax : 05 53 68 73
10 matches
Mail list logo