Richard try:
R>UPDATE PhotoLog SET Photographer = PhotogName +
from Photolog t1, Photog t2 +
WHERE t1.PhotogInitials = t2.PhotogInitials and +
t1.Photographer IS NULL
--- Richard Croy <[EMAIL PROTECTED]> wrote:
> I'm stumped at what I'm doing wrong.
>
> This is the list of columns (so far) in a new database I'm
> creating for a project
>
> R>lis col
> Column Name Table Name Attributes
> ------------------ ------------------
> ---------------------------------------
> CDRom PhotoLog Type : INTEGER
>
> PhotoFile PhotoLog Type : TEXT 30
>
> PhotogInitials Photog Type : TEXT 4
>
> PhotoLog Type : TEXT 4
>
> PhotogName Photog Type : TEXT 25
>
> Photographer PhotoLog Type : TEXT 25
>
> SendWhere DoOutput Type : TEXT 8
>
> X FormTable Type : TEXT 1
>
>
> This is what I want to do. When I import a list of file names
> of photo files from a CD-ROM, I need to update the record to
> include the photographer's initials and name. I have tried to
> use this command
>
> R>UPDATE PhotoLog SET Photographer = PhotogName in Photog
> WHERE PhotogInitials = PhotogInitials WHERE
> Photographer IS NULL
>
> [The Where command is necessary because the new file names are
> being appended to the existing list so I want to make sure
> that the update is only on the new rows because they don't
> have that information.]
>
> Every time I run this command, this is the error I get.
>
> -ERROR- Column Photographer must be a valid TEXT. ( 122)
>
> The Photographer column IS defined as TEXT 25
>
> When I run that same command substituting the real name for
> PhotogName and the real initials for PhotogInitials, it works.
>
> Thanks for getting me straightened out!
>
> Richard S. Croy
> [EMAIL PROTECTED]
>
> ====================================
> This message has been checked with an up-to-date
> version of Norton Antivirus before sending,
> ====================================
Jim Bentley
American Celiac Society
[EMAIL PROTECTED]
tel: 1-504-737-3293
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search.
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
