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

[Ted Wolfley]

Thanks, I'll give it a try.  I just tried unloading the data, then load the data into the new table and I got the same error.  Maybe something was corrupted when I created the new table this morning.  Every time after I try the insert, there is an padlock icon next to the table name in the explorer window and the only way to get rid of it is to quit Rbase.  I'll try recreating the table with multi off.   Ted From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED] On Behalf Of Javier Valencia Sent: Tuesday, June 14, 2005 12:25 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: access violation on insert Ted: I had a similar problem many versions ago and I submitted a reproducible case to RBTI, I used temporary tables as a workaround (worked better and faster anyway) and did not follow up on the problem resolution. You could try using a temporary table instead of the view, much faster too… Javier,   Javier Valencia, PE President Valencia Technology Group, L.L.C. 14315 S. Twilight Ln, Suite #14 Olathe, Kansas 66062-4578 Office (913)829-0888 Fax (913)649-2904 Cell (913)915-3137 ================================================ Attention: The information contained in this message and or attachments is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material.  Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete the material from all system and destroy all copies. ======================================================   -----Original Message----- From: rbg7-l@rbase.com [mailto:[EMAIL PROTECTED]On Behalf Of Ted Wolfley Sent: Tuesday, June 14, 2005 9:47 AM To: RBG7-L Mailing List 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