Ano Nimus

Maybe you could substitute the " for something like §§§ first, then substitute your values and then substitute §§§ for " again?

Just thinking out loud here so I may miss something obvious, but you may not be able to base value lists on the values in the SQL table, but you *can* see them. If you import them once, then somehow compare the values in the SQL table and FMP over a relationship and in the value lists show only the values that exist in both, a sort of conditional value list? Going forward, you'd only need to import from the SQL source, (updating existing records) because any values that are too many in FMP would be filtered out.

They are table [color:red]occurances, not tables. You are looking at the exact same table that contains the data.

Haha, yes : Then again, try clicking the text tool whilst in browse mode, now that's a challenge :

Yes, that would seem to be the case. If you do a lot with buttons, ie if you want to make it look like they dynamically change, I think you may want to look into another way of doing this, by showing portals in which these buttons appear rather than creating a lot of layouts.

You could duplicate the layout, then adjust it to show whatever table you like and add the necessary fields to it.

If you create a clone of the database on a system with US/UK formats, that clone will have those formats.

In the Status Area (to the left) click on the tool with the 'A' on it, then click on the button.

This is due to the activation being disturbed, somehow, by the mere fact that remote desktop is running. If you put FMP9 in the startup group, restart the machine, then connect to it through remote desktop, it's OK. If you then close FMP9 and start it again, you'll get error -103 again.

Maybe you can use this: ftp://ftp.apple.com/filemaker/trial_software/fm/fm_21_trial.hqx

Hi, I found this site really helpful for taking the first steps: http://dev.mysql.com/doc/

Hi, The database is being shared from FM Server 9 Advanced, with 'Access via PHP Web Publishing' activated in the privilige set that is being used by the user Admin. We can open the database remotely, using Admin/no password. When we start the PHP Site Assistant, it asks us what Security Policy we would like to use. We choose 'Prompt user for authentication when accessing site', then click 'open database'. It asks for the username/password, but its reaction to Admin/no password is 'invalid user name or password. Please try again.' That username/password combo is absolutely correct, we can open the file with it after all. Tried it locally on the machine where FMS9Adv is running and from a remote machine, but that makes no difference. Would anyone have an idea what could cause this? Thanks in advance(d), Ano

As far as I understand, these files are not the user's intellectual property. Dodgy area at best.

That's illegal, be careful with that...

Maybe, but real developer base or end-user-toy, FMI will likely go for the model that yields most for themselves - I just can't see the financial benefit for FMI.

Only three times? For FMI, the gained revenue from that would be drops in the ocean against the loss in revenue from not selling FMP licenses (apart from the single boxes) anymore. That loss, I suppose, would have to be reflected in the price of FM Developer versions, we might be looking at (wild guess from my side) a tenfold increase in price rather than threefold. And what about the developers who don't want to create runtimes? FMI would need to develop a seperate version that excludes that feature or lose those buyers. More trouble/costs for them, not to mention having the added marketing issue of adding a new product to the product line. Whilst thin clients would be great for developers/end-users, what's in it for FMI? Note that I'm not qualifying nor quantifying FMIs 'greediness', I'm not privy to their profit margins. And who knows how much influence the hq at Cupertino has on the pricing policy?

I don't know the answer to your question, but if it's easier for you to communicate in French, this is a good place: (Je ne sais pas la réponse sur votre question, mais si c'est plus comfortable pour vous de discuter en Français, vous pouvez essayer ce lien: ) http://www.fmsource.com/forum/

Yes, I think I know what you mean. Nobody is forcing you to use it. Piracy is bad, mkay?

Thanks for the info , Steven :)

Someone I know wants to distribute a runtime (FMP8.5 Adv) to colleagues of his in some countries where it is mandatory to let the authorities know what kind of encryption is used in the software. Does anyone here know what kind of encryption FileMaker uses to protect passwords in runtimes? What length would the encryption keys be? I know nothing at all about this stuff, so I hope I asked the right questions regards, Ano

As it's a text file, you could simply import it into a text field and parse the last line from that text field?

If you put the script step Show/Hide Status Area [Lock; Hide] in the script you use to navigate to that layout, that should have the desired effect.

Behind the lines in that field, you can't see 'em, but they're there, are CR signs (¶). With "Position", you can count the how manieth ¶ is just in front of the line that you want to extract and the how manieth is just behind. Once you determine the positions of the two ¶, you can use "Middle" to extract the text in between both. You'd get the third line, as an example, by creating this calculation: // Take characters from the field YourTextField Middle ( YourTextField ; // starting with the the 1st character behind the position of the 2nd ¶ (Position ( YourTextField ; "¶" ; 1 ; 2 ) +1 ) ; // the number of characters equals the difference between the positions of the 2nd and the 3rd ¶ (Position ( YourTextField ; "¶" ; 1 ; 3 ) - Position ( YourTextField ; "¶" ; 1 ; 2 ) ) )

Thanks, T-Square. It turned out that the problem was gone as soon as I cloned the database (which I received from the UK) on a German system. It seems that FM embeds some stuff in the db that throws a German Entourage off when sending.

Hi all, Using a German speaking OS 10.4.2 and MS Entourage. In the database, I have a text field in which I sometimes type text directly and sometimes copy and paste text from other sources. If I use the script step Send Mail to put the content of this field into an email, it is put into my drafts. There, the mail looks fine, exactly as it is in the field. When I then send the mail, two things happen: on top of the received mail the following info is added: Mime-version: 1.0 Content-type: text/plain charset="ISO-8859-1" Content-transfer-encoding: quoted-printable furthermore, diacritical signs (such as ä, ö, ü and ß) are being translated to some sort of encoding I don't know: ä becomes =E4 ü becomes =FC and there are also a couple of =20 at the end, they could be returns. If I type these signs directly in Entourage, there is no problem, it just occurs if these signs came from FileMaker. Does anybody have an idea about what might be going on here? Thanks, Ano