DROP the column and replace it with a NOTE one. Any characters over ~4000 will get truncated. RRR
----- Original Message ----- From: "Fogelson, Steve" <[EMAIL PROTECTED]> To: "R:Base User Group (E-mail)" <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 2:18 PM Subject: FW: Record Transfer > 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/
