Search results for query: *

Hello all, I have an automated process that usually works, but occasionally it doesn't. I'm using the query below to load data hourly into a MySQL table from a tab-delimited file. Most of the time it works fine, but every once in a while the complete file does not load. When that happens I go...

You are absolutely right. Thanks Dagon, and my apologies for the delay.

Hi guys, this is my first time in this group, so be gentle. I don't work with Oracle everyday, so I could use an assist here. I need to write a query that will select all fields in a specific view, but only look backwards four days. How might I do that?

I have a query that does a simple LEFT JOIN to determine whether there's a match in a second table. My problem is that the comparing column on the left side might be different depending on the data in another column. Here's the skinny: the data are being loaded from a file list on our server...

Disregard. The update script works. I had to reset the my.ini file to turn off strict mode and it updated just fine.

Hello all, I'm having a problem with an update using this query: DROP TABLE IF EXISTS test_table; CREATE TABLE test_table ( pk_newline_id INT(20) NOT NULL AUTO_INCREMENT, PRIMARY KEY (pk_newline_id), level_01 VARCHAR(255) default '0', level_02 VARCHAR(255) default '0', level_03...

Thanks Striker. I cross-posted this message on the FMP Technet site and got a great tip from one of the regulars there, Steve Harley. This solves it for me: Let (d = Day (Get (CurrentDate)); d & Case ( (d = 1) or (d = 21) or (d = 31); "st"; (d = 2) or (d = 22); "nd"...

Hi group, I'm trying to put together a calculation that examines the current day and then appends the appropriate "st", "nd" or "rd" for some legalese stuff we're doing (e.g., "This 30th day of April 2007). Problem is, it doesn't seem to evaluate the entire string and I can't quite figure out...

Thanks TS, I think we may have found one other dialog ... I'm going to have to break down and ask FileMaker. But I'll check the KB first. I'll let you know what I find out.

We're using Filemaker 8, and we're working with a solution that draws company data for drop-down lists that our users will use to complete a form on their Macs. The data are drawn from 1 of 2 possible FMP files (the file on their Mac, or a file hosted on a FMP8 Server). Users of this...

No, it might have more to do with ignorance. The stylesheet is calling "k4_file_names" ... which is the name of the database, but not the XML file. Might I be better off by naming the XML file "k4_file_names.xml"?

OK, I'm fairly new to XML and FileMaker. I keep getting an error: "XML Parsing Error: The main document cannot be empty". I'm a little fuzzy on the syntax. The import I'm trying to accomplish has three parts: the FMP database, an XML output file from a third-party program that churns out...

It depends on where you store your last issue date. Assuming that last issue date value in the same row in a different field, you could write a calculation field that resolves that as well. Create a calc field with a text data type, then use an IF statement to do the comparison: If (...

When you say retrieving files, what exactly do you mean? usually when a database works, but operates slowly it has more to do with what's in it than other external factors (usually, but not always). What is it that your database does?

Also remember that when you set your "$$mystring" variable, that it's a global variable and will be available as long as the application is open (and will contain that same value, unless you reset it somewhere else). If you aren't going to need that variable value outside of the script you...

Well, first you'll have to decide what your universe of text-based dates are, and when your seasons start and end, but after that it's not that tough. Let's say, for example, you want to identify all your entries marked as "Summer 2007" with an ending date of August 31, 2007. First, make...

They'll likely be upgrading to FMP8.5, or if they wait until the end of the year perhaps FMP9. Either way TStriker is right, the differences are great. Depending on the size of your solution upgrading could be quite a chore. If you become the stuckee for the conversion, I recommend FMRobot...

Are you using FMP 7.x or higher?

Apparently I can't get out of my own way tonight ... one more time from the top ... Case ( Sum ( numb_field1;numb_field2;numb_field3 ) = field_b; Sum ( numb_field1;numb_field2;numb_field3 ); Sum ( numb_field1;numb_field2;numb_field3 ) > field_b; TextColor ( Sum (...

Sorry, didn't read your post completely. Try this instead ... Call this calculation field "c_field_a" and Case ( Sum ( numb_field1;numb_field2;numb_field3 ) ? field_b; TextColor ( Sum ( numb_field1;numb_field2;numb_field3 ); RGB ( 0; 255; 0) ); Sum ( numb_field1;numb_field2;numb_field3 ) <...