Recent content by shanthimarie79

  1. shanthimarie79

    Dynamic query with external tables

    Hi Stefan, Thanks so much...you've helped me 'above and beyond' :) Didn't expect the code written out like that - it's much appreciated. Warm regards, shanthi
  2. shanthimarie79

    Dynamic query with external tables

    Hi, I couldn't find any logic for what i wanted and this post seemed to be the closest till I hit my brick wall. I am using OE10.2A on a windows platform. We're upgrading schema and plan to implement new unique index. I need to write a code to input a CSV text file of tablesname (1st...
  3. shanthimarie79

    Errors while running index analysis

    Hey, Thanks for the reply. Noted that the search for conflicting records should have been done first fro question 1. The reply for question 2 worked liked a charm!! Thanks. Kind Regards, Shanthi
  4. shanthimarie79

    Errors while running index analysis

    Hi Taqvia, I am using OE10.2a running on the Windows platform I have 2 questions : We had recently modified some index in our database by flagging them as Unique. I need to now identify records in my database that breaks this unique rule. I want to isolate the list to a bunch of specific...
  5. shanthimarie79

    Calling a internal procedure of external procedure

    if at the specified path of the 'run persistent' statement , the .p is actually a .r - would running the procedure in persistent fail ?
  6. shanthimarie79

    Records not being returned

    hey ... i have the same problem..:o its not a string problem nor a format problem. It's the power of "PAUSE".:rolleyes: the pause allowed for the record to be shown. I dunno why but thats the solution. the "Hows" I can't quite comprehend myself :confused: and maybe it mite hv smthg to do wif...
Top