Search results for query: *

r937, your example worked great! I changed the INNER JOIN to LEFT OUTER to keep records with no previous history. travisbrown, I tried your code and I keep getting The column prefix 'a' does not match with a table name or alias name used in the query. I also changed the AND to WHERE in the...

Primary Key is OrderID(autonumber,identity column) I am running tests against the Database now using your suggestions. Thanks again, I will post results.

Thanks for all the suggestions, I will try these later today and let you know how it turns out.

Thanks for the response r937, I guess I should have spelled out the whole problem. After I Identify the previous OrdDate for this customer, I need to pull some other information from the same row. Here is what I was doing. Select a.CustID, a.OrdNumber, a.CustOrdType...

I am trying to convert the following query from using a subquery in the SELECT statement to using JOINS instead. I have been working on this a while now without much success. Select a.CustID, a.CustOrdType, a.OrdDate, (SELECT TOP 1 b.OrdDate FROM OrderTable b WHERE b.CustID = a.CustID AND...

After reviewing the Indexes a little on each separate database, I was able to speed up performance on each one to acceptable levels. That will teach me to rely solely on the Index Tuning Wizard to optimize database. Thanks BugSlayer for your previous post.

The different databases are already on the same machine. I have merge replication set up to periodically dump data from the remote machines on the LAN to the local server. All the data access is done locally. Merge replication won't let me rename destination tables (I don't think), and I need...

Hello, I am running across performance problems with queries that reference tables in separate SQL databases. I am using SQL7 with five databases on a single machine. The databases merge with other external databases from time to time, and the table structures are identical in each database...

Hello, I am running across performance problems with queries that reference tables in separate SQL databases. I am using SQL7 with five databases on a single machine. The databases merge with other external databases from time to time, and the table structures are identical in each database...

I am trying to implement the Find method against and ado data control using multiple criteria and it doesn't seem to work. Here is what the code looks like frmEditRuns.Adodc1.Recordset.Find ("RunNumber = " & varRun & " AND StationNumber = " & varLine) This code works fine...

Tek-tips and its members are by far the most useful resource I have found on the Web. Two thumbs up! You guys have saved me more time and frustration than I can quantify. Thanks for your generosity [2thumbsup]

I have created an application that references an Active X exe at different times. Over the development process, I have installed and uninstalled and moved the programs around quite a bit on the PC (win2k server). Now, when I reference the Active X exe, I get a "program not found...

I have an Active X executable running on Windows 2000. The executable is accessed from different programs on the PC. When I set the PC up, I was logged in as Administrator and everything worked fine. Now I am logging in with a different logon (with Administrator Privileges) and I keep getting...

I have an Active X executable running on Windows 2000. The executable is accessed from different programs on the PC. When I set the PC up, I was logged in as Administrator and everything worked fine. Now I am logging in with a different logon (with Administrator Privileges) and I keep getting...

Thanks for your help.

Does anyonw know the way to get an XP Pro Laptop to work on two networks without using a domain server and roaming profiles? I have a laptop that gets moved between two different offices. Can the network settings be pre-set somehow so that the user doesn't have to change network settings...

Thanks for the ideas. Changing the recordset directly seems to be the only surefire way to get good results.

Thanks TheBigDog I haven't had opportunity to implement yet, but your solution sounds like it might work for me. Thanks All

SetFocus method doesn't seem to work. The only time the value is changed in the recordset is when I actually type the new value in manually.

This may be a simple question, but I cannot find a straightforward solution. I am using text boxes in VB6 that are bound to an ADO Data Control. I cannot programatically change the value in the text box and have the bound element update the database without setting the focus to the text box...