Subtract Problem

[lkatz1]

We tried to subtract 2 files with approx same records it came up with the 41 records result but when it created the new file there 41 records in that database but no data in the fields all fields were blank is there any link to windows files the maybe corrupt because we reinstalled several times alpha five ver. 5 and still the same

[Al Buchholz]

RE: Subtract Problem

david

Please zip up your database and attach it to a message with instructions about what you are trying to accomplish.

[Melvin Davidson]

RE: Subtract Problem


David,

FYI,

The subtract operation is for tables, not files. :)

I just tried it and it seems to work fine - Adsins build 1054

Waiting for the zip. :)

[lkatz1]

RE: Subtract Problem

we meant tables

[lkatz1]

RE: Subtract Problem

this is the zip file

[Al Buchholz]

RE: Subtract Problem

david

Here is an example of a subtraction operation that works with your data. Unzip this into a new directory and look under the operations tab for the subtraction operation.

I'm only guessing at what you want to do, without instructions from you.

[lkatz1]

RE: Subtract Problem

We have worked with your zip file & it works perfect but as we copied the subtract to another table we get again the previous results as blank records what can be the secret? we are using the home edition

[Al Buchholz]

RE: Subtract Problem

david

I would rebuild the subtract for the new tables rather than copying it and see if that makes a difference.

[lkatz1]

RE: Subtract Problem

Finally, we realized that problem only occures when we use the regular subtract operation but works fine with the genie so please advise

[Melvin Davidson]

RE: Subtract Problem

David,

The best thing to do is to create the operation that works with the genie, and then click the XB icon to see the equivalent xbasic code.

Compare that xbasic code to your sript. Something should
be different.

[Al Buchholz]

RE: Subtract Problem

david

When you create with the genie, do you save it?

Then look at the operation without the genie and see what it generated.

Or you can look at the xBasic code as Melvin has suggested.

[lkatz1]

RE: Subtract Problem

the genie only allows 3 fields is there anyway to have more fields to subtract we have presently a subtract of str(NO,4,0)-ADD how can we add to subtract also a title field

[Al Buchholz]

RE: Subtract Problem

David

The genies are used for some of the more common examples. If you exceed the capability of the genie, then use design mode, that will handle more situations (including yours).

If you exceed design mode, then use xbasic directly.

[Melvin Davidson]

RE: Subtract Problem

After you design the operation with the genie, save it.
Then use design mode. You can then click on Linking Key: and you will be able to modify/add the criteria to use more fields