This is a question that is related to the issue at: http://www.experts-exchange.com/Databases/FileMaker/Q_21859046.html
I'm updating a FM8 table from an SQL table with new records and modified records. Below are the 3 ways that i've decided to update it...
• I am performing an SQL query that needs to update records that are greater than the greatest (by date) modified record in the current db
• It also needs to add any records that are greater than the greatest 'added' date.
• It needs to only get the records that have a 'completed' value of '1'
Curently my query reads:
" SELECT * FROM \"orders\" WHERE \"orders\".\"Date_modified
\" > " & Orders_MEMBERS::fDate_Modi
& " and \"orders\".\"Completed\" = 1"
I've tried adding an 'or' query before the 'and' operation (even tried removing the 'and' operation), but i just can seem to get it to work. What is the best way to do this?