Hi there, Use the Select command. - txtTextBox.Select :)

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi all of you that think VB are such a horrible language to use for coding. I’ve notice some of you think a large project can’t be done in VB. Well, I’ve got news for you. I work for a company that develops Point of Sale software for the last 14 years, and we are currently working on a new version for the Point of Sale that has at least 2 million lines of source code in it! It is a full client-server application and can be used on a single PC and up to thousands of computers all with a breeze. Programming some parts of the application in C and other languages, VB still is the most organised and understandable code there is. Call a project with more than 2 million lines of source code small? The project contains about 121 dll’s written in VB6 and about 67 dll’s written in VB.Net. Currently we are converting all the VB6 dll’s to VB.Net dll’s. After all, it is not the language that makes an application what it is, but the programmer’s ability to develop good and reliable code, regardless of the language. ;)

A programmer's life is good... or is it?? Ek dink nie so nie!

Did you add a 'Return' after the error has been raised? Example: IF x BEGIN RAISERROR x RETURN END

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, I want to know if there is an executing speed difference between a View and a Table-Valued function. Tnanks! Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi Andy, I did see your modification on your first reply and applied it to my code, but it seems to me I still have a forward-only cursor type. When I'm trying to set the absolute position of the recordset the same error occurs 'Current Recordset does not support bookmarks....' I still don’t have a solution for my problem, but I'm thinking of trying a whole different way of implementing what I actually want to do. But if you've got a solution of why the recordset still have a forward-only cursor type, I’ll be glad to hear it from you. I appreciate all your help. Have a nice weekend, Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi Andy, Maybe I must rephrase my problem and question. I wànt to use a stored procedure to fetch the information, but the way I retrieve the recordsets does not allow me to scroll the records in the recordset. I need to be able to set the absolute position of the recordset and then fetch records from there. If I use a SQL command to retrieve the recordset like in my first attempt, I can set the absolute position of the recordset, but if I retrieve a recordset through a stored procedure the recordset does not allow me to set the absolute position on it. It raises an error 3251, ‘Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.’ If I can change the cursortype when using a stored procedute that supports bookmarks it will be great. I hope I have explained myself better this time. Thanks for your previous reply on this matter. Any other suggestions? :~ Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, In the past I used SQL commands to retrieve recordsets from my DB. Now I moved those SQL commands to stored procedures in my DB to retrieve the recordsets. The main issue I have is that I cannot set the absolute position etc on that recordset from my stored procedure. Here is what I did in the past: Dim rsRecord As Recordset Set rsRecord = New Recordset rsRecord.Open “SELECT * FROM Customers”, cnDatabase, adOpenKeyset If I open the recordset like the sample above I can get the rsRecordset.RecordCount, but if I use a stored procedure to fetch the same data into a recordset the rsRecordset.RecordCount property returns -1 Dim cmCommand As ADODB.Command Set cmCommand = New ADODB.Command Set cmCommand.ActiveConnection = cnDatabase cmCommand.CommandType = adCmdStoredProc cmCommand.CommandText = " [dbo].[FetchCustomers]" Set rsRecord = cmCommand.Execute rsRecordset.RecordCount = -1 How can I use a stored procedure to scroll through a recordset? :confused: Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Is there a way to determinate the cursor type of a recordset using the .Execute command of a ADODB.Command object? If you use a ADODB.Recordset object, you define the cursor type like this: myRecordset.Open mySQLCommand, myDatabase, adOpenKeyset I now use stored procedures in my DB and I still want to set the cursor type to OpenKeyset, if that is possible... Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Is there a way to determine if windows are shutting down in a VB application? Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Thanks for your reply, but unfortunately VB.NET 2003 and VB.NET 2005 differ from each another in that area. I did find a nice sample of code to validate an instance of an application at http://www.vbforums.com/showthread.php?t=398309 Have a nice day. Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, I know there must be a way from preventing an Application to be launched more than once, but how? Any help will be appreciated. I'm coding in VB.Net 2003. Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

I did remove it from the exceptions list, and that is my issue, why doesnt the Windows Firewall Unlock dialog box pop up again?

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, I've created an application that use ComPlus distribution (Client/Server Application). When I connect to a PC with windows firewall it ask me if I want to unlock the program accessing the network. Once I’ve unlock the program it creates a 'Com Surrogate' acception in the firewall settings. My problem is that if I delete that acception the Windows Security Alert dialog box does not pop up again when I try to connect to that PC, and the client PC obvious give me an 'Remote Server Machine does not exists' error. How can I get the firewall to ask me if I want to unlock the program again? Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Thanks for those who had a look at my problem, but I've solved it. Just one simple sample on a previous post on this forum gaved me the answer. DECLARE @QAZ AS DATETIME SET DATEFORMAT dmy;SET @QAZ = '14-02-2007' print @QAZ Result: Feb 14 2007 12:00AM

A programmer's life is good... or is it?? Ek dink nie so nie!

My dear friends, I’m battling with a major issue in T-SQL. I want to specify the format of a DateTime variable. In VB there is a command called ‘DateSerial’ that you can use to specify each value (Day, Month and Year) of the Date variable, but there is no such function in T-SQL. I live in South-Africa, and the date here is in the following order: Day, Month, Year. If I set a DateTime variable in this order - (SET @Date = ‘14/2/2007’) - the following error occurs: ‘The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.’ How can I solve this problem? Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Thanks for your reply Chris, I appreciate it. Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Is there a way to include a value from the affected record into a AFTER UPDATE trigger? And if there is a way, can you give me an exapmle, please? Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Thanks for your reply, I appreciate it. Regards, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, Can any one direct me to documentation containing all the internal commands of SQL Server, please. I've used commands like Format in my sql statements with an Access DB, but SQL Server does not support Format as a function or command. Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!

Hi there, If I use SQL Server Migration Assistant for Access to convert my Access database to SQL Server Database, it adds constraints to each string type data column in my SQL database. Why is that? I've checked the string values in my Access database, and they do allow Zero Lenth values. If I add that Access database to my SQL Server Migration Assistant for Access project, and I select a Table to see the design of it, the Allow Zero Lenth flag is false. I want those characterlistics to be the same as in the Access Database. Is there a way to do that? Thanks, Werries

A programmer's life is good... or is it?? Ek dink nie so nie!