Many thanks, it would help.
Csaba
2012/1/16 Vivien Malerba
> 2012/1/16 Csaba Jeney
>
> > Is there any way to query the valid savepoints? At least their names?
> > Many thanks.
> >
> >
> AFAIK, the only way to do this is to keep track of each begin, rollback,
Is there any way to query the valid savepoints? At least their names?
Many thanks.
Csaba
This message is intended to be confidential and may be privileged. If
you are not the intended recipient, please delete this e-mail from your
system immediately and notify us of the erroneous transmission
p rows, call it EventId, then you could do:
SELECT t.*, u.*
FROM TBOOKING AS t LEFT JOIN TBOOKING as u
ON t.EventId=u.EventId
WHERE t.EVENTTYPE+1=u.EVENTTYPE
Csaba Gabor from Vienna
On Mon, Nov 3, 2008 at 12:39 AM, Ingo Koch <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I've got
hanks,
Csaba Gabor from Vienna
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On Thu, Jul 3, 2008 at 1:33 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Csaba" <[EMAIL PROTECTED]> wrote in
> message
> news:[EMAIL PROTECTED]
>> SELECT * FROM Words
>> GROUP BY Id, Lang
>> HAVING Rev=Max(Rev)
>
> This wouldn't do
> As this applies to my query, it would be:
> SELECT * FROM Words
> GROUP BY Id, Lang, Rev
> HAVING Rev=Max(Rev)
Drat. That Rev shouldn't be in the GROUP BY.
The query I wanted to write is:
SELECT * FROM Words
GROUP BY Id, Lang
HAVING Rev=Max(Rev)
> Given that I have my Primary Key as (Id, Lang
On Tue, Jul 1, 2008 at 2:53 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Csaba" <[EMAIL PROTECTED]> wrote in
> message news:[EMAIL PROTECTED]
>> 1) In the following LEFT JOIN, is it possible to alter
>> the query so that there is no w. prefix at the
&
1) In the following LEFT JOIN, is it possible to alter
the query so that there is no w. prefix at the
beginning of each returned column name:
SELECT w.* FROM Words AS w LEFT JOIN Words as w2
ON w.Id=w2.Id AND w.Lang=w2.Lang AND w.Revhttp://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks for your reply (and also thanks, Richard, for
your reply about sqlite3_table_column_metadata)
I've interspersed a few remarks, please see below.
On Mon, Jun 16, 2008 at 4:50 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> Csaba wrote:
>> Is there any way to detect, based
KEY)
I have not found a difference upon looking at:
SELECT * FROM sqlite_master WHERE type='table' AND name='myTab';
PRAGMA table_info('myTab');
The following is empty:
PRAGMA index_list('myTab');
so index_info does not seem relevant either.
Thanks,
Csa
yTab');
so index_info does not seem relevant either.
Am I missing something? Thanks,
Csaba Gabor from Vienna
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
11 matches
Mail list logo
