Recent content by AndySmith

  1. A

    repeat....End

    You need to change the DO WHILE TRUE to a second REPEAT loop. Progress applies an error event at the end of the file import, but without any explicit block behaviour will apply the event to the REPEAT block. Try this - DEF VAR data AS CHAR NO-UNDO. REPEAT: IF SEARCH('C:\DATA.TXT')...
  2. A

    need database access before add record

    Andi, Well, you *could* make a call to the server-side section of the SDO from inside addRecord in your viewer. This emulates what you would do in ADM1 I suppose. The problem is that the user could sit in the viewer for 10 minutes before hitting the "save" button, by which time another...
  3. A

    direct database access within ...TrasactionValidate

    Andi, The TransactionValidate procedures run on the server-side section of your SDO. So, to answer your question, yes you will have access to the database in a distributed environment. You will need to be careful when you choose which TransactionValidate procedure you use, depending on what...
  4. A

    AppBuilder error message

    Mike, You've probably sorted this out already, but you need to check how your appsrvtt.d file is configured. Use the Service Parameter Maintenance ProTool to change the configuration of your partition to "Local" when you're developing away from your network. Regards, Andy.
  5. A

    Lock Release

    Hi Paul! Using FIND CURRENT...NO-LOCK is not guaranteed to downgrade the lock. To be more specific, it will fail to do so if the transaction is still active at that point in time. The most likely cause of this is an earlier reference to the param-file buffer you're updating, probably in the...
  6. A

    Smart Object Validation

    Hello Greyham, This isn't the "usual" way of validating data entry in ADM2. Of course, it depends on what your validation is doing. The easiest way is to use the SDO to handle all validation using the <field>validate, rowObjectValidate, and begin / pre / post / endTransactionValidate...
See more
Top