Search results for query: *

Hello everyone, I would like to know if you can do the following in Win2000. For each user, limit their time usuage to 15 min. A screen will pop up and ask to extend their time if they want to. The system will store the total time period this user has logged on for his session. Can I do...

Hello, I tried using KeyUp, KeyDown, and KeyPressed, but none will catch the key 'Tab' when I pressed the keyboard. Why event I should use to catch the user entered this key? Thanks.

How can I have a user defined type with a user defined type? The follow would generate a compiler error of "Forward Reference to user-defined type". Thanks in advance. Private Type InputDetail RecordCode As String * 1 ResultCode As String * 5 detaildata As DetailRecord...

Hello All, can anyone please tell me how to write to window NT's Event Log? A link to a site is good enough. Thank you.

Hello, I am getting a 'Invalid use of 'getdate' within a function.' error when I use this GETDATE() function in my user function. Is there a way to work around this? thanks in advance. Create Function tb_getCustID () Returns @getCustIDTb TABLE ( [ChangeType] [char] (1) , [BeforeID] [char]...

Hello, I have a local table variable @tableTmp in my stored procedures. How can I output the whole table variable back to the caller? thanks in advance.

Hello, I am having difficulties with table variables in SQL2000. I have a stored procedures that select * from @tableTmp at the end of the script. Now, suppose I pass this table variable back to vb's recordset. Unfortunately, it said the object or variable is close when I try to use it in VB...

Hello, I am having difficulties with table variables in SQL2000. I have a stored procedures that select * from @tableTmp at the end of the script. Now, suppose I pass this table variable back to vb's recordset. Unfortunately, it said the object or variable is close when I try to use it in VB...

Hello All, I just want to know what does the 'GO' command do in a stored procedure? I noticed there is a difference when I put it in or when I left it out. It will usually cause compiler error when i put it in. Can anyone please let me know? Thanks in advance.

Hello All, I am having problem accessing a column from the table variable. Can anyone please show me how? Thanks in advance. declare @TableVar1 table ([chrChangeType] [char] (1), [chrBeforeIDType] [char] (2)) Insert Into @TableVar1 (chrChangeType, chrBeforeIDType)...

I have been thinking and trying this SQL statement in SQL2000 for the whole day. So far, I am retrieving all the details in a deal. This is simple. The problem is each detail have 5 customers link to this deal. My problem is how can I display all the 5 customers information and 1 deal record...

Hello, I would like to ask if stored procedures can output result into text file format? If so, what command line do I use? Thanks in advance.

Hello All, I just got an assignment and it's a tough one. This assignment ask me to develop a solution to have download fix amount of data from different IP address around the world every month. I was wondering how can I do this. Should I write a DOS batch file and install in the client...

Hello All, I just got an assignment and it's a tough one. This assignment ask me to develop a solution to have download fix amount of data from different IP address around the world every month. I was wondering how can I do this. Should I write a DOS batch file and install in the client...

Hello, I need to select around 300 fields from and 303 fields table. Now, I don't want to type down all the 300 fields in my select statement. How can I omit the 3 fields I don't want with the SELECT statement? thanks in advance.