Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About bleapy

  • Rank

Profile Information

  • Gender

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi David, wanted to see if I understand what you're suggesting. I would create an extra field to store the "stored" data on the same table? or create a mirror table and copy the entire record to a this Mirror table when that "original" record is being saved/update? Anyone have a simple example script of doing something similar to this using a PSoS? Thanks.
  2. I don't really have an acceptable time in mind, just something to test out and see which is the best solution. But at the current speed.. it's deemed too slow to say it can be accessed on FMGO through WAN.
  3. Thanks for the responses. I understand that the script will be processed on the Server. However, I thought the result can be passed on to the client once the process is completed? @ Kris, when you say "pass the results of PSOS out of the script..." what can be passed out of the script? a string of records? or just a value? @ Both ... In my situation, would it be possible to run a PSoS to create a find, and export to a new table, and once completed, the client user's will go to a defined layout to display the result of that new table? I guess this would cause another issue, if multiple users
  4. I have a fairly decent size FMdb; everything seems to be working as I want it, as far as calculating and presenting the information I want. However, it's really slow on generating Summary Reports when I'm connected to it on a WAN, or on a FMGo. The reports has a lot of calculation fields; Some values are ExcuteSQL for some Dynamic value changes, and some are TO related calculations. I wanted to try the Perform Script on Server, but I can not wrap my head on how to get started. The reports I'm running, is basically doing a Find and Sort. I don't understand how the Get(Result)?? to get the fo
  5. Thanks Kris!... I was just playing with it with your directions and it's working. I was worried that the exported file will not export on the second run due to the duplicate file name, but on the Perform Without Dialog, the file just replaced the first one. It's importing correctly as well. Thank you for your help!
  6. Thanks for the responses. @ Kris, the data on the Real table will change almost everyday, (records are updated and new ones being created) as a result the Summary report will change as well. So, my initial thought was to do a Data dump every night to the dummy table. My Summary Report for remote users will be the data from Dummy table. At the end of the day, i want to trash all the data in the Dummy Table, and import all the new calculated data from the Real Table to the dummy table again, so the next day remote users will have the new data for their summary report. So, I don't need this
  7. Hi, I'm working on a Database that has a lot of calculation and sub-summary. Everything works fine when I'm on the LAN, but when I tried to test it remotely, pulling up a summary report is really really slow because of the Calculation Fields, sorting and sub summary. So, I was thinking and read about creating a Dummy Table to dump all the records from the actual table with the calculation into a Table to store the calculated value as stored text or numbers. However, I'm having difficulty creating a script that will be run every evening. I've tried using an Export and Import, but the field
  8. Thanks David for the response. I'm trying to create a Summary Report that is sorted by Year, Fund, Department, and the body of it will be the Type. And I've used Calculation fields and then Summary fields to generate this report. Another big report I've made is like Cross-Tab monthly pay for each employee, sorted by Funds. So there are a lot of Sub-Summary calculation, and dynamic calculation based on a Global Field on the Fund number. Everything is calculating correctly, but it's just slow when I'm trying to access it off from the LAN. A performance/efficiency question; does the calculati
  9. Bruce, this is just a mock of a file that I'm working on. Here's the relationship setup that I have set up: Company -< Dept -< DeptYear -< EmplRcd -< EmplPayAdjust DeptYear -< Fund -<FundLine EmplRcd -< EmplAssignment >- (TO of Fund - using the TYPE field and pk_FundID; In the Fund Table, I have a Global Value for the Type; i.e. Staff, Teacher, Administrator, etc this will link up with the Calculated Type Value; so I can get the Sum of the Value who are Staff.) The TYPE is referencing the type Employee Record (Staff, Teacher, Administrator, etc). I need to sum the
  10. Thank you. I was thinking about triggers, but wanted to avoid it if possible. But the Trigger defiantly worked. Thanks.
  11. Hi, I'm trying to update a Calculated Field in a Child Table, that is getting a Calculated Field using the Auto-Enter. The Auto entry is working fine, but I want the calculated field to change in all the related records in the Child table, when I make changes to the Field in the Related parent Table. I was thinking about using the Evaluate(), but I'm having trouble getting that to work. The goal is to use the Calculated Auto-Enter field for a Relationship for a TO. I can not make a relationship with a Unstirred Calculated value. I've attached a sample file. Thanks. Evaluate.fmp12
  12. Hi I need help in creating a custom function to calculate a salary increases based on the Starting Monthly Salary. Here's my scenario; I have 2 Tables Employee --< Employee Pay The EMPLOYEE table will contain a Field with the Starting Salary; this will be the base value of the employee. Anytime the employee receives an increase, that will be added to the EMPLOYEE PAY table. In our organization, increases can come as a Flat amount or at times a percentage increase. Is it possible to create a Custom Function for this? What I had in mind was to have a Increase Type field in th
  13. EOS, the sample you gave me was GREAT. I didn't use the structure entirely, what I was missing was the Global value to establish a 2 value relationship in another TO. Thank you for your help!
  14. EOS... From the looks of it, your setup would work for me. But now I'll need to figure out what you did and implement it on to mine. I'll keep you posted. Thank you.
  15. Sorry for not being more clear. I'll trying to explain. And thank you again for taking the time to help with this. Regarding the 3 Screen Shots. Here's the process I had in mind steps. 1. At the beginning of the year I would create a Fund in the Fund Table. 2. Create an Expense in the Expense layout by clicking on a Button in the Fund Table. The button uses a script to go to the Expense layout and create a new record, captures the FiscalYear field pulled from the Fund and enters it into a FiscalYear field in the Expense table. The FiscalYear does not tie the Fund and Expense Tab
  • Create New...

Important Information

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