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,
====================================
