edit & delete in cdml

[wanewrld]

Hi, You guys have helped me in the past, so here goes. I used the filemaker connection assistant to make my format files, I check the edit individual records & delete individual records box's, but the program does not create the format files for these functions. Any ideas on what I can do? I can search and add new records with no problem to my database on the web. But i also need to be able to delete records and edit existing records. I get lost when i look at doing this by hand in cdml. Is there a CDML for dummies book? Thanks for your time, Wayne

[Vaughan]

You mean the FileMaker Connection Assistant in Home Page 3?

From memory it does not create separate pages for delete, it puts a form button on the bottom of the edit page (or it might be the detail page, cannot remember).

[JitseSchaafsma]

I thought when you use the filemaker connection assistant those requested features should be specifically checked. Maybe start claris home page again and create a new filemaker template. Check carefull all the checkboxes. Maybe that will do.

Good luck

Jitse

[Steve T.]

Hi, Wayne! If you decide to go the CDML-by-hand route, you may be able to modify a search page into a delete/edit page, depending upon how complex your db and pages are. When you delete or edit, you have to have FMP recognize EXACTLY what record to perform the action on [FMP-CurrentRecID] and then change the action tag from -find to -edit or -delete. Note, however, that some folks prefer not to delete records at all... they just change their status to inactive/offline or virtually deleted.

No, I don't know of any good CDML books but I haven't been looking. FMP gives you some reference and code tools which you should use (web reference at http://www.cmdl.org) and FMFORUMS has some starter kits available for download you may want to get, too.

You can also try posting your code in this forum and sometimes folks will lend a hand or even do it for you.

--ST

[wanewrld]

Thanks guys for the feedback. I have it so I can delete a record now, but when I try to edit a record I get the following error,........ There was an error editing a record in the shows-db.fp5 database. Please check your

submission and try again. - [# ERR: 102]....... I am also looking for a new host company for my database. The one I have now, has the worst customer service of any company I have ever worked with. Does anyone know of decent host for 1 database, that runs about $50.00 a month? Thanks again for the help, you guys are the best.

Wayne

[Unable]

Error 102 = field missing.

You can find a list of FileMaker errors in FileMaker/Help/Status(CurrentError)

Sounds like a field is missing from the layout which you are editing. If you have one layout for the web, you can avoid many problems.

[Anatoli]

Thanks guys for the feedback. I have it so I can delete a record now, but when I try to edit a record I get the following error,........ There was an error editing a record in the shows-db.fp5 database. Please check your

submission and try again. - [# ERR: 102]....... I am also looking for a new host company for my database. The one I have now, has the worst customer service of any company I have ever worked with. Does anyone know of decent host for 1 database, that runs about $50.00 a month? Thanks again for the help, you guys are the best.

Wayne

Try http://www.pointinspace.com, Mr. John May.