Search results for query: *

I need to add a column of values to one table (TableA) in the right order. The new column on TableA is 1ColX and is empty. Another table (TableB) has the values for 1ColX in 2Colx, and both tables have a column called CustKey. Each record inserted into 1ColX should then have the same CustKey as...

Thanks but one problem: It ALWAYS returns data. It ALWAYS returns 1. Therefore it is always "true". So, what's the point? --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Hi all, I started working at a new company and have discovered the pervasive usage of "Select 1 from.." in their stored procedures. Why? It just returns 1. Here's one use: ============================================== if exists (select 1 from dbo.sysobjects a join sysindexes b ON a.id =...

Merry Christmas and Happy New Year! If I want a message to pop up during an install made with the PDW (I want a popup that says something like "Be sure to read the ReadMe file for further setup instructions, you doofus" that they can click OK to unload, is this possible? Thanks...

Hi folks, in some of mt VB apps it is necessary for the user to go into the control panel, ODBC settings, and then choose the default driver (Microsoft dBase driver) then type in the System DSN (Goldmine) prior to using the product. Although this isn't THAT big a deal, I'd rather have the...

Hi all, I got a new dev computer so I had to re-install Visual Studio (6) on it, then since I want to package an app for distribution, I went to the Add-in Manager to add the Package/Deploy wizard, and much to my display is isn't there! What am I missing or forgetting please?? Thanks --Bill...

Here I am answering my own thread again. But I got the problem wrong -- it isn't terminal server, but just that a DSN has to be created in the control panel on each machine. Can this be done with the PDW installer? Or maybe ZEMP's new thread is my answer. Or, how about, instead of the above...

I'm accessing a .dbf database over the network and using ADO to do so. The ADO application works fine. Now when I open the database using Terminal Server, then try to run the app, I get this error: 80004005 [ODBC driver manager] data source name not found and no defauld driver specified. I tried...

Good lord. I was trying to continue the thread about hardware ID's and somehow it appears as a new thread!! I don't know how that happened! It's an orphaned thread, for crying out loud. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Folks, This topic always generates lively responses, every time it comes up which is often. I believe the experts here, because they are experts. But I wonder this: there are machine-specific licensing apps that seem to pull some kind of number out of a machine when you install it, then you...

Ponerse, The link after your signature -- it took my to a REALITY page, if you get my drift.. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Why would the ErrrorHandler get ignored, and raise a 'Run-time error' instead? The code: ======================================== Private Sub cmdDDE_Click() On Error GoTo ErrorHandler 'other stuff here ErrorHandler: Select Case Err.Number Case 282 ' "Can't find dde conn&quot...

Very interesting. Thanks, Paul. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Um, well, gee, I guess as long as I didn't use those subs......!! --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Well thank you to both! I never knew! That would explain much wierd behavior and stuff I've observed in the past. It also means, oh damn, I've got to go through the code in all my apps I've written, find all the error handlers, and insert the 'exit subs'. Yow! --Bill One may not reach the dawn...

No I don't. Are you suggesting that I put an Exit Sub before the ErrorHandler code snippet above? I haven't seen that before.. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

With this code: ==================================== ErrorHandler: Select Case Err.Number Case 9 ' "subscript out of range" error. Exit Sub Case Else Resume Next End Select Resume ==================================== both the 'Resume next' and...

Thank you. I'll look. --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran

Hi all. I'm new to this ACT forum, so please 'scuse me if this is an "old" topic. Essentially, what I need to know is where I will find VB/Act api's. Put another way, I have developed some VB apps that interact with the GoldMine CRM as add-ons, (they communicate with Goldmine thru ADO...

Wow! --Bill One may not reach the dawn save by the path of the night --Kahlil Gibran