Unique Post

[Tom Cone Jr]

RE: Unique Post

david,

Search the registry for keys that contain the string "Alpha Software".

-- tom

[lkatz1]

RE: Unique Post

As we have realized now this problem we think is related with a virus even though no virus is present on machine, please advise how we can delete all files which are linked to alpha we have removed the program with add remove programs also we cleaned the registery for all a5v files & alpha five but it seems someplace is still somthing left over maybe in windows system files etc so please advise

[Tom Cone Jr]

RE: Unique Post

Saved post operations are visible on the Code tab of the control panel. If you can't see the Code tab just right click on any other tab name and add a check mark beside Code in the list which will appear.

-- tom

[lkatz1]

RE: Unique Post

finally, you have understood our request will ask a similuar question ex only the new posted address should get modified in date field by todays date not the dbf file

also, we have been making some more post operations but they don't seem to show up but when we want to create a new post with same name it comes up amessage should we overwrite it. were are those post & how can we see them

[lkatz1]

RE: Unique Post

finally, you have understood our request will ask a similuar question ex only the new posted address should get modified in date field by todays date not the dbf file

also, we have been making some more post operations but they don't seem to show up but when we want to create a new post with same name it comes up amessage should we overwrite it. were are those post & how can we see them

[Tom Cone Jr]

RE: Unique Post

david,

well the details of your problem are gradually getting clearer I don't think you can do what you are describing through the post field rule it's not sophisticated enough to meet your needs I think you're going to have to devise a custom script the post field rule assumes that the target table will have only one record that should be updated by addition subtraction or replacement here you're describing a target table that has multiple records with the same search key and you only want to change (update) the add field if its different than the add field in the master table

-- tom

[lkatz1]

RE: Unique Post

We don't understand how this command will work, when in monviz recno #2 has add 1234 55 st
and recno #2 in all and dbf "monviz" has 2345 66 st , but recno #3 has the same add we don't want that one to be touched for changing (all of these records are for monviz dbf) not for the brookly we know how to configure only for monviz or brookly dbf but we don't know how in the same dbf some shall be posted and some not touched

[Tom Cone Jr]

RE: Unique Post

David,
after a good night's rest I re-read your last post.

If you want to replace the 'Add' field in the target table when the 'Add' field changes in the All table I think you can do it with a conditional post using table field rules.

Define separate conditional posts for each of your potential target tables. You will wind up with multiple lines in the grid in the post field rule dialog box.

This assumes that your 'Recno' field for the desired target record has the same value in your source table (All) as it does in the desired target table.

The conditional expression you'd use would vary from row to row (in the post field rule dialog) but would look like this for posts you only want to go to the monviz table:

ut(All->dbf) = "MONVIZ"

and the conditional expresson you'd use for posts you want to go to the brookly table would look like this

ut(All->dbf) = "BROOKLY"

hope this helps. -- tom

[Tom Cone Jr]

RE: Unique Post

David,

Sorry in Alpha Five DBF files are tables collections of tables make up a database DBF files do not contain databases I'm sorry I can't help you I have yet to grasp the problem that is bothering you -- tom

[lkatz1]

RE: Unique Post

All.dbf is a database which includes several databases as you will see in the dbf field the different names when that address gets updated you will see the recno which is linked together then you have the add field which is the address field moviz or brookly1 dbf gets posted when all address is changed

[Tom Cone Jr]

RE: Unique Post

David,

Ok I have the two tables, now what? My mind reading skills are a bit rusty for me to help you need to tell me exactly how you want to change one of these tables you have not told me which is primary how they're linked or related and you have not told me what it is you want to change

[lkatz1]

RE: Unique Post

how to we attach file we dont see any place to attach the file

[Tom Cone Jr]

RE: Unique Post

Will be easier to do this with your tables or scaled down copies of your tables provided you explain which field is used to identify and link the records between tables and provided you explain which table has the current information and provided you identify the names of the fields that needs to be updated in the second table

[lkatz1]

RE: Unique Post

normally we have 2 databases that have same field names but one gets constantly updated and both of them have number field with that field we create the link to post so please explain again with an example how to do

[Tom Cone Jr]

RE: Unique Post

David,

I was hoping for more details. Here's one approach, assuming I understand your question...

create a set link the tables one to one put the table that has the correct address in primary slot define a saved update operation for the set use an if function to update the address field in the child table if its trimmed value is not the same as the trimmed value in the primary table otherwise update the child's address field with its own existing field value

-- tom