Re: append problem
- From: "Anders" <anders@anders>
- Date: Thu, 8 Sep 2005 18:34:20 +0200
USE Attribute IN 0
ZAP IN Attribute
INSERT INTO Attribute (ref, message) VALUES ('nnn',
FILETOSTR('attribute.txt') )
USE Blocks IN 0
ZAP IN blocks
APPEND BLANK IN Blocks
SELECT Blocks
APPEND MEMO message FROM Bloclks.txt
REPLACE ref WITH 'xxx' IN Blocls
There's no IN clause for the APPEND MEMO command
-Anders
"Robert" <Robert@xxxxxxxxxxxxxxxxxxxxxxxxx> skrev i meddelandet
news:F3556E2C-479A-4766-B4B2-6C81BD025150@xxxxxxxxxxxxxxxx
> Hi,
>
> I seem to be having a problem appending txt files to a couple of tables. I
> have two tables which have exactly the same two fields, (Ref and message).
> When i run them individually they work fine, but when i run them together
> the
> data from the txt file seems to apear in both table.
>
> The code i'm useing is:
>
> WAIT WINDOW NOWAIT "Attribute..."
>
> USE attribut in 0 EXCLUSIVE
> ZAP
>
> APPEND FROM Attribut.txt DELIMITED
>
> WAIT WINDOW NOWAIT "Block..."
>
> USE blocks in 0 EXCLUSIVE
> ZAP
>
> APPEND FROM blocks.txt DELIMITED
>
>
> Can someone please let me know why the block.txt data is going into the
> attribut table too?
>
> Thanks in advance
>
> Rob
.
- References:
- append problem
- From: Robert
- append problem
- Prev by Date: Re: IIF()
- Next by Date: Re: Access mdb file
- Previous by thread: Re: append problem
- Next by thread: Compare structure of DBFs in 2 directories, report missing or differences
- Index(es):
Relevant Pages
|
