: Dan Cumpian; 'Jeff Snoxell'; [EMAIL PROTECTED]
Subject: RE: SELECT and UPDATE at the same time?
At 13:23 -0500 12/19/02, <[EMAIL PROTECTED]> wrote:
>Well, the only basis I have is personal experience from connecting to a
local
>MySQL database. The components I use for connectin
At 13:23 -0500 12/19/02, <[EMAIL PROTECTED]> wrote:
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at
Well, the only basis I have is personal experience from connecting to a local
MySQL database. The components I use for connecting to MySQL with Delphi does
cache the records as the server returns them. However, not all the records are
returned at once. As I said, it depends on how one connects to
At 23:43 -0500 12/18/02, Dan Cumpian wrote:
Jeff,
Not if your outer loop is in a separate query. In that case, your query
is essentially a cursor and is static once OPENed. As you move from
record to record, what you are seeing is the records at the time the
query was opened. Now, if you were to
Jeff,
Not if your outer loop is in a separate query. In that case, your query
is essentially a cursor and is static once OPENed. As you move from
record to record, what you are seeing is the records at the time the
query was opened. Now, if you were to update records that you haven't
processed yet
002 1:54 PM
To: [EMAIL PROTECTED]
Subject: Re: Re: SELECT and UPDATE at the same time?
>>
>>SELECT * FROM my_table WHERE Age > 50 AND UPDATE Status = "OLD"
>
>No. That's goofy anyway. Why wouldn't you just use a regular
>UPDATE query?
>
>UPDATE m
Hi,
You can use REPLACE...SELECT
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Jeff Snoxell" <[EMAIL PROTECTED
At 21:40 +0200 12/18/02, Gelu Gogancea wrote:
Hi,
You can use REPLACE...SELECT
Not in the case described below. You cannot replace into the same
table from which you're selecting.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail ad
SELECT * FROM my_table WHERE Age > 50 AND UPDATE Status = "OLD"
No. That's goofy anyway. Why wouldn't you just use a regular
UPDATE query?
UPDATE mytable Status = "OLD" WHERE Age > 50;
Cos I want to do a fairly long-winded process on the records of those who
are Age>50 and subsequently up
At 17:56 + 12/18/02, Jeff Snoxell wrote:
Hello again,
I'm selecting a group of records from my database. I then loop
through the selected records and do some work based on what I find.
But what I also want to do as I interrogate each record is update
some of its fields with new values... b
10 matches
Mail list logo