Search results

  1. M

    SQL-89 Date functions

    I got a solution (it doesn't work exactly the way I want, but we were able to use it as a work-around) if someone has a better way please post it, or a list of functions available with the sql-89 driver, it seems like some embedded sql functions work, some with the {fn } syntax, some without...
  2. M

    SQL-89 Date functions

    Can anyone help me with SQL-89 functions, I am looking for something that will return the current date (I know how to do this with SQL-92, but not SQL-89) also if there are any other available functions for SQL-89 any help with be great. What I am trying to do is filter a SQL statement on a...
  3. M

    SQL 92 (Merant 3.60 driver for Progress 9.1d) and index usage

    Can anyone help me with index usage issues I am have, using ODBC connection to Progress 9.1D. I'm quite new to progress, but have some SQL experience. Anyways, I can't seem to use an index with any operator other than "=" in the Where clause for example if an Index "myindex" exists on "myTable"...
  4. M

    ssis update table changes and adds only

    Hey jimbob, I've been dealing with the same scenario over the past few months, I'm relatively new to SSIS, and even newer to Progress, but I have found a process that work really well. Andy Leonard has done an excellent job of explaining it here...
Top