Jump to content

Denniz

Members
  • Posts

    33
  • Joined

  • Last visited

Denniz's Achievements

Explorer

Explorer (4/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. yes i noticed them but i wanna know if the other options are possible. I need to know before i begin
  2. Hey there! I wanna make a FM app. which works as a photoalbum with the possibility to choose different layouts en pagestyles. So on each page i can select a picture with some text then i go the the next page...and so on.. After this i want the possibility to upload the whole FM album with FTP, this has to happen userfriendly so on background or something.. Somebody knows if this is possible in filemaker pro 6.0?
  3. That did the trick It's working so perfect now! If you have another cool add-ons, let me know so i can make it total perfect Thanks for helping!
  4. don't think there is something wrong with that script: Replace Contents [No dialog, "ChangeSummary", ... Case(not NumToText(FIELD1)= Left( status; Position( status; "|" ; 1; 1)-1); "FIELD1: "& Left( status; Position( status; "|" ; 1; 1)-1) & " >> " & NumToText(FIELD1)) & Case(not NumToText(FIELD2)= Middle( status; Position( status; "|" ; 1; 1)+1; Position( status; "|" ; 1; 2) - Position( status; "|" ; 1; 1)-1);"
  5. I found one error, i had SET FIELD [ChangeSummary.. Now changed that to REPLACE CONTENTS [ChangeSummary.. but now when i import the database with one change, the Statusfield goes to "CHANGED" and the ChangeSummary shows all the recordinfo WITH all the pipes
  6. It didnt't work, my status field sais 'changed' and the changeSummary sais; name: >> Peter |||| age: >> 23 |||| And when i change 2 records, just 1 records work with the changeSummary so i think there is a flaw somewhere? (FIELD1 | FIELD2 | FIELD3 didnt work, it has to be FIELD1 "|" FIELD2 "|" FIELD3 but that didnt seems the problem over here)
  7. ok but then i have to change it to; FIELD1 | FIELD2 | FIELD 3 etc.? Then its gonna be a messed up field with some text and pipes
  8. thanks CobaltSky, when you typed your reply i editted my post. I did exactly what you said BUT did nothing with the pipes maybe there i can find my error? (i now use FIELD1 & FIELD2 & FIELD4 etc)
  9. hey cool concept that ChangeSummary! It works pretty fine BUT, now when i change something and import it, the CS field shows the same values as the recordset. So you can't see whats the old and what's the new value, it just shows all the fields. Another flaw is that he just changes the first record with a difference, when i change more records then after importing he gives back just one record with a difference, so CS field stays empty in the other records (status field works fine btw) Is it possible to just show the old value of the changed field in all changed records?
  10. It was the comparison between the two replace[] scripts, they weren't the same...now they are and it's working! Another *bonus* question is, is there a possibility to see 'what' is changed in the record? (maybe just by a * or show the old value?)
  11. Hey Cobalt, The Script works ALMOST perfect now My Unique ID is the field i made by myself (Keyfield) so every record has his own ID/key. I have 2 more questions about my script. when activating my first script in the Tempfile: Delete all records [no dialog] Import Records [restore, no dialog, "database.dbf") SetField [Exact("Keyfield";"main::keyfield")] Open ["main.fp5"] Close[] I get a message "this field is not midifiable" after OK the script goes on, how can i get rid of that message? (when i delete "SetField [Exact("Keyfield";"main::keyfield")]" the warning is gone. But this one is quite important huh?) Another question about your last script with the 'status' field, it works very nice...... BUT! When i import a NEW record it goes OK (it says NEW). When i do the same import again, the new record goes to CHANGED (it must be UNCHANGED). I Only want a CHANGED when something in a record (with the same ID/Key) is changed. When this is working i'm a happy man
  12. found the trick..sorry "In your document preferences you can specify a script on startup or on exit of that file. Check the perform script on startup and select your script."
  13. Hi there, I want to load a Script in Scriptmaker without clicking a button to activate. (So want to load a layout and On-load activate the script)Is it possible?
  14. Keyfield is mij unique field where i store most important info of that record (there is no ID). So i want to compare that Keyfield in my imported temp file with the Main database, if its equal, UNCHANGED, if the record CHANGED .., if the keyfield is NEW make a new record. thats my whole story The script above only imports te record over and over again, no status text is seen in my status textbox..
  15. you're understanding me very well and i'm coming close now but i miss some points What do you mean with the 'synchronisation' , is it the part with "SetField[Exact(Keyfield;main::keyfield)]"? after that nothing happends to sync? I'm now gonna try your solution, but think i miss some sync stuff in my temp file. now my scriptmaker is as follows: Delete all records [no dialog] Import Records [restore, no dialog, "database.dbf") SetField [Exact("Keyfield";"main::keyfield")] Open ["main.fp5"] Close[]
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.