2 posts in this topic
It's me again....
I've temporarily gotten around my issues with "required value" fields in SQL data by adding a default value to all blank fields, however I have now found another error.
I have a table of customers (BP_Details) which is retrieved from SQL server view using a DSN.
I then have a local Filemaker table ("BPAddon") which I've linked to the BP_Detials table using a unique customer ID field.
I wish to populate the records in the addon table via the Cusomter layout to supplement the data from SQL.
As there are no records in the addon table I've selected "allow creation of records in this table via this relationship" on the add on table side.
I can browse records fine, however as soon as I add data in a field on the addon table I receive an ODBC error: "You cannot specify scroll locking on a cursor that contains a remote table".
Am I doing something wrong in the relationship?
Thanks for any help!
Script find returns error: 500 regardless of date format
By Eli Walker
I'm running a script that should find a set of records within a specific date range. The date range is contained within a variable '$DateRange' which is then entered from the 'Perform Find' script step. Regardless of how I have the date range formatted, the script returns error 500 after the find. I've entered the date both as '1/22/2012...2/26/2012' or '22/1/2012...26/2/2012' or '1-22-2012...2-26-2012' and nothing seems to work. I've run this find request with the value I see for $DateRange in the data viewer while the script is running manually and it works without issue. It just doesn't work during the script. I've run this sort of find before without any issues... the only thing that has changed is that I've upgraded to FM14 (from 13). Any ideas???
Installing 360's Plastic 2 plug-in for a client — one server, 8 clients on LAN only. They will be using VirutalMerchant's Converge platform for their gateway.
I was wondering if anyone can recommend a card reader for regular and EMV chip cards?
FMS14, FMP14 - all Mac OSX
All feedback very much appreciated!
Idiot guide on how to Use 360Works Email 2
Have been using Filemaker for about 3-4 months now and have been using it to generate emails which go through to my MS Outlook 2010 client. Of course these are just plain text - so am examining the best way of sending out HTML based emails.
I've downloaded the 360 Works Demo version but having not really used extensions/plug ins before - I really don't understand what I'm doing!
I've installed it according to the instructions - but that's as far as I can go.
I'm not sure how to call these functions, or anything else I need to set-up.
Any walk-throughs/help would be greatly appreciated.
Even though I have a 64 bit system, I couldn't get the Filemaker 14 (64 bit version) to work - So I'm using the 32 bit version, which works fine
FM Pro 14, Windows 8.1, 2 users