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
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]
