aklodner

hmmmm...I have a thought (which is rare these days!). The advanced server that is hosting the original files, is that doing any web hosting yet? If not, under the Enable Client Services button, what if you put the web identifier for the FSA box that has the ghost file on it. I'm thinking that that server would not accpet web calls from the other server. Again, this is purely just a thought. HTH, Adam

Hi jhomer, Is your ghost file on another FM Server, or just running on the other box in FileMaker (regular)? To post data that's being hosted via FM Server to the web, either IWP or CWP, you need to go through FM Server Advanced. HTH, Adam

Hey guys, Jeff, just curious, have you tried uninstalling/reinstalling the DataDirect drivers? The error message your getting seems to be an internal error, something wrong with the driver. Just a thought. Brudderman, are you using FileMaker Server Advanced? You need that for JDBC and also, make sure the drivers you're using are at the same updated version as server. I've heard there's some problems if they're not. HTH, Adam

Actually, I found out what it means. There's a pdf that comes with the driver called SequelLink Trouble shooting guide and reference. They had a list of errors and here's what 3201 is: Unable to retrieve error message from backend ODBC driver. Cause An internal error occurred. Action Contact DataDirect Technologies technical support. Sorry I don't have any more info, but it sounds like you might need to give those guys a call. Adam

What does the rest of the error dialog box say? I've seen -201 errors, they usually mean a username or password is incorrect. I've also seen 2306, and it means it wasn't able to connect to the db. Any more info would help. Thanks, Adam

Hi Jeff, If the FM 7 database is on your machine, make the Server Host be localhost or 127.0.0.1 (a loop back to your machine). If the database is elsewhere, put the IP address of that machine in the Server Host box. For the port number, FileMaker uses port 2399 for ODBC. Make sure you have ODBC sharing turned on in the FM Database as well. HTH Adam

I've actually had good succes with FM 7 pushing and pulling data from SQL, without overly complicated scripts. It also seems that the ODBC functionality is faster with FM 7 than in previous versions. Just my experience. Cheers, Adam

Hi Chris, If you're using FM 7, you can tell a portal which row to begin on. So, lets say for example, on the first page you display the first 10 line items. Create a second portal, same relationship and sort order, on the second page that starts at 11. This should work. On a separate note, you could/should print your invoices from the line items table, using sub summary parts. Then you wouldn't have to worry about laying out the portals at all. HTH, Adam

NOTE: this is in response to zincb I posted this in another area, so I figured I post it here too. Here's an interesting tidbit. If you use a back slash, "", in front of the "search" word, instead of "/", it works right. So, make your calc look like this: "http://www.google.comsearch?hl=en&q=" & googleMe & "&btnG=Google+Search" HTH Adam

Here's an interesting tidbit. If you use a back slash, "", in front of the "search" word, instead of "/", it works right. So, make your calc look like this: "http://www.google.comsearch?hl=en&q=" & googleMe & "&btnG=Google+Search" HTH Adam

Hi Bekah, Just quickly looking at your script, it looks like you have your parameters mixed up. Right now, you're dividing by 2 and rounding out to 100 places. Swap the 2's and the 100's and see if that helps. HTH Adam

Hey guys, I think I've come up with a potential solution. I've done some early testing and it works, but need more testing. Here's the skinny: Assume my table occurence is called 'tablename', my letter field is 'textField' and my pick list field is 'gText'. Step 1: Create a calc field that uses the evaluate function cPosition = Evaluate("Get ( ActiveSelectionStart ) &

Hey Larry, Not sure if I'd consider it strange, since it is helpful, but here's some thoughts. If the user wraps the email address in quotes, the find should work. Additionally, if they are entering an entire email address you can use the double equals symbol (exact field content match) as well. HTH Adam

You're right, the lookup in IWP seems to not update. But, if you make a calculated field that uses the new Lookup() function, that will work once you commit the record. HTH Adam

Hi Pat, The way I get around that is by hiding the entire status area. To do this, create a script that hides the status area and locks it. Set that script to run on open in the File Options. This will make it so the users can't and won't see those buttons. One thing though. Since you're hiding those buttons, you'll have to make use of the Committ and/or Revert record commands in your scripts. HTH Adam

What they're talking about is running AppleScripts or Batch files, depending on platform. These scripts can then perform additional tasks at the time you schedule them. HTH Adam

Hey Thomas, When triggering the Relookup, make sure your cursor is in the key field of the relationship you've setup. HTH, Adam

In the script where you call the new window, put a pause script step in there after you call the new window. This will "freeze" the window. Then, when you specify your save or cancle buttons, have them resume current script. This will kill the pause. One last note, make sure to use Allow User Abort (off) script step in the script that's calling the new window. If you don't, a user can still click on the close window button and get out of that window. Not only do they get out of the window, but your paused script then carries over to the next active window. HTH, Adam

Try this out, make Total Cost calculation as follows: (photo cost + copy cost) - Case(discount = "yes", (photo cost + copy cost)*.5, 0) HTH, Adam

Maybe try this route. Make your handicaps field a text type field, the one you enter into. Then, create the following calculation and set type result as number: Case(PatternCount(textField , "s" ) > 0, Round(TextToNum(textField),0), Int(TextToNum(textField))) What's happening, is even though the numeric field is displaying 0.5s, it's only being read as 0.5. So, make it a text, then in the calc, use the texttonum() function to turn the text into a number format. Then, it should work. Hope this one works! Adam

You can find field validation where you define the fields. Highlight the field, select options and you're in. If you're using 7, on the layout setup, if you uncheck save records automatically, it will prompt the user to save changes or cancel. It's cool because it'll roll back the changes. But, it won't tell which field was changed, just that the record has been changed. HTH, Adam

Just one other quick question, are the fields formatted to Titlecase? If so, this does not necessarily mean the data, text, was entered in titlecase. To ensure that titlecase is enforced in your calc, you could do something like this: TextStyleAdd(field1; Titlecase) & " - " & TextStyleAdd(field2; Titlecase) & " - " & TextStyleAdd(field3; Titlecase)& " - " & TextStyleAdd(field4; Titlecase) The hyphens are optional, use whatever your using in your concatenation. What this calc will do is make the data titlecase, regardless of the way it was entered in the original fields. HTH Adam

Try using the int() function. Int will drop the decimal, so in your example the following would happen: int(0.5) would result in 0 int(1.5) would result in 1 int(2.5) would result in 2 You could then convert these numbers to negatives for your other calcs. Hope this helps, best of luck in your tournaments. Adam

The Support Group will be hosting

Short answer is, no, a table in a FileMaker 7 file cannot be duplicated, nor can it be imported from another file. But, from what I've read I believe you can do this with FMRobot from New Millenium. Adam