Remove the col descx and add col descx_note of type note and then give it a try.
That col is in the fox table, so you can't change the datatype, so give it a different name. Troy ===== Original Message from [EMAIL PROTECTED] at 9/26/02 3:18 pm >Well I have gotten help from Ben and Sami which I greatly appreciate. Have >ran into a roadblock. They suggested I repost to the list. > >I am moving Foxpro table to R:Base. ODBC connections and PROJECT worked >great with help from Ben and Sami. > >Steps are as follows: > >1. Set up the FoxPro database as an ODBC source >2. Go into R:BASE and connect to your database (or a test database) >3. From the R:BASE main menus, choose Utilities/Connect SQL Datasource >4. Pick your FoxPro database >5. From the R>, go to the Utilities menu again and choose Attach SQL >Database Tables >6. You will see the list of tables and views - and you have options to >attach the table/view as alias (in case you already have a table with the >same name in your database). Click on one table or view and choose attach - >and continue to attach each table from this screen. > >7. Projected Foxpro Table rows to st_category > >8. Try to Insert rows from st_category to Categories with the following >INSERT statement: > >INSERT INTO Categories (Cat_ID, Cat_Parent_ID, Cat_Name, Cat_Layout, >Cat_Cat_Cols, Cat_Prod_Cols, Cat_Description, Cat_Banner_Image, >Cat_Display_Banner, Cat_Icon_Image, Cat_Display_Icon, Cat_Sort_Order, CP_ID, >PP_ID, V_ID, Cat_Link) SELECT (id, parentid, catname, levels, l1columns, >prodcols, descx, bannerimg, dispnameb, iconimg, dispnamei, sortorder, >catpage, prodpage, vendorid, catlink) FROM st_category > >Get the following error: -ERROR- An expression cannot contain a column of >type VARCHAR (2928) > >descx was PROJECTED as a VARCHAR field. In FoxPro it is a MEMO field. It >contains alpha numeric data, not an image or blob. > >I tryed to change it to a NOTE filed or a TEXT field. Wouldn't let me. > >Any ideas. > >Thanks > >Steve Fogelson >Internet Commerce Solutions > >-----Original Message----- >From: Sami Aaron [mailto:[EMAIL PROTECTED]] >Sent: Thursday, September 26, 2002 4:08 PM >To: Fogelson, Steve >Subject: Re: Record Transfer > > >Ya got me, dude! Post your INSERT statement here and indicate which field >is VARCHAR. > >Can you browse the FoxPro table and see what's in that Varchar field? Do >you know what's in it? > >Anyone else want to jump in? > >Sami > >----- Original Message ----- >From: "Fogelson, Steve" <[EMAIL PROTECTED]> >To: "'Sami Aaron'" <[EMAIL PROTECTED]> >Sent: Thursday, September 26, 2002 2:14 PM >Subject: RE: Record Transfer > > >> Sami, >> >> Sorry to bother you. Ran into another roadblock. >> >> Had to use INSERT command. >> >> Evidently I have a VARCHAR type of field from the FoxPro table. >> >> I get the following when I run insert >> >> -ERROR- An expression cannot contain a column of type VARCHAR (2928) >> >> I tried converting the column to NOTE or TEXT and it wouldn't let me. >> >> Any suggestions >> >> Steve >> >> -----Original Message----- >> From: Sami Aaron [mailto:[EMAIL PROTECTED]] >> Sent: Thursday, September 26, 2002 11:23 AM >> To: Fogelson, Steve >> Subject: Re: Record Transfer >> >> >> Steve - >> >> > The tables have Foreign Key relationships and the Primary Keys are auto >> > number. How do you handle the transfer of rows? Do you turn the auto >> number >> > off when moving the records over and then turn back on when the transfer >> is >> > complete, setting the "initial value" of the auto number to a number >> greater >> > than the largest id transfer? >> >> As long as you are certain that the PK number will not be duplicated >between >> your new data and your existing data, then yes, that would work. >> >> > Also, the permanent R:Base tables have additional fields compared to the >> > temporary tables. What would be the best way to move the rows over. >> Reading >> > each row sequentially and matching it up with the appropriate field in >the >> > permanent table and then insert? >> >> If the column names are the same in both tables, use the APPEND command - >it >> will match up on same-named columns and ignore the rest - >> >> APPEND foxprotable TO rbasetable >> >> If they column names are not the same, then use the INSERT statement - >> >> INSERT INTO rbasetable (columnlist) SELECT same-relative-columnlist FROM >> foxprotable >> >> Sami >> >> ----------------------------------------------------------- >> Sami Aaron >> Software Management Specialists >> 19312 W 63rd Terr >> Shawnee KS 66218 >> 913-915-1971 >> http://www.softwaremgmt.com >> >> ================================================ >> TO SEE MESSAGE POSTING GUIDELINES: >> Send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: INTRO rbase-l >> ================================================ >> TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> In the message body, put just two words: UNSUBSCRIBE rbase-l >> ================================================ >> TO SEARCH ARCHIVES: >> http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> >> >> >> >> > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
