| Subject | Re: [firebird-support] using sql to update record individually |
|---|---|
| Author | unordained |
| Post date | 2003-07-26T03:10:11Z |
can you give us the rest of the table layout for those tables?
which fields join them, what fields identify them? an idea of the number of rows in each, etc.?
and yes, you can do it without a SP.
-philip
---------- Original Message -----------
From: "james_027" <james_027@...>
To: firebird-support@yahoogroups.com
Sent: Sat, 26 Jul 2003 02:54:17 -0000
Subject: [firebird-support] using sql to update record individually
which fields join them, what fields identify them? an idea of the number of rows in each, etc.?
and yes, you can do it without a SP.
-philip
---------- Original Message -----------
From: "james_027" <james_027@...>
To: firebird-support@yahoogroups.com
Sent: Sat, 26 Jul 2003 02:54:17 -0000
Subject: [firebird-support] using sql to update record individually
> using sql to update record individually------- End of Original Message -------
>
> I have 2 table one is items and the other is invoicedetails
>
> recently I have added an additional field to the invoicedetails,
> which a UNIT2 and CONVERSION. This 2 fields exists on the items
> table. Since the field UNIT2 and conversion is just recently added, I
> want to fill those null fields with values from the items table.
>
> Is there a sql statement to do this job? But not using stored
> procedures.
>
> thanks.
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/