Hi there,

I wanted to delete a foundset of records from web (web companion).

It seems that I can only delete a record at a time using -recid.

Is there a way I can delete mutiple records at a time?

Thanks a lot for your help.

Hameed

I am using FX.php plugin to connect web companion

PHP Scripting on Apache Server on Windows 2000 Machine

FMP 6 client as webcompanion server

RE: I am using FX.php plugin to connect web companion

PHP Scripting on Apache Server on Windows 2000 Machine

FMP 6 client as webcompanion server

You can probably run Loop and increment the -recid. Or store -recid(s) in variables and run Loop.

BTW to use FMP 6 *client* for web serving purpose is illegal and against your FM license.

If middleware (Lasso or PHP) is used, FM Unlimited version is required.

Re: to use FMP 6 *client* for web serving purpose is illegal and against your FM license

No it is NOT!!!

Stop misleading people.

Garry

Study a bit FM documents instead of accusing me.

FileMaker Pro 6 And FileMaker Pro 6 Unlimited End User License Clarification For Use Of Middleware Or Third Party Software

--------------------------------------------------------------------------------

The FileMaker Pro 6 license states:

"You are further prohibited from using the standard version of FileMaker Pro with any middleware, application server, CGI, or other software or technology that allows more than a single client to access any FileMaker Pro database"

Development tools, such as Lasso Studio 6 or Lasso Developer 6 (allows only single-user access as a development tool), may be used with FileMaker Pro 6, for development purposes only.

The FileMaker Pro 6 Unlimited license adds:

"You may also use FileMaker Pro Unlimited with middleware, application server, CGI, or other software or technology when hosting a FileMaker Pro database."

Therefore, for DEPLOYMENT of the web solution, if you are also planning on using any middleware, application server, CGI, or other software or technology such as Lasso Professional 6, you must use FileMaker Pro 6 Unlimited.

How do they define a Client?

Is that an "End-User" or an "Application"?

Very interesting

Garry

I believe the "If middleware (Lasso or PHP) is used, FM Unlimited version is required." is enough.

What do you think Client is?

Furthermore FMI *is clear* "Therefore, for DEPLOYMENT of the web solution, if you are also planning on using any middleware, application server, CGI, or other software or technology such as Lasso Professional 6, you must use FileMaker Pro 6 Unlimited."

The main "hint" that makes me believe they are speaking about an Application Client is that they state:

not "more than a single client".

Elsewhere they speak about the restriction being 10 IPs in a 12 hour period.

Hence, if they where inferring the same type of Client they would be contradictory within their own document.

I wish FMI would have better communications with its User/Developer community. This would help with clarifing such issues.

All the best.

Garry

"You are further prohibited from using the standard version of FileMaker Pro with any middleware, application server, CGI, or other software or technology that allows more than a single client to access any FileMaker Pro database"

Client is web or Intranet visitor. This is License restriction.

The "10 IPs in a 12 hour period" is built in restriction in FMP.

So while it works, because WC cannot detect who actually made the initial connection, it is against FM License.

BlueWorld is also clear in their licensing notes.

Develop with FMP (Client -- oh my, another client) and that is OK.

Serve that to Intranet or Internet -- Unlimited is compulsory.

Re: I wanted to delete a foundset of records

You could use a Filemaker Script to do the job. This is, of course, if the probability of two or more users attempting to use the Script, at close to the same time, is close to zero.

Good Luck.

Garry

I've found one quirk with deleting records from hosted database. Sometimes they are internally locked and cannot be deleted. That happens after database was served to web and not before WC was in action.

"... if the probability of two or more users attempting to use the Script, at close to the same time, is close to zero" need not be an issue if you develop a solution in which the CDML and ScriptMaker work together and allow a failed event to be recognized and events not processed to be processed.

It can be done. I know. If I could figure it out, you can too. It may take less than two months of your life. You will feel a sense of real accomplishment.

Are you still selling the solution?

All the best.

Garry

Not right now. Won't know till after bankruptcy who owns it.

But it only cost me $36k to develop at a time when I had just begun doing web stuff and had never done a db for a multiuser. So I figure that if I could do it at that point, with so little information and knowledge, anyone can. Especially since now a lot more information is available as a starting point. Probably enough out there now that it could cut someone else's development cost by a third or a half.

Maybe that cost is why I didn't want to just give it away. I know, call me selfish. All I can tell you is that $100 seems to have been too much for me to ask for it. I was never good at capitalism.