[RBG7-L] - Re: access violation on insert

[David M. Blocker]

Ted   If the underlying view contains columns from the tables you are trying to insert into, this is not allowed.  However, you should get an error message to that effect, instead of access violation.   I suggest you try to reproduce the scenario in CONCOMP to replicate it. If you can, you have a bug to submit.   David Blocker [EMAIL PROTECTED] 781-784-1919 Fax: 781-784-1860 Cell: 339-206-0261 ----- Original Message ----- From: Ted Wolfley To: RBG7-L Mailing List Sent: Tuesday, June 14, 2005 10:47 AM Subject: [RBG7-L] - access violation on insert 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,grades) SELECT fname,middle_int,lname,compy,strt1,strt2,city,st,zp_code,zp_4,email,grades 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] www.ogdengroup.com