🚀 go-pugleaf

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