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 are running the same report with different variable. Any suggestions on how to tackle this problem? Thanks.
  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 found and sorted information to the Layout I want to display. Any help/resource would be great. Thanks.
  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 "Import matching records on the primary key of the origin table matching the primary key of the dummy table, create new record if not matched." The concern I have, is the the data won't match the field names; I did not see a step script to change the import to Matching Name. Did I over look something? Thanks.
  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 value does not correspond with the original table fields. Whats the best of of doing this? Thanks.
  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 calculation get processed faster with an Execute SQL or through a TO relationship? Or no difference? TO creates a Havoc on the Relationship map :), but I was looking into using SQL more. thanks.
  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 adjustments based on the type of employee, like a Cross-Tab table. When I use a calculation field, it will not allow me to establish a relationship, however, when I create it as a Text field w/Calculation value, the relationship can be established and I can get a Sum of the Amount for each Employee Type. Any Suggestions? Another issue I had with DB design, is that I have a lot of Summary/Calculation Value, and when I tried running this on an FMGO (FMGO14 on FMServer 14) it's slow and REALLY slow when I'm connecting on remotely off the local network. So, I was reading and should create a "dummy table" to duplicate the table and create a report off the dummy table, so all the calculation are values and not be calculated on the fly. So duplicate a table and its record every night. However,r I'm stumped on how to do this using a Script. Suggestions on this would be appreciated too. Thanks.
  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 the Employee Pay table, and depending on the selection. Also, the calculation will be a sequential order by Effective Date of the increase. I'm a Novice when dealing with complicated Calculations. Any suggestions? Thank
  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 Table together. 3. Once the Expense is created, I'll be entering items into the Expense Line item portal. Each Expense Line will have a Funding Source, which will be a Filter Drop Down Value to get the Fund ID that's available in that particular Fiscal Year. So, if I had purchased 2 computers on the same PO, I would be able to charge 1 computer to Fund 70000 and 1 computer to 48110. If you look at the Expense screen shot, $113 is charged Fund 70000 (FundID 1) and the other $1000 is charged to 48110 (Fund ID 2). What I want to do is be able to see the Total of the Expense related to the Fund that I'm browsing. So Expense Portal (Expense Tab) for Fund ID 1 should only show a total of $113, and Fund ID 2 will show a total of $1000. But that does not seem to be the case. And I can't figure out why. I've attached a screenshot of my relationship. 4. Based on the relationship, I can create a Portal of the Expense Line in the Fund layout, I believe that would calculate the correct value, because it has a direct relationship using the FundID as the common key. But I don't want to see every Expense Line. Can you send you the FM file and take a look at what I have? Thanks again!
  • Create New...

Important Information

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