Hello Dawn,
Thanks for the info.
Yes it helps, now I know what is possible.
Rgards, Gerrit
----- Original Message -----
From: "Dawn Oakes" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Friday, May 12, 2006 3:22 PM
Subject: [RBASE-L] - RE: Editing data
This is a multi-part message in MIME format.
Mime-Version: 1.0
Content-Type: multipart/mixed;
boundary="=======AVGMAIL-4464F3A9354B======="
--=======AVGMAIL-4464F3A9354B=======
Content-Type: multipart/alternative;
boundary="----_=_NextPart_001_01C675C7.2A16C0D6"
------_=_NextPart_001_01C675C7.2A16C0D6
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Gerrit
You can edit data using a view only if it is a single table view with no
group by clause.
=20
I don't believe you can append data to an Excel file using Gateway. You
can append to an ascii file with plain old output- might be a workaround
depending on what you're trying to accomplish.
=20
output filename.txt append
unload data for tablename as ascii (or unload data for tablename as csv)
output screen
=20
Alternately, you can use ODBC to pull data from RBase into an Excel
file, rather than pushing data out. The 7.5 ODBC driver is MUCH
improved over 6.5++. Like I said, it depends on what you're ultimately
trying to accomplish.=20
=20
Hope it helps.
Dawn
_____ =20
From: Gerrit Jurgens [mailto:[EMAIL PROTECTED]
Sent: Friday, May 12, 2006 8:06 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Editing data
Dear all,
=20
During the conversion from 6.5++ to 7.5 I came across 2 questions:
=20
1 Is it possible to change data in a table by editing (or browing) a
view in RBase 7.5?
=20
2 Can I use gateway to add data to an excel-file?
=20
Kind regards,
=20
Gerrit Jurgens
=20
------_=_NextPart_001_01C675C7.2A16C0D6
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Gerrit</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>You can edit data using a view only if it =
is a single=20
table view with no group by clause.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>I don't believe you can append data to an Excel =
file using=20
Gateway. You can append to an ascii file with plain old output- =
might be a=20
workaround depending on what you're trying to =
accomplish.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>output filename.txt append</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>unload data for tablename as ascii (or unload =
data for=20
tablename as csv)</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>output screen</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Alternately, you can use ODBC to pull data from =
RBase into=20
an Excel file, rather than pushing data out. The 7.5 ODBC driver =
is MUCH=20
improved over 6.5++. Like I said, it depends on what you're =
ultimately=20
trying to accomplish. </FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2></FONT></SPAN> </DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Hope it helps.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D837455712-12052006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>Dawn</FONT></SPAN></DIV><BR>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Gerrit Jurgens=20
[mailto:[EMAIL PROTECTED] <BR><B>Sent:</B> Friday, May 12, 2006 =
8:06=20
AM<BR><B>To:</B> RBASE-L Mailing List<BR><B>Subject:</B> [RBASE-L] - =
Editing=20
data<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><FONT face=3DArial size=3D2>Dear all,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>During the conversion from 6.5++ to 7.5 =
I came=20
across 2 questions:</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>1 Is it possible to change data in a =
table by=20
editing (or browing) a view in RBase 7.5?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>2 Can I use gateway to add data to an=20
excel-file?</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Kind regards,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Gerrit Jurgens</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML>
------_=_NextPart_001_01C675C7.2A16C0D6--
--=======AVGMAIL-4464F3A9354B=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/337 - Release Date: 11-5-2006
--=======AVGMAIL-4464F3A9354B=======--
--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body,
place any
text to search for.
================================================
