Kundinger

Sorry All... Lee had the correct solution... THANX, Lee! In 'Define Fields...' select the text field, click the 'Options' button, click the 'Storage' tab, select the "ASCII" menu choice from "Default language for indexing and sorting text". That fixed the problem. I only wish FMP had a ASCII/CHAR code function like most other applications. Thanx again Lee... Bob

Lee... I'm not sure what you are referring to... "Are you storing all fields as ASCII?" Thanx, Bob Kundinger bob@kundinger.org

Hello All... I have an issue with a 'relationship' finding the correct character in a related file. Here is how I did a test... - setup a file (ASCII Codes) with a 'char' text field and a 'code' text field -- this file has many records with individual alpha-numeric characters (a,b,c,d,1,2,3,4,A,B,C,D, etc.) entered into the 'char' field -- this same file has the same records with corresponding ASCII codes (97,98,99,100,49,50,51, etc.) entered into the 'code' field - setup a file (TEST) with a 'data' text field -- this file has a 'relationship'... "TEST:data = ASCII Codes:char" -- this file has a layout with... 'data' field & 'ASCII Codes:char' field & 'ASCII Codes:code' field Theory of operation... when a character "A" is entered into the 'TEST' file-'data' field... the 'related' 'char' & 'code' fields will display the correct alpha-numeric character and ASCII code "A" & "65". The problem... - when I enter "A" into the 'data' field, it returns the correct "A" & "65" - when I enter "2" into the 'data' field, it returns the correct "2" & "50" - when I enter "a" into the 'data' field, it returns the INCORRECT "A" & "65" - when I enter "=" into the 'data' field, it returns the INCORRECT " " & " " Observations... - FMP 6.04 appears to 'treat' "A" and "a" as the same character - FMP does NOT recognize various characters (=+-*&%$#@ etc.) when identifying characters Questions... - why does FMP treat "A" & "a" as the same character? - why does FMP NOT recognize other characters? - does FMP have a function or an unknown capability to process ASCII/CHAR codes? Thanx for the assistance! Bob Kundinger bob@kundinger.org

Hi 'ep820', Quick answer... create a report layout with subsummary-COUNT (when sorted by: Y-N field). Hope this helps... Good Luck! Bob Kundinger bob@kundinger.org

Hi Dan, Quick answer... take a look at the 'Status' functions... Status (CurrentPlatform) Status (CurrentScreenWidth) Status (CurrentScreenHeight) Status (CurrentScreenDepth) You could have a startup script that determines the platform & display settings... then automatically set your solution to go to an appropriate layout with the proper OS GUI & display setting. Hope this helps... let us know... Bob Kundinger bob@kundinger.org

Dan, Looks good... you 'overcame'! Other idea... you could have the script look for the Quickbooks directory using a specific path name... if not found... error message... if found... PROCEED! In your script... seterror capture ON import(data.xml,"C:pathname") if error = ##

Hi Lucky, You're lucky! You got an error code... "-3284". Most of the time, users won't show us an error code. I went to Apple's support site and entered "3284". It came back with a OpenTransport port error... very basic explanation. Are you accessing these files through a FireWall? You may want to check with your ISP. Also, you may want to 'play' with the OS-X FireWall software in 10.3 to see if you need to turn on any ports to allow communication with a FMP server. I have systems with OS-9/FMP Server 5.x with OS-9.x and OS-X 10.2 workstations... everything appears okay. Haven't updated any workstations to OS-X 10.3... waiting for future updates! This may warrant a call to Apple tech support! Good Luck! Let us know what you find. Bob Kundinger bob@kundinger.org

Stanley, Sorry, I don't have experience with clients with large imageDB systems. You might be on the right track with the large and/or corrupted images. I know from experience that corrupted images on layout cause system crashes... then file corruption... ETC. Bob

Dan, Sounds like you're on track to think this through... that's 'Learning FileMaker'! I've done my process (with specific user) through a Log-On system... it works good. I've never done what your looking at, but you seem to be going in the right direction. If not... thats how you learn a lot about FileMaker... go in different directions until you find the right path. Also... what is this script trying to do on a specific host? Archival/Backup? Later... Bob

Hi Ron, Quick answer... you could do a scripted loop to take a list of 'find' items and paste (setfield) them into multiple find requests. The 'find' items could be in a global list and <return> delimited. I'm not sure of your FMP experience and training... this could be complicated for novices. Hope this helps... Good Luck! Bob Kundinger bob@kundinger.org

Hi Dan, Quick answer... Host is the FMP software & computer who opened a specific file first (in multi-user mode). Here are some other senarios... - If the file is on a FMP Server, the server is the host... because the file was opened by the server. - If the file is on a workstation (no filesharing on), then this workstation will be the host when a user opens the file. - If the file is on a FILE server share-point, the host is the first FMP software & computer to open it. An idea to limit script access... Use script steps that look at the user/group name... only certain users/groups can continue the script... others get a friendly error. This can be managed within the FMP Access Privileges or managed within a customized Access/Privileges/Permissions/Rights Log-On system. Hope this helps... Good Luck! Bob Kundinger bob@kundinger.org

Hi Josh, Here is the basics of what you need... order.fp5

Hello 'montenegro', Welcome to the FMForum... the greatest FileMaker resource available!!! And, of course... welcome to FileMaker... an experience you'll come to love and hate! That said... I would recommend that you spend time learning the 'ins & outs' of FMP relationships... take some of the sample solutions you recieved on the FMP CD and 'tear' them apart to understand them. Focus on learning... - Parent-Child Relationships - Trigger Fields - Portals What you are working on should be a 'simple' enough system for you to 'cut your teeth on'! I would start simple and add functionality and features as you learn more and more. Please ARCHIVE each version of your system as you expand it. About your current system... "Vehicle Logging System" Fundamentally, you are on the right track with separating your 'vehicle info' from your 'in/out info'. When a vehicle pulls up to the gate... the system user enters the DecalID and enters IN or OUT. The issue you are experiencing seems to be how you do the 'IN & OUT'. You could have a portal on the Vehicle screen that shows all related 'In/Out' records... thus displaying a history of that vehicle. Then you click on a portal row that then displays the details to the system user for editing. The key to this working is understanding relations... the Parent file (left-side) must have a 'trigger' to show ONLY related records from the Child file (right-side). Some other 'points to ponder' about your system... - is it employee info or vehicle info, do you track each employee IN/OUT or each vehicle IN/OUT - can an employee have more than one vehicle - what happens when more than one employee rides-in, in one vehicle, and leaves separately - what happens if the vehicle doesn't leave today, but tomorrow, or out another gate - how do you handle visitors, visitor vehicles, employees with new vehicles, in a timely manner I'm not sure how 'secure' your installation needs to be... is it private, government, or military. Having grown up in the military and working with government organizations, I understand some of the issues with installation security. Hope this helps... Good Luck! Let us know how you are progressing! Bob Kundinger bob@kundinger.org

Hi 'hartmut77', Quick answer... go to the FileMaker site, click Support, and KnowledgeBase, enter the error number. Good Luck! Let us know what you found. Bob Kundinger bob@kundinger.org

HI All, I'm 'behind the times here'... people postin' while I'm writing my post. Anyway... another idea... SCREENSHOTS (cmd-shft-3) or (prntscrn)... then print to dot-matrix by shifting the pin-feeders to the right... that should give Paul the margins he needs. Bob