Re: Appending Type SDF?

Article View: borland.public.vdbase.data.sql

Article #235

Back to borland.public.vdbase.data.sql Previous Next

#235

From: Tom Preston
Date: Wed, 13 Jan 1999 00:00

42 lines
1793 bytes

On Tue, 12 Jan 1999 23:26:49 GMT, supportInfo@borland.com (Ken Mayer
[TeamB]) wrote:

>Thomas Preston wrote:
>
>>I have tables that will be updated daily with SDF data.  I am unable
>>to find any information on how to append ASCII text files to a table
>>using SQL.  Please help.
>
>Ken Mayer [TeamB] wrote
>
>SQL doesn't understand it. Have you tried just using the APPEND FROM
>command? It should work ... the old XDML is still there.
>
>Ken
>---
>Ken Mayer [TeamB]
>Golden Stag Productions
>http://www.mindspring.com/~hirschv/homepage.htm
>http://www.mindspring.com/~hirschv/dbase/dbase.htm
>Visual dBASE and InterBase WebRing - http://www.fghoche.com/dbasering.htm
>TeamB: http://www.teamb.com

Maybe I'm making this harder than it is . . . but append to WHAT?
I have a Data Module containing three sql files attached to the form.
What would the syntax look like for that . . .can I SELECT a rowset?  

SELECT FORM.ROWSET1
APPEND FROM NEWCUS.TXT TYPE SDF

Or can I USE a table even though it is currently open in the SQL?

USE CUSMAS
APPEND FROM NEWCUS.TXT TYPE SDF

As an aside, is it possible to  ZAP or PACK a table opened in a QBE?

Thanks for the reply, I appreciate you help.

Tom Preston
tgp@wwa.com
tgp@compuserve.com (Soon to be DUMPED in favor of MediaOne Express)

Technical Details

Message-ID: <370437ac.547304@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <369bd176.3025950@forums.borland.com> <369bda08.17618793@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,f2e33649ff6921cd
X-Google-Attributes: gidff5a1,public
From: tgp@compuserve.com (Tom Preston)
Subject: Re: Appending Type SDF?
Date: 1999/01/13
Message-ID: <370437ac.547304@forums.borland.com>
X-Deja-AN: 431997729
References: <369bd176.3025950@forums.borland.com> <369bda08.17618793@forums.borland.com>
Organization: Another Netscape Collabra Server User
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message