🚀 go-pugleaf

On Wed, 13 Jan 1999 15:10:00 +0800, "Geoff S. Wass" <gswass@ibm.net>
wrote:

>Tom,
>
>Answers embedded below:
>
>Tom Preston wrote:
>
>> 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.
>> >
>> <snipped Ken's signature stuff>
>
>> 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
>>
>
>You can make your QUERYs or ROWSETs active=FALSE, then use the old XDML way of
>appending, then set the active = TRUE again.
>
>>
>> As an aside, is it possible to  ZAP or PACK a table opened in a QBE?
>>
>
>No! You must have exclusive use of a table for ZAP or PACK. Same applies to
>the new OODML. No one can be using the table because dBASE won't know what to
>do with anything they might be doing (add/change/delete) at the time your
>zap/pack.
><snipped your signature stuff>
>
>--
>Geoff Wass
>Kuala Lumpur, Malaysia
>
>
>=>=> More dBASE info at http://members.theglobe.com/Geoff_Wass <=<=
>

Thank you, thank you, thank you.  I KNEW that I was making this harder
than it really is!!

Tom Preston