Other than the missing continuation character at the end of line 1, the command looks fine.
--- Ted Wolfley <[EMAIL PROTECTED]> wrote: > Hi, > > When I run this command at the Rprompt>: > > INSERT INTO unloadcard > (fname,middle_int,lname,compy,strt1,strt2,city,st,zp_code,zp_4,email,gra > des) > SELECT > fname,middle_int,lname,compy,strt1,strt2,city,st,zp_code,zp_4,email,grad > es FROM unloadcardv > > I get an access violation at address # in module 'RBEngine.dll". This > happens not only on my workstation but also on the server the database > resides. Am I missing something in the command? > > The columns in the select portion of the command is coming from a view > which works correctly. I also tried the command going after the > underlying table using a where clause but had the same results. The > receiving table was just created this morning using the same columns as > the from table. I have packed the database successfully. I am using > RBase 7.1 build 7.1.81.30429. > > Also, I noticed that when I create a view using the view designer, > creating an expression on a column using a function like SGET, you can > not edit the expression because the expression is corrupted inside the > select columns window. Please comfirm so I can notify RBase. > > Thanks > > Ted Wolfley > Database/Internet Programmer > The Ogden Group of Rochester > phone: (585) 321 1060 x23 > fax: (585) 321 0043 > [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> > > www.ogdengroup.com <http://www.ogdengroup.com/> > > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
