Search results

  1. K

    DIAG [S1000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Table/view/synonynm "<table-name>" cannot be found. (15814) (-210083)

    I am trying to run crystal report and facing strange issue - Everything is same except variable is crystal report version - On Crystal report version report gets printed very well, but keeping everything same DSN and all when I try to run same report using crystal version 13, I am getting...
  2. K

    Question Changing paper orientation & Size using Crystal report

    Hello All, I am trying to generate PDF & PS file from Progress using Crystal Report (CrystalDecisions.CrystalReports.Engine.ReportDocument). Using below code PS file always shows default orientation and paper size. I tried many combinations of printerSettings, PageSettings even PrintOptions of...
  3. K

    Data Encryption

    Thanks a lot...!! Anything available in 9.1xx as you said limited options ... Anything we can try with 9.1x? I just have idea about code encryption with XCODE. But I want to secure DB data.
  4. K

    Data Encryption

    Hi all, do we have any feature or tool available in Progress 9.1x, which can encrypt/decrypt data (DB)?
  5. K

    Should we write internal proc? Just for code readability.

    Thanks Tom for the reply. Version using 11.3, but not using OOPs concepts, as its all existing code around 30 yrs old. Still all programs (97%) are based on top to down (procedure) programming appraoch.
  6. K

    Should we write internal proc? Just for code readability.

    Thanks everybody for the suggestions. What I understood is - We can break code into internal proc just for clean code and readability. Yes Transaction & Buffer will be scoped to the internal proc if we are defining buffers in Internal Proc. In my scenario - We already opened all required...
  7. K

    Should we write internal proc? Just for code readability.

    Hi All, Need your inputs on - Should we break our code into internal procedures even not going to be used twice anywhere. Is it good or not? Due to look nice & readability, should we break code into internal proc or good to add comments and Indentations?
  8. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    Sorry for the naming convention, but its a DB table. I just created for all these kind of testing stuffs. .... :(
  9. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    I won't say making tight transaction scope is the solution, actually here its not about solution if we need to updated 4 or 5 or as many as required table in one transaction we have to. And if we have to use 3 or 4 assign statements as per requirement we have to make use, but yes we can take...
  10. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    I tried with indexed field, and found that whereever indexed fields will be assigned (doesnt matter 2nd, 3rd or 4th statement), all values till that assign statement will be avaialble in buffer, after that it wont till than it is released explicitly or transaction got over. Strong scope is not...
  11. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    Thank you all. I just posted this to know the cause, why it is happening like this. Yes with proper requirement, transaction, record scope we can control. But I was surprised why happening like this.
  12. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    My Transaction scope is larger, it's just one table/buffer getting created. And its scattered in multiple assignement statements. I was sure that whatever after create statment must be avaialble, but it wasn't only first assignment statement's values avaialble, while rest after completion of...
  13. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    One field is indexed and one is not, but what I assume it is just sequence of statements. Will try with indexed field and come back with findings.
  14. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    Thanks Dude, My only concern is why 2 assignments statements are beahving differently, in scenariono 1 - first assignement changes are avaialble as soon as execution of statement regardless transaction & buffer scope, while not of second. Buffer scope and transaction scope is same for both...
  15. K

    Values getting updated (released) to DB, need help in understanding the given scenarios

    Scenario 1 - create table1. assign table1.field1 = 1 table1.field2 = 2. assign table1.field3 = 3 table1.field4 = 4. pause. Now if we try to access this record in other session with no-lock, it will be available but with values which are assigned in first assign statement. Values which...
  16. K

    ABL2DB

    Hi Tamhas, Thanks for this wonderful utility. I am working on a project whose first program was written in 1983. Now its a huge one around 30000 .Ps with many include files with a disk space of around 1GB. There is no documentation available and it was tough to find a business logic behind the...
  17. K

    Confused on Record Bleeding

    Yes, I did to see whether any _LOCK entry is there or not at message 2, but there is nothing. If we use UPDATE it is there with EXCL if we don't use any UPDATE outside DO block then no entry in _LOCK. If there is no entry in _LOCK at message 2, why it's even available in SHARE-LOCK which allows...
Top