Results 1 to 3 of 3

Thread: Query

  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Query

    I got this access database thats been changed to SQL. The person who made the database created a make-table which is suppose to be a temporary table which sends data to a html webpage. I dont understand why they are making all these temporary tables, but their reason for this is becasue they dont want the updates which would come from the Originating table. Does that make sense. Now I would think this would be where the "criteria" would come in, ya know with some wild cards possibly. Trying to understand someone elses logic...Then I was thinking about a possible Holding Table
    Last edited by desireemm; 08-25-04 at 19:31.

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    There are a bunch of possibilities, but my guess would be that they were building the data "on the fly" using Access Queries, so they didn't have a complete picture until they finished. If that were the case, it would make sense to create a sort of a "staging area" where you could build what you wanted to present one step at a time, then copy it out for the final presentation.

    -PatP

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Pat

    Hi Pat how are ya

    Ok from what I am seeing here it looks like they have vb coding that creates this temporary table which constantly overwrites itself...and this information goes onto a webpage..The tech says that ADP files dont support Html exports. My thought was why not create an xml webpage through the enterprise manager in sql??

Posting Permissions

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