hlabonte

Trying to get data out of an old database in FMP6. When we extract the fields with a hard return, it enters a funky character (looks like a square). Anyone know of a way to strip that out?

A-ha! That may be it. Thanks.

Hi all, I recently upgraded our server (windows) from FMP9 to FMP10. Just realized that my IWP solutions will no longer authenticate against our AD groups. I get the following error: "The account and password you entered cannot be used to access any databases on this server. Please try again." The AD authentication works for a client, but IWP logins only work against an actual FM account. The database is enabled for IWP. I have IWP enabled in the server admin console. I'm not sure what may be broken. Any tips?

Any way to allow a user to shift or cntl click multiple values in a drop down list in IWP. It works like a champ in the client. Any work around to getting that functionality in IWP? I hope, I hope, I hope!

I did contact them & am waiting on a reply. I do have the printed document from 2003, but it doesn't make sense. :

We bought the tool from New Millennium 5 yrs ago. I used it once or twice, but can't recall where to begin! I have the plugin file in the system directory. Hoe the heck do I use it? : Does anyone out there remember how to use it (i.e. what to launch?!)? TIA! FMP6 developer files

Ugh, those are the type of scripts I need to run from the server. Grr. One step forward, two steps back. :violin:

I have a script in a hosted database which imports records via a SQL server call. I'd like to schedule this to run in the evenings from the server, but the script fails with an error 643 "unsupported script step". Can anyone help me in how to schedule this type of a script on the server?

I'm stuck on what I think should be a simple issue. I have a small database (FMP9 adv) in which I want to use a SQL view for a value list. I have my one table defined. I have my one SQL view connected. View contains: id, section, year, term Table contains: student name, request, gender, etc. FMP table has one field "request" in which I would like to display/select from the values from the above view for selection. If I hard code the view data into a value list, I'm good. What I'd like to do is define a value list to pull fields from my view. My SQL view is not selectable when I choose" use values from field". Why is it greyed out? I know I'm missing something simple, but can't figure it out. TIA!

perfect, just what I needed! Thank you!

I need to look at the last character of a field and know whether it is alpha or numeric. Can anyone help me out on this?

Steven, that's it! Ugh! It was killing me. Thank you! :clap:

I've got a served FMP8 database that always open with the user ADMIN on open. I'm not sure why that's happening. I have security set up with AD groups with the exception of the Admin local account. All accounts are active. I've tried opening the solution on multiple PCs, but always get the same result (account name = Admin). I have a second database with similar set up, but that one opens correctly (without the admin user). Any thoughts on what's wrong? I can't deploy like this. :)

I've got an older DB in FMP6 that I need to export some data from. Whenever I export as a CSV, the file contains double quotes around my data fields. The program I need to feed this data to can't interpret the quotes. Here's one record as it is exported: "000011015","ACT","COM","11/11/2006","29","11","3/14/2007","3/14/2007","1","A08421","P000011015" I need: 000011015,ACT,COM,11/11/2006,29,11,3/14/2007,3/14/2007,1,A08421,P000011015 Of course I can do this manually, but that's silly. Anyone know how to export a CSV out of FMP6 without the quotes?

Yes, it's served. I'll read this over, thanks.

Silly question, but I'm stuck. I've got a container field, set as global, with 2 repetitions. Each will have a different image (jpeg). I copy & paste an image into the field. All works great. Once I exit the database and re-open it, the field is again empty. What am I missing? How do I get my image to stick in the field? :P

I figured it out myself by using a script variable.

Hi all, I've got a script that exports some data. I'd like to do a calculation for the file location / name. The name will vary with each export. I know there's a way to do it with a script parameter, but I can't quite fiture it out. For example, I want the export location to be: "filewin:/K:/Technical Services/E911/" & "test" & Location::julian_dt & ".dat" How do I perform the export records step and use a script parameter to force the location?

You do it with an import step. Import records, from ODBC source and call your SQL there.

Hi all, I'm using FMP 8 with server Advanced. I have two tables that are mirror copies of each other. I do a SQL call to update table B. Once I'm done, I want take a found set from that table and copy those records to table B. I'm not quite sure of how to accomplish this in FMP. Again the table structure & fields are exactly the same. Any thoughts?

Ah ha! I'll look for the v3 patch! Whew! I must admit, I was pretty nervous there! Thank you, thank you, thank you!

I just found that this happens when moving a solution from FMP7 to FMP8. I created a test database (attached) in FMP7. Searching works fine. I then moved the solution to our FMP8 server (advanced) and opened the hosted database. I attempt to do the search (FMP8 advanced) and it returns all rows. Anyone else encounter this issue? My previous FMP7 solution is 75% dependant on this type of searching. Please help! mytest.zip

Strange scenario in my solution...I have a db that was written in FMP7 and we are now on FMP8 (server advanced). Table: Reports Field course_name = calculation of courses::course_name_long (text) Table: courses Field: course_name_long = text field I have a layout based on the Reports table with several fields. When I do a find on the calculated field "course_name", I always get the entire database as my found set. It acts as if I've searched for "*". The field displays correctly on the layout with the proper related value, I just can't search on it. This seems to happen with any field that is a calculation from a different table. If I make a test field in Reports (text) and manually replace it's contents with the related field values, I can search it with the correct results. Any ideas? It used to work in FMP7.

Not sure if this is the best board, but... I've asked my managers if I can become FMP8 certified. They haven't denied me yet (the cost for coursework, etc.), but they haven't exactly embraced it. I was emailed the following: "Besides personal advancement, what advantages does becoming certified gain you?" Can anyone please help me to list the benefits to my management team? It seems like I need to justify the money. Thanks in advance, Heather

I changed my field B to be a calculation based on Fiedl A. That's all I really needed to do. Thanks for the one positive rely.