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/
