It looks like R:Base is interpreting your SSN column as integer. Try specifically listing the columns in the statement rather than using the asterisk. (Not a big hassle in R:Base, thanks to [F3]). Sometimes this resolves interesting problems such as yours.
"J. Stephen Wills" <[EMAIL PROTECTED]> wrote: >I'm sure someone knows something about this one ... > >I have a PRODUCTION database and an AD_HOC database that contain some tables which >are exactly identical. �I use the AD_HOC to prepare (LOAD, parse, INSERT, Etc) data >that we receive as flat-file ASCII before I LOAD it into the PRODUCTION database. >�So, when I have a connection to the AD_HOC and SCONNECT to the PRODUCTION database >therefrom, I SATTACH one of the identical tables, using an alias, and choosing SSN >(defined exactly the same in both tables) as the column-set to uniquely identify the >SATTACHed table. �All this is fine. �However, when I attempt : > >INSERT INTO ALIAS_TABLE_A (*) SELECT * FROM TABLE_A WHERE ... � �-- WHERE-clause >shouldn't be a factor as the SELECT component executes fine > >I get this in a message box : > >"[RBTI][R:BASE ODBC Driver][PRODUCTION]-ERROR- Column SSN must be a valid TEXT (122)" > >Any ideas? > > >Thanks, >Steve in Memphis > -- Albert Berry Full Time Consultant to PSD Solutions 350 West Hubbard, Suite 210 Chicago, IL 60610 312-828-9253 Ext. 32 __________________________________________________________________ McAfee VirusScan Online from the Netscape Network. Comprehensive protection for your entire computer. Get your free trial today! http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397 Get AOL Instant Messenger 5.1 free of charge. Download Now! http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
