Search results

  1. J

    Create static temp-table from dynamic temp-table

    Hello again, I really appreciate the comments you guys have left. I always seem to find answers here. Tamhas, yes the ERP is expecting the static temp-table, but only in the sense of how it addresses it. The ERP uses this temp-table for its standard export functionality, which basically does...
  2. J

    Create static temp-table from dynamic temp-table

    Hello, Sorry for my lackluster explanation of what I was trying to accomplish... Yep KnutHandsome, that is exactly what I am trying to do. I want to reuse the schema from a dynamic temp-table that has a varying amount of fields (the number being based on the results of a subset of data...
  3. J

    Create static temp-table from dynamic temp-table

    Hello everyone, I'm hoping that you may be able to help me out. I am currently working with 9.1E and I am wondering if it is possible to create a static temp-table from an existing dynamic temp-table. Pretty much the opposite of the CREATE-LIKE method used when creating the dynamic temp-table...
  4. J

    SQL92 Error with Business Objects

    I know that this is an old thread, but I just ran into a similar issue. The permissions via Data Admin in Progress were set properly, but I had to also grant permissions through SQL via SQL explorer. The script is something similar to the following, where tablename and username are the table and...
  5. J

    Records not being returned

    As you suggested, I've gone through looking for anything with a length different than 6. No records were returned... I was really hoping that something would turn up on that one.
  6. J

    Records not being returned

    Ok, so maybe I should lean towards DB config issue?
  7. J

    Records not being returned

    Man, Lee, thanks for the quick responses! I really appreciate all your input! This whole thing is so weird...
  8. J

    Records not being returned

    Thank you guys for getting back to me on this issue! I have tried the suggestions that you posted hoping that you guys were pointing out something that I just completely forgot about or overlooked. :) I'm sorry that I posted such a simplistic statement. The reason that I did was because I...
  9. J

    Records not being returned

    Hello everyone, I have a strange issue that is occurring with random records inside some of my db's... (Currently we are running Progress 9.1D09.) My issue is that sometimes when I try to locate a record that I know exists, the record is not returned. But, if I use match and a wildcard instead...
Back
Top