stash

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"; "" ) )

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.

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

Cool thing you made Comment! Thanks for the lesson.

Sorry, I dont get it. How that relationship could help?

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.

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!

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!

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....

Did you think something similar to this article of John Mark Osborne? http://my.advisor.com/articles.nsf/aid/16936

Does $$global take the value of none-global field and hand it to the another Table/Layout without using GoToLayout step?

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.

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:

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"...

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

Thanks for help guys! But, I want that horizontally scrolling exactly the same as it works for vertically. The point is that I have to place too many fields on a Portal. That means - I have to deal with huuuuge Portal. Indeed, Portals seem to be used under the so many limitations of FileMaker side.

Is possible to have horizontal scroll bar in Portal? Native options are not providing horizontally scrolling...but my hope is that here is someone who knows the trick. Thanks!

-I've tested plugin on FM5.5 and FM7. -Get or Post did work in some cases for FM5.5 but not for FM7. -Some abilities provided by plugin didnt find much exciting...can do the same with Open_URL function. -Therefore, I'll wait for real improuvments on Troi_URL before I start to use it.

"INSERT INTO tbltest SET title = "" & Art Database::title & "", Picture = "" " Try to copy-paste this one to your calculated SQL Result of "Execute SQL" function. As I know, you cant send the value(picture) from FileMaker to the BLOB field of mySQL server...neighter some value(picture) from mySQL to the Container field of FileMaker.

If you know how to write XSL for Themes, which are XML files, then you could do much more with them. Situation doesnt seem so limited.

1.0 To get a hundred adjust Ripper like this: Let ( [ // ** from first round fence $Start = Position(Field; "("; ""; 1); // ** to the first comma separator $End = Position(Field; ","; ""; 1) ]; /* Start correction plus 1 (otherwise you'll capture left round fence "(" in your result ) and with same reason end correction is -1 (to avoid comma sepratator in end result) */ Middle(Field; $Start+1; $End-$Start-1) ) 2.0 To get zeros: Let ( [ $Start = Position(Field; ","; ""; 1); $End = Position(Field; ")"; ""; 1) ]; Middle(Field; $Start+1; $End-$Start-1) )

If some of your fields,supposted to import, contain validation which is set to validate "Always", be sure in your Import script you first did satisfy condition of certain validation and then do the import. If your validation for example contains that Field_A = 5, then in script which calls Import function put: SetField[Field_A; 5] and in script line below, call the import. It's simple thing which once did take me a day to figure out

Considering similar SOS calls on web I've realised that there should be "something" between Get(SystemNICaddress) and hardware...so I called good friend which knows these hardware and Windows XP things better than me. 1.0 Integral Network Cards: First thing he has noticed is that my network card is integral and that could be important because many of these SOS calles has arrived from people who have the laptops - I guess they have integrated network cards too. 2.0 Changes on hardware: Before I did replaced old hard disc with the new one, the Get(SystemNICaddress) worked properly. So, the second conclusion is that Get(SystemNICaddress) could fail after "certain" hardware intervetions. 3.0 Solution: After last experience I dont feel confident with using Get() function. Instead, good friend of mine Veselko and me did figure out that we can use SendEvent script and initiate CommandPrompt, send there command: ipconfig/all, then make file which contains Physical Address and use it. Of course with little help of Troi plugin. This solution works fine even in "fat-client mode", just be sure you have enabled your network card.

More informations about similar situation by Dave Herman: Just some information that I have found. I recently created a solution and developed it on my Mac. I used the Get(SystemNICAddress) function for a specific purpose that I won't discuss. However, when I finished the solution and moved it over to my Windows XP Pro PC to test, the function returned no value. This is what I have found out and hopefully it will help someone else in this group before they release a solution to a client that may or may not work the way they intended. I am using a wireless network adapter in my PC with my built-in ethernet adapter disabled. I disabled the wireless adapter, enabled the internal adapter,plugged it into the network and the function returned the NIC for the built in network adapter. GREAT! NOT SO GREAT... If I re-enabled the wireless adapter, the function returned a NIL value again even though the built-in adapter was still enabled and plugged in to the network. AGAIN, NOT SO GREAT... I disabled the wireless adapter, left the built-in adapter enabled but unplugged it from the network. The function would not return the NIC address. GREAT FOR THE MAC! I went back to my Mac and unplugged it from the network. The function returned the NIC address even though the computer was disconnected from the network. So, this is my story. I have reported all of this to FileMaker. I searched the internet last night and found a couple of discussion groups where others were having the same problem but didn't find a solution until I experimented this morning. Dave Herman

OK, this might be one of the unanswered or less explored areas. I'm still on problem and as soon as I figure out solution, I'll post it. In mean while here is one link to the post with similar problem...who wants to check out: http://www.fmforums.com/threads/showflat...true#Post137358