Search results

  1. P

    Question LAN to WAN options

    Thanks for the clarification on the LIKE reference. So I don't need to be concerned about those SDO include file references that show up in the xref file as database REFERENCEs. I have also noticed that certain database references are not identified with the REFERENCE reference type. I suppose I...
  2. P

    Question LAN to WAN options

    It is ADM2 and yes there were some CAN-FIND functions in there. I have been getting more conscientious about the coding as time goes on but there is likely still more clean up required. Any ideas on how to efficiently find any stray database references? I have looked at the xref file output by...
  3. P

    Question LAN to WAN options

    Thanks for your responses. I am really hoping to avoid having to a lot of code rewrite initially in order to move things along but will need to keep in mind the best direction for the application so thanks for the suggestions. Some of the functional challenges I think we may encounter with...
  4. P

    Question LAN to WAN options

    Hi, I wonder if anyone has any insights into moving a SmartObject application currently running in client/server mode on a LAN to serving a more dispersed group across an intranet. This involves a small group of users with a low volume of transactions. All locations have 100 baseT connections...
  5. P

    replacement for NOT CAN-FIND in SDO

    Please enlighten me oh Lord of the Icons. Why would one create a SDO temp-table if not to make use of smart links?
  6. P

    replacement for NOT CAN-FIND in SDO

    Thanks. I thought it might involve temp-tables. I have not used them in the ADM before so it may take a little getting used to but no doubt an improvement on creating querries. I assume that I can use smartLinks to keep my sdo in sync with the temp-table.
  7. P

    replacement for NOT CAN-FIND in SDO

    How can I filter the records in one SDO based on values that are absent from another unlinked SDO? I have a many to many relationship between table A and table B with table C being the interfile to link the two tables. I have an input screen for table A with a button to launch a window to create...
  8. P

    Character Client window property settings

    Hi, Since migrating to WindowsXP we have been having difficulties ensuring that the default properties settings for the Character Client window is consistent for all users. It seems that the settings saved by the administor are not being applied to future user client sessions. I don't recall...
  9. P

    passing value from smartViewer to sdo

    Thanks Joey. You're right I don't need to pass anything to the SDO to accomplish what I need to do. I can insert my code into updateRecord in the viewer. Paul
  10. P

    passing value from smartViewer to sdo

    Hello, I need to be able to modifiy certain screen values in a viewer through a procedure. The procedure called is determined by the value of a radio-set within the viewer. I want the procedure to be called just prior to saving the record so assume it should be called from the submitRow...
  11. P

    concatenating array fileds

    I'm off to a good start, answering my own thread, but this seems to solve the space character issue but am still running up against the size limit. SELECT concat(PRO_ELEMENT(ArrayField,1,1) , ' ') + concat(PRO_ELEMENT(ArrayField,2,2) , ' ') + PRO_ELEMENT(ArrayField,3,3)...
  12. P

    concatenating array fileds

    Hi, I'm new to the list and to SQL-92 and hope someone can set me on the right path. I am trying to concatenate some character array fields from our old Progress database to make them accessible and readable through ODBC. Ultimately I will want to make a view for this but at the moment am...
Top