Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. CryoGen

    LOAD INFILE is incomplete

    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...
  2. CryoGen

    Oracle date query

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

    Oracle date query

    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?
  4. CryoGen

    Conditional query

    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...
  5. CryoGen

    Update problem

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

    Update problem

    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...
  7. CryoGen

    Day & Get(Current Date) calc

    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"...
  8. CryoGen

    Day & Get(Current Date) calc

    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...
  9. CryoGen

    Error Capture doesn't suppress dialog

    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.
  10. CryoGen

    Error Capture doesn't suppress dialog

    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...
  11. CryoGen

    XML Parsing error

    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"?
  12. CryoGen

    XML Parsing error

    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...
  13. CryoGen

    Date Validation where variable represents the date

    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 (...
  14. CryoGen

    Filemaker Pro 6 running slow

    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?
  15. CryoGen

    Using variables to find records

    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...
  16. CryoGen

    Date Validation where variable represents the date

    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...
  17. CryoGen

    Newbie

    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...
  18. CryoGen

    Calculated Field for Multiple File Nos.

    Are you using FMP 7.x or higher?
  19. CryoGen

    Calculation Field Help Needed

    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 (...
  20. CryoGen

    Calculation Field Help Needed

    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 ) <...

Part and Inventory Search

Back
Top