Jump to content

stash

Members
  • Posts

    52
  • Joined

  • Last visited

About stash

  • Birthday 09/30/1971

stash's Achievements

Contributor

Contributor (5/14)

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

Recent Badges

0

Reputation

  1. One WARNING about using this custom function! There is some unexpectable limitation on amount of retreived data. The recommended amount is "middle size" of data. Test this solution on your case before applay it. This is most simple solution and these kind are always most stable in programming: Case ( External ( "SQL-getRow"; "" ) = "EMPTY"; ""; ST_PDM_Get_Row ( ) & ¶ & External ( "SQL-getRow"; "" ) )
  2. As I found, it's not possible to display variables on layouts by themself. If you store the value of variable to the field placed on layout, then it works out. I'm not pleased with this solution because have expected variables being same or similar as they are in other script languages such as php.
  3. I did lot of tests on this combination and all worked out but doesnt mean that soon will get some exception at this point. Might be good to have one post where developers can leave these exceptions
  4. Cool thing you made Comment! Thanks for the lesson.
  5. Sorry, I dont get it. How that relationship could help?
  6. After testing GetNthRecord cant hidde my frustration that FileMaker8 provides such nice 'one way' functionality. Pretty cool to Get field content on Nth record but could be much better if we also can Set content on Nth record. Indeed, SetField options remaind being too stiff.
  7. O-Hooooo! Flisakowski and Osborne are talking about pretty much similar(same indeed) thing. From me side little advantage to the Flisakowski's solution is given. Thanks Ender!
  8. uf sorry, it's for subscribers but wont be bad if just tell you what have heard about the GetNthRecord from the tip of John Mark Osborne. The point is in this recursive custom function which is indeed one parser who collects Field values(Field paramether in function) out of the FoundSet to the global field or $$Variable but without looping! Two Parameters: Field - like it says Found - Get(FoundCount) The Function: SerialNumbers(Field; Found) = Case( Found > 1; GetNthRecord(Field; Found) & "¶" & SerialNumbers(Field; Found -1); GetNthRecord(Field; 1) //Eliminates extra return at end ) BTW, the limit of this recursive is on 10.000 records. Mark has some ideas about this problem, with the related records, but to me that seems as a mend. Cool thing to be more explored. Thanks for new links, will go to check them out immediatly after this post!
  9. Check this out at: http://my.advisor.com/articles.nsf/aid/16936 ADVISOR TIPS Get to Know GetNthRecord Don't overlook this new, powerful feature that lets you get a field value from any record in the found set. By John Mark Osborne, Database Pros president and owner & FileMaker Advisor technical editor Add your comments on this topic....
  10. Did you think something similar to this article of John Mark Osborne? http://my.advisor.com/articles.nsf/aid/16936
  11. Does $$global take the value of none-global field and hand it to the another Table/Layout without using GoToLayout step?
  12. Ups, little correction: Let ( $GET_ROW = External ( "SQL-getRow"; "" ); Case ( PatternCount ( $GET_ROW; "EMPTY" ) = 0; ST_PDM_Get_Row ( ) & ¶ & $GET_ROW; "" ) ) In this case you dont need to get rid off(substitute) "EMPTY" in retreived result array.
  13. One simple solution with recursive custom function: Custom function named as: ST_PDM_Get_Row. Without paramethers. Let ( $GET_ROW = External ( "SQL-getRow"; "" ); Case ( PatternCount ( $GET_ROW; "EMPTY" ) = 0; ST_PDM_Get_Row ( ) & ¶ & $GET_ROW; $GET_ROW ) ) So, when you have to call it in a script, first make SQL query and then: SetField [some_Global_Field; ST_PDM_Get_Row()] After you get retreived SQL records in global field first have to substitute "EMPTY" with "" and then, if needed, to parse out each separate record to the supposted non-global fields. Works out in me case. :tigger:
  14. Might be the tip for next "victime at the same trap". It doesnt work well with the loop. So, instead to loop, make several copy-paste (depending on number of expected results) ///////////////////////////////// If (Field_Get_Row = "EMPTY") exit endif SetField[Field_Get_Row;External ( "SQL-getRow"; "" )] If (Field_Get_Row = "EMPTY") exit endif SetField[Field_Get_Row;External ( "SQL-getRow"; "" )] /////////////////////////// Ugly solution like a pain. Might be better to figure out Recursive function which will make calls to the "SQL-getRow"...
  15. This is a real fun that I got of PDM plugin. Instead to get retreived each row of this simple SQL query I'm getting each second row. Does anyone share my experience or better if has a tip about this situation? Hvala(Thanks)! SetField[Field_Desc; External ( "SQL-execQuery"; "DESC Table_Name" )] Loop SetField[Field_Get_Row;External ( "SQL-getRow"; "" )] ExitLoopIf EndLoop
×
×
  • Create New...

Important Information

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