YKB

On the contrary, when using a calendar you only need to select the date and it will enter the current time for you

No, our database isn't accessed using ESS The original field, in SQL is a date/time field When I link the database to FileMaker, it automatically configures this field to be a timestamp field... and I can't change it to be any other field. when I add a drop down calendar to the field I am able to use and see this drop down calendar (when viewing the file through FileMaker itself) but when viewing the file through IWP I can't see or use the drop down calendar, I have to enter the date manually, meaning that I also have to enter a time with it... the users of the application won’t be happy to be entering a time with every date. So I need to overcome this problem.

I'm having a problem with Instant Web Publishing, where my calendar drop down box isn’t appearing on the screen, but only when I am accessing the file through IWP. I have a SQL backend database, where there are some date fields which are of a date/time data type (which means that in FileMaker these fields are automatically made to be of type timestamp). I have set up the layout so that these fields have a drop down calendar available, to make it easier for the users to enter the date in the correct format. When I am in browse mode on FileMaker I am able to use and see the drop down calendar. However if I access the file through IWP, the drop down calendar doesn't show up, not in any mode, browse or find. Originally I thought that IWP wasn't able to display the drop down calendars, but then I created a field, which is of type text and assigned it to have a drop down calendar box. When I opened the file through IWP, only THIS field’s drop down calendar showed up. Is this a known problem? Is there a way of getting around it? I was thinking to try and change the data type that FileMaker sets up for date/time data types, so change it from being a timestamp to text... but it doesn’t let me change the data type Any help would be very much appreciated Regards YKB

I'm having a problem with Instant Web Publishing, where my calendar drop down box isn’t appearing on the screen, but only when I am accessing the file through IWP. I have a SQL backend database, where there are some date fields which are of a date/time data type (which means that in FileMaker these fields are automatically made to be of type timestamp). I have set up the layout so that these fields have a drop down calendar available, to make it easier for the users to enter the date in the correct format. When I am in browse mode on FileMaker I am able to use and see the drop down calendar. However if I access the file through IWP, the drop down calendar doesn't show up, not in any mode, browse or find. Originally I thought that IWP wasn't able to display the drop down calendars, but then I created a field, which is of type text and assigned it to have a drop down calendar box. When I opened the file through IWP, only THIS field’s drop down calendar showed up. Is this a known problem? Is there a way of getting around it? I was thinking to try and change the data type that FileMaker sets up for date/time data types, so change it from being a timestamp to text... but it doesn’t let me change the data type Any help would be very much appreciated Regards YKB

Hi sirglandon, just wondering if you have any news regarding this insert trigger issue that we both seem to be having. I still haven't heard anything back from filemaker, and it's getting to the point in my project where I really need the insert trigger to be working

Yeh, I’ve already reported this problem to them (a month ago) and I still haven't received a reply from them. I’ll post the answer back here, if they get back to me... if you could do the same that would be great! Thanks

Thank you very much. worked like a charm YKB

Hi all, I still haven't received a solution from this problem...if anyone knows anything, can you please post here! Any help would be appreciated!! Thanks YKB

I am having a problem when opening a file in Filemaker. When I open it, it comes up with a message saying "This action could not be performed because the required table is missing"... when I press OK, it presents me with my correct data. How can I get rid of this message popping up every time that I open this file? I have created many files through Filemaker and have never had this message appear, and I am not sure what I have done differently. I would really appreciate some help on how to get rid of this message. Thanks YKB

Hi, I have an Asset Management System through FileMaker Pro. But I am using a SQL server back end database. I am trying to write a trigger in SQL Server so that once a new record is inserted that it updates the barcode number according to the assessment centre that this asset belongs to. The trigger is as follows: ALTER TRIGGER [dbo].[Create_Barcode_Number] ON [dbo].[AssetManagement] AFTER INSERT AS BEGIN declare @var varchar(255) declare @code varchar(255) SET NOCOUNT ON; if (select AssessmentCenterContractor from inserted) = 'Carlton' select @var = 'CTN' if (select AssessmentCenterContractor from inserted) = 'Geelong' select @var = 'GEE' begin select @code = (select UniqueAssetCode from inserted) select @var = @var + @code update AssetManagement set AssetManagement.Barcode = @var WHERE AssetManagement.UniqueAssetCode = (select UniqueAssetCode from inserted) end END What it is doing, is checking the assessment centre of the newly inserted asset, abbreviating it and then concatenating the abbreviation to the unique asset code (which is automatically generated) The trigger works fine through SQL Server, i.e. if I go and insert a new record through SQL Server, the trigger is successful. But when I insert a new record through Filemaker, and press save it gives me the following error: "ODBC Error: [Microsoft][ODBC SQL Server Driver][sql Server] The target table 'FileMaker.dbo.AssetManagement if the DML statement cannot have any enabled triggers if the statement contains an OUTPUT clause without INTO clause" I am not really sure what this statement means or how to fix it. Help would be very much appreciated Thanks YKB

Alright, thanks for your help : YKB

Thanks for the quick reply... I understand that IWP may not support the preview mode, but shouldn't it still print the same way that it does when I press print through FileMaker Pro? For example: In FileMaker Pro, when I browse for some records and then view it in the label layout and press print (WITHOUT going into preview mode) it prints me the labels exactly the way that they should appear So then through IWP, why isn't it possible for me to do the browse and press print, and have the labels printed in the same way? The users who have requested this function will not have access to FileMaker Pro; this is why we have purchased the server version as well. Is there anyway of setting up IWP to allow me to do this?

Hi, I'm having a problem when viewing and printing my label layout through instant web publishing. If I go directly through Filemaker and go into preview for the label layout, it presents and then prints them the way that it should. But when I access it through the instant web publishing, it only shows me one label at a time, and when I view it as a list, it just makes a normal list, not one that conforms to the label layout (which I see in Filemaker) Also when I print it, it doesn't print according to the margins specified in the layout. Can anyone help me with this please? YK