[sqlite] Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Igor Tandetnik
Paul Harris <[EMAIL PROTECTED]> wrote: in MySQL, you can do something like: select @xyz := column from table where id=1; can this be done in Sqlite? No. is there an equivalent in "standard" sql? No. Igor Tandetnik

Re: [sqlite] Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Paul Harris
On 03/08/07, Nikola Miljkovic <[EMAIL PROTECTED]> wrote: > [In the message "[sqlite] Re: how do i declare and use variables in sqlite?" > on Aug 2, 18:22, "Igor Tandetnik" writes:] > > Chase <[EMAIL PROTECTED]> wrote: > > > how do i declar

Re: [sqlite] Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Nikola Miljkovic
[In the message "[sqlite] Re: how do i declare and use variables in sqlite?" on Aug 2, 18:22, "Igor Tandetnik" writes:] > Chase <[EMAIL PROTECTED]> wrote: > > how do i declare and use variables in sqlite? > > You don't. You declare and use variables i

[sqlite] Re: how do i declare and use variables in sqlite?

2007-08-02 Thread Igor Tandetnik
Chase <[EMAIL PROTECTED]> wrote: how do i declare and use variables in sqlite? You don't. You declare and use variables in whatever program you write that runs SQLite statements. Igor Tandetnik - To unsubscribe,