Peculiar Problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: Peculiar Problem

Hybrid View

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Gurus,

    Have a very strange problem here.

    We have a Forms 4.5 tool reading from an Oracle 8i database.
    This problem concerns one table.

    The tool has a query which simply fetches all the records in the table and shows them one by one for a search button.

    Till recently, every record in the table was fetched by the query. There are no joins to any other table at all in the query and we have a dummy where clause... where 1 = 1;

    But off late, only the records created after a certain date, about a week ago are being fetched into the tool.

    A simple SQL query retrieves all the records in the table, but this is not happening in the tool with the same query.

    I know this is very vague but has anyone faced such a problem before?

    Do you have anything at all to say about this?

    Thanks!






    Hemant

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    have you actually checked what query is being sent to the database?

  3. #3
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi,

    Its strange isnt it.

    The query is coded on the When Button Pressed Event of the Search Button.

    But it retrieves a fraction of the data in the result set.

    It has to be the same select query.
    Hemant

  4. #4
    Join Date
    May 2002
    Posts
    2,645
    Do you have a limit on how many records can be returned? Look for something like "parameter.maxrec=100" - maybe someone put a limit on how many records can be displayed. Since your problem recently appeared, that would be consistent with a limit being placed on what is returned. Doesn't mean that's the reason why, but is a good candidate for why it's happening now.

  5. #5
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    Hi Stecal.

    Baffling. No its not any parm.

    Actually we have records being created in our production and every record after a certain date appears.

    The records prior to that date just do not show up in the result set....
    Hemant

  6. #6
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    also check the following thing in forms end .
    in records or blocks check the maximum number of records . and there is where clause in forms just check if it has any date set .

    may this property may be overwritting what u write in when button pressed trigger .
    siva prakash
    DBA

  7. #7
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    There is neither a join nor a condition in the SELECT.

    Just a where 1=1;

    There is no date clause here.
    Hemant

  8. #8
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    u can test this thing .

    to check where the problem is lying ( database or frontend )

    just create a new form with wizard . without changing any property . and without setting 1=1 in where clause .
    then chech if it is fetching all records or not . if it is not retrieving all records and if it is fetching only after a certain date then we need to look un database end
    else database end is fien check in teh forms end by copying these properties in ur actual form .
    siva prakash
    DBA

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width