--- [EMAIL PROTECTED] wrote:
> I think you need an UPDATE statement
> UPDATE MyTable set EndDate=DATE_ADD(InitOn, INTERVAL
> LenChoice DAY) WHERE
> RecordID = ;
>
> Insert *always* creates new records if successful
> and cannot be used to
> modify them.
> Update *always* updates recirds in pos
Stuart Felenstein <[EMAIL PROTECTED]> wrote on 26/11/2004 13:54:31:
> I'm trying to build an insert query that will add a
> value into a field , after the first insert query adds
> the record.
>
> Relevant table information:
>
> +-+-++--+
> | RecordID
I'm trying to build an insert query that will add a
value into a field , after the first insert query adds
the record.
Relevant table information:
+-+-++--+
| RecordID| InitOn | LenChoice | EndDate |
+ [PrimID,AutoInc]| [Date] | [int]|
