Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. phildude

    View not sorting when queried

    That would be the easy way, but our app passes in only a where clause for this particular feature, so it would require quite an effort to modify . I've never seen a situation where SQL Server would return the data unsorted, so I'm trying to figure out what is going on with the Server side...
  2. phildude

    View not sorting when queried

    Hello, I have a client that has a view with a top x and an order by. When you do a simple query against the view, it returns sorted, as soon as you add a where clause to your query, the sort goes away - any thoughts?
  3. phildude

    Query conundrum

    Hi, I have tables A and B. A has data like an ID, and some other fields, B has the same ID, and other fields. I'm trying to produce a view that combines the two horizontally to make it easier for reporting for some of my users. In essence, A has: 1 2 3 B has 1,10 1,20 1,30 2,5 2,6 2,7 I'd...
  4. phildude

    Intriguing log file messages

    Thanks, I was heading in that direction! Phil
  5. phildude

    Intriguing log file messages

    Hi, any thoughts on why our transaction log file on our server (sql 7) would show opening file x, starting up database x, then seconds later closing file x, then starting it all up again (and again and again)? Perhaps this is normal when we do a commit from ADO, just seemed a bit odd.
  6. phildude

    Can you lose data if you run out of disk space?

    Hi, trying to research this and haven't found much info yet. A client called to say that they had lost a bunch of transactions that had been entered into a sql 2000 db via our custom vb/ado app. Coincidentally, the same day that the transactions disappeared, the server ran out of disk space...
  7. phildude

    Drop View with a parameter

    Thanks!
  8. phildude

    Drop View with a parameter

    I thought this would be a piece of cake, but it hasn't gone as smoothly as I expected. I need to drop a bunch of views, but I don't want to hardcode the drop command since the names change. When I try to do a drop view @viewname it gives me a syntax error - am I missing something? Phil
  9. phildude

    dll usage

    If I have an app that requires a different version of mfc42.dll than is in my windows system32 directory, can I copy it into my app directory and it will be used when the app launches? Additionally, does it need to be registered, or will it's presence cause it to be loaded when the app loads...
  10. phildude

    16 bit app getting killed with metaframe 1.8

    We've got a custom app that a client has been using for years with success (16 bit vb app), they applied a service pack update to Citrix (2 I believe) a couple of months ago, and now, when our app launches, it dies most times before it even makes it to the login screen. Other times the login...
  11. phildude

    Update view without rights to the base table?

    Hello, we want to have a view that users utilize to see data. There is a lot of logic that goes into the view so that they can only see their particular records. Is there any way to allow them to update data within the view, but not give them any access to the base table that the view is made...
  12. phildude

    VB App, SQL Server, Images and MS Access

    Hi, we have a VB app that uses ado to put an image into a SQL Server table. If I go into Access and run a report, I can't pull up the image. If I link to the table from Access, and paste in an image I can then run reports on it, but my VB app can't understand the image - any thoughts? Thanks, PH

Part and Inventory Search

Back
Top