J.M.,
The APPEND ViewName TO TableName command DOES WORK in
The Glorious R:BASE 2000 (ver 6.5++) for Windows!
Il n'y a aucune anomalie dans la documentation de RBWIN ou de HTML.
Try the following:
Example 01:
01. Launch TGRB2000 (ver 6.5++)for Windows
02. CONNect CONCOMP (sample database) bundled with 6.5++
03. PROJECT TSalesInf FROM SalesInf USING ALL WHERE COUNT = 0
(To create a blank TSalesInf table from SalesInf view)
04. APPEND SalesInf TO TSalesInf
Notice that ALL records from SalesInf VIEW are successfully
APPended to TSalesInf TABLE!
Example 02:
01. CREATE a new TABLE, such as:
CREATE TABLE `MyTest` +
(`EmpId` INTEGER, +
`xTransID` INTEGER, +
`xTransDate` DATE, +
`xNetAmout` CURRENCY)
02. APPEND Salesinf TO MyTest
Notice that ALL records from SalesInf VIEW are successfully
APPended to MyTest TABLE!
Notes:
01. When using the APPEND command, in your case, APPENDing VIEW
to a TABLE, make sure that you have the matching column(s).
02. When using the APPEND command, make sure that you are using
the CORRECT names of relating TABLE(s)/VIEW(s).
02. Make sure that currently connected database IDQUOTE SETting
is SET to ` (i.e. reversed single quote).
Esp�rez que des aides!
Very Best Regards,
Razzak.
At 03:43 AM 8/9/01 -0400, J.M. GRATIAS wrote:
>
>Did somebody ever tryed to append rows from a view to a table ?
>
>
>APPEND ViewName TO TableName
>return :
>Cannot do this command on a view (24)
>
>I am trying that for the first time ...
>It should work, according to both Online help and HTML manual
>... but it don't in RBW 6.5++
>
>Any idea why ?
>
>Is the bug in the manual or in RBW ?
===================================-============================
Official R:BASE List Server: mailto:[EMAIL PROTECTED]
RBTI Events/Training: http://www.rbase2000.com/events
R:DCC Members: http://www.rbase2000.com/rdcc
================================================================
R:BASE, Oterro & R:Tango are registered trademarks of RBTI.
==================================-=============================
