paradox 4.5 - subtract.sc (0/1) 
Author Message
 paradox 4.5 - subtract.sc (0/1)

I am trying to change the enclosed script so that it will compare the
phone# fields of two different tables and delete the ones that are the
same in the first table.  I have been able to use SUBTRACT to take all
the records that are the same out of one table.  But the tables have
to be the same.  The only field that is the same is [phone#]

can someone please help out.

thanks
Rick Andres



Fri, 15 Oct 1999 03:00:00 GMT
 paradox 4.5 - subtract.sc (0/1)

You may be confusing the table oriented "subtract" operation from a
record delete.

One way to do what you want is:

Query

   Table1 | Phone |
   DELETE | _P    |

   Table 2 | Phone |
           | _P    |

Endquery

Have a mess around with it and you'll see how it works.

Peter Wachtel
Databars Australia.

Quote:

> I am trying to change the enclosed script so that it will compare the
> phone# fields of two different tables and delete the ones that are the
> same in the first table.  I have been able to use SUBTRACT to take all
> the records that are the same out of one table.  But the tables have
> to be the same.  The only field that is the same is [phone#]

> can someone please help out.

> thanks
> Rick Andres




Sun, 17 Oct 1999 03:00:00 GMT
 paradox 4.5 - subtract.sc (0/1)

Quote:

> I am trying to change the enclosed script so that it will compare the
> phone# fields of two different tables and delete the ones that are the
> same in the first table.  I have been able to use SUBTRACT to take all
> the records that are the same out of one table.  But the tables have
> to be the same.  The only field that is the same is [phone#]

Try using the DELETE option in Query by Example.

Vaggs



Sun, 17 Oct 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. paradox 4.5 - subtract.sc (1/1)

2. Subtracting Dates in Paradox 4.5 or 5.0

3. Problems with Paradox 4.5 and WINDOWS NT 4.5

4. IMPORT PARADOX FOR DOS V 4.5 INTO PDOXWIN 4.5

5. Hilton Head, SC - Forms 4.5/5.0 Developers - Perm

6. Can I read .sc,sc2 scripts w/ pdox win 4.5

7. PDOX DOS .SC -> PDOX 4.5 WINDOWS

8. GPF 11d4 at Paradox:68:02c4 Paradox DOS ver 4.5

9. Queries and reports from Paradox 4.5 to Paradox 9

10. Paradox 4.5 files with Paradox 9

11. Converting, Importing, or Updating Paradox 4.5 for DOS Scripts to Paradox 5 for Win

12. Paradox DOS 4.0/4.5 to Paradox for Windows


 
Powered by phpBB® Forum Software