swillette

I had the wrong year in my find. I would like to delete this post but I don't see a delete button.

I have Instant Web Publishing turned on and when I view my layout in a browser, the web viewer field is not showing anything. I see the box, but there is nothing in it. I am currently on my Mac and trying to view it in Chrome, Safari, and Firefox. Thanks, Steve

I have a problem with a date find in a MS SQL related table. The user types in a begin and end date into two global fields, where I have a script put the dates into global variables. My script enters find mode and puts the two variables in the SQL date field for the search. Here is that part of the script. Set Field [TimeEntry::TEDate; $$BeginDate & “…” & $$EndDate] The script seems to work find bring up all found set records including the TEDate (s) for the range. The problem is that I get more records in my FileMaker layout then if I do the search using a SQL query directly in MS SQL Server Express 2005. Is the problem because of SQL’s date format? YYYY/mm/dd There is also a Time in this field, but all of the fields have 12:00:00 AM in them. I am using FileMaker 12 Advanced. Should I use the Execute SQL function to do this search in my script? Any help writing would be great.

I am using FileMaker Pro 12 and I have a main self-join MS SQL table that has four other tables related to it. Three of the four tables related to it are MS SQL tables. I need to pull data from certain fields from those tables into the main self-join table. The data that needs to be pulled are summaries based on a find. The main self-join table is related to the other four tables by a field called Project Id, and the self-join is related to the main table, where I want to show the results, by a field called Project Code. There are several Project ID records per Project Code. I want to show all the records related to the Project Code based on a find. I tried to use a Portal but it didn’t work. It would always show all the records in the related tables. You can only add a calculation or summary field to this table to the main table. Is there any way to do this without making another temp table to copy the field information from the other tables? What is the best way to show this information?

I tried using the 64 bit ODBC driver Data Source Administrator and FM 12 could not see the DSN that I created to connect to my MS SQLServer Express 2005 database. I used the path supplied by djc728 (c:WindowsSysWOW64odbcad32.exe) for the 32 bit ODBC driver Data Source Administrator and FM12 could see the 32bit DSN I created. I was able to connect to my SQLServer database.

I am serving (FM Server 8 on Windows 2003 server) a database with global fields that users can change/update. The problem is that when the users quit out of their FM clients, the numbers go back to what they were before they changed them. This happens to me also (I am an administrator). If you turn off the FM Server service on the Windows 2003 server, and open the file with FM Client from the server shared folder, you can change the numbers in the global fields, and the updates stay. Anyone else run into this problem?