Entries for VBJB

const ref in C# [const ref in C#]

VBJB — Fri, 15 Jun 2007 00:15:39 GMT

Can someone explain to me why you cannot pass an object/variable into a method as const ref in C#/.net or am I beating a dead horse?

What is the most efficient way to pass in large objects into a method and be reassured it will not be changed in the method? I do not want to pass by value.

I did some searching online and could not find and technical papers on why const ref is not a part of .net.

Thanks for your input.

in reply to const ref in C#

Stored Procedure [Stored Procedure]

VBJB — Wed, 20 Dec 2006 17:03:07 GMT

What is the best way to handle this?

I have a SP that needs to append data to a field that is type text. I wanted to do a query and place the value in a local variable in the SP and say Comment = @Comment + ' ' + @NewComment, but I cannot have a local variable in a SP that is type text.

How do I append data to a field that is type text in a Stored Procedure?

Thanks

in reply to Stored Procedure

Stored Procedure Help [Stored Procedure Help]

VBJB — Mon, 18 Dec 2006 23:39:03 GMT

How can I express this?

I have a query that is a LEFT OUTER JOIN and using GroupBy and it is returning:

Job   Date               Quantity
100   1/19/2006      75
100   10/28/2006    100

How do I get it to return only the line with the min. date?

Job   Date               Quantity
100   1/19/2006      75

SELECT     Job.Job, MIN(Delivery.Promised_Date) AS Promised_Date, Delivery.Promised_Quantity
FROM         Job LEFT OUTER JOIN
                      Delivery ON Job.Job = Delivery.Job
GROUP BY Job.Job, Delivery.Promised_Quantity

in reply to Stored Procedure Help

Triggers [Triggers]

VBJB — Tue, 21 Nov 2006 21:19:34 GMT

In SQL server 2000 how do you debug a trigger? I created a trigger that is not doing what it is supposed to. How do I debug it? Should I create a temp table that is update from my trigger in order to figure out the flow? I didn't find anything on the web.

in reply to Triggers

Triggers in SQL Server 2000 [Triggers in SQL Server 2000]

VBJB — Tue, 14 Nov 2006 19:59:20 GMT

If I have multiple triggers for an INSERT operation on a table. Is there a way to set the order of the triggers? Is there a way to say run this trigger before this one? I cannot combine the triggers.

in reply to Triggers in SQL Server 2000

Programming Editor Question [Programming Editor Question]

VBJB — Sat, 14 Oct 2006 22:49:05 GMT

Why can't I code in Notepad or Emacs and open it up in Visual Studio 2005 and have everything lined up as it was when I coded it?

When I am coding I do not use the tab key. I only use the spacebar. I indent three spaces at a time when code needs to be indented. It bugs me everything looks great in Notepad/Emacs, but when I open it up in Visual Studio everything is misaligned.

Is there anything I can do?

in reply to Programming Editor Question

Stored Procedure Help [Stored Procedure Help]

VBJB — Mon, 17 Apr 2006 15:47:48 GMT

I have two tables with a one-to-many relationship. The table that has the "many" relationship (Job_Operation) has a field (Inside_Oper) that is a bit type . The query:

SELECT     Job_Operation.Inside_Oper
FROM         Job LEFT OUTER JOIN
                      Job)_Operation ON Job.Job = Job_Operation.Job

will return

0
1
0
0

I want a query that will return a single value, 0 if all values are zero and a 1 if any of the values are a 1.

Examples:
1
0
0
returns 1

0
0
returns 0

0
1
returns 1

in reply to Stored Procedure Help

Stored Procedure Help [Stored Procedure Help]

VBJB — Mon, 27 Mar 2006 11:42:15 GMT

I need help with a SQL stored procedure.

I have two tables one called Job and the other called JobTracker_Job. I need a Select query that says SELECT * FROM Job but not where there is an entry in Job and JobTracker_Job that match WHERE status = 'Active'.

My only thought is some sort of JOIN that says select all from JOB where there is no matching rows in JobTracker_Job and Job. Does this make sense?

in reply to Stored Procedure Help

Wireless IRQ Problem [Wireless IRQ Problem]

VBJB — Fri, 03 Feb 2006 15:31:10 GMT

I have a Dell D800 laptop that is having an IRQ problem. My modem and my wireless nic are sharing the same IRQ (5). At home, I am still on dial-up and I have a wireless network for printing purposes. When I am online I have to disable the wireless nic or my browser will act weird (not responsive). If I had this issue with a desktop computer, I would simply put the modem in another PCI slot so the OS would assign it another IRQ number, but this is a laptop so I believe I do not have this option (never done it).

What can I do to fix my problem?

in reply to Wireless IRQ Problem

Class Design [Class Design]

VBJB — Wed, 14 Dec 2005 20:01:43 GMT

Alright can someone explain this to me? I am trying to create an assembly that is made up of many classes, but I am having trouble making it all work as a single object. This is what I want in my assembly.

I want to be able to say Public FMA3 As New Mill.FMA3 in my forms application (the assembly name is Mill). The main purpose of the FMA3 class is to set all its properties in the Sub New(). I have all this figured out so far.

Here is where I am struggling. I want to have properties such as FMA3.Alarm.AlarmNum, FMA3.Alarm.AlarmMsg, or FMA3.Alarm.hasAlarm (other properties FMA3.Current.Tool, FMA3.Current.MCode..). I am guessing FMA3.Alarm needs to be a namespace?! How do I physically set this up?

This is what I have so far, but I have not been able to get it to work. I have an assembly named Mill, inside that assembly I have a class named FMA3 and another class named Alarm (seperate files; FMA3.vb and Alarm.vb) and I am guessing the Namespace in class alarm would be Namespace FMA3. The local variables in Public Class Alarm would be labeled as Private Shared so the FMA3 class can set the ReadOnly properties inside the Alarm class, but none of this is working right. Can someone help me?

I also tried nested classes, but it was to hard to manage. I would like to break out each namespace in its own class.

in reply to Class Design

Windows Forms Application (VB.Net) [Windows Forms Application (VB.Net)]

VBJB — Fri, 09 Dec 2005 16:20:46 GMT

What would cause this and how do I fix this:

I have a simple form that has a timer on it. It creates an instance of a class that monitors a machine we have. It checks on the machine every minute. If it finds any problems with the machine it sends an email to notify people.

My problem is the email is not sent until I close down the form. I have a button on the form to stop the timer and disable it. I can stop the timer and the email is still not sent. However, when I close the form the email is sent. Is it something to do with threading or what?

in reply to Windows Forms Application (VB.Net)

System.Windows.Forms.Timer [System.Windows.Forms.Timer]

VBJB — Thu, 08 Dec 2005 21:18:59 GMT

I am using this timer to call a method every minute. My application is hardly taking any memory (7,000kb), but the CPU is at 100% as long as the timer is running.

Is there a more friendly CPU timer that I can use to call a method at given intervals?

in reply to System.Windows.Forms.Timer

Computer Science Question [Computer Science Question]

VBJB — Fri, 11 Nov 2005 13:57:46 GMT

I am a transfer student on track for a Computer Science Degree. I am about to start my four year college (Fall 2006). I went and visited the college I am applying for (UMBC). Once I got there and started having conversation with the heads of the Computer Science department, I found out they were Linux based (Red Hat). This worried me a little, since I have never laid eyes on a Linux machine. I went home and checked out other local colleges and they too where Linux based.

I have two questions for everybody.

1.) Would you be worried about this if this was your four year college?

2.) If you have a computer Science degree, what OS did your college use?

This is my thought, they are going to be teaching me the concepts of programming and it applies to any platform. What do you guys think?

in reply to Computer Science Question

SQL JOINS [SQL JOINS]

VBJB — Fri, 30 Sep 2005 16:51:15 GMT

What should I do in this scenario? I have a SQL JOIN where the JOIN could be Null. I need all cases where the JOIN is Null plus any case where the JOIN has a value meeting a criteria. When I do a JOIN it only gives me cases where a JOIN is not Null. Like I said, I want the cases where the JOIN is NULL too. Here is what I have so far:

SELECT     *, Job.Job
FROM         Job INNER JOIN
                      Job_Operation ON Job.Job = Job_Operation.Job LEFT OUTER JOIN
                      User_Values ON Job.User_Values = User_Values.User_Values
WHERE     (NOT (User_Values.Text1 LIKE 'y'))

The LEFT OUTER JOIN is the one giving problems. These are user values. A user might place values in this area and they might not. This is why some are Null JOINS and some are not.

in reply to SQL JOINS

NT Backup [NT Backup]

VBJB — Fri, 02 Sep 2005 11:13:50 GMT

SBS 2003 SP1

Recently all my ntBackups are failing (it fails right away). The exact message is: "Error returned while creating the volume shadow copy:800423f4". One solution is to have the recovery of all databases in SQL set to "simple". I tried that, but it didn't work. My SQL server backup scripts run fine, but not the ntbackups.

There is a lot of information on the web to tell me others are having the same problem and are frustrated as I am (

Now here is my question, is there a way through javascript I can load a url in the command line, but not have it look for the page. Right now I am using href and it looks for the page (which I would expect). Is there another way I can do this? My code is top-location-href = http://JobEntry/ ' + Job;

This is what has to happen. The person clicks a link on our intranet inside this application. Then the person will hit the "GO" link so the application will run the command. If it is given a href it bypasses the application's lookup of internal command. A person has to hit their "GO" button

Any suggestion?

Edit: If this does not make sense let me know I will try to clarify.

in reply to IE Snap-in

SQL Server Reporting Services [SQL Server Reporting Services]

VBJB — Fri, 01 Jul 2005 17:06:34 GMT

Does anyone know why SQL Sever does not come with its Reporting Services? I had to order it here (It only cost $5.30, shipping and tax). It doesn't make much sense to me.

Edit: Is it for tracking purposes?

in reply to SQL Server Reporting Services

IIS and Anonymous Access [IIS and Anonymous Access]

VBJB — Wed, 01 Jun 2005 18:51:34 GMT

I have tried everything I know and I still cannot get three machines to connect to my intranet site written in ASP.NET. Two machines are Win98 and the other is WinNT 4.0. All of my Win2000 and WinXP machines have no problem connecting. When the machines try to connect they do not generate any type of error in the error log. It just says website not available. I am hosting IIS 6.0 on SBS 2003 SP1. I am thinking it is something to do with anonymous user rights, but I tried all different setting and nothing works. What can I troubleshoot to see if it is IUSER rights or something else I am overlooking?

Thanks,

VBJB

in reply to IIS and Anonymous Access

Advice on a Media Player [Advice on a Media Player]

VBJB — Wed, 11 May 2005 16:27:27 GMT

There is so much great information out on the web, which I do not have time to view at work. Most of the things that I am interested in are in MP3 or WMA format. I do not have much time to listen/view these things at work, but I have a 30 minute drive home from work. So here is my question:

What is the best portable media player to view/listen to these on my way home.

- Should I buy a pocket PC and browse the web on my way home?
- Should I download them to a device before I leave work and listen to them on the way home (iPod)?
- What devices are out there that would accommodate this portability?

Can you give me pros and cons of the different devices?

Thanks,

VBJB

in reply to Advice on a Media Player

SQL Server Enterprise Manager Error [SQL Server Enterprise Manager Error]

VBJB — Fri, 29 Apr 2005 15:15:50 GMT

I am getting an error after upgrading to SP1 on my SBS 2003 (only thing that has changed).

Reproduce:
-Open up SQL Server Enterprise manager
-Navigate to the database of interest
-Right click on the node and go to properties to get database size

Once, I do this, the MMC disappears and this error is generated.

Faulting application mmc.exe, version 5.2.3790.1830, faulting module sqldmo.dll, version 2000.80.194.0, fault address 0x0007b7ab.

any thoughts?

in reply to SQL Server Enterprise Manager Error

Feature addition to C9?? [Feature addition to C9??]

VBJB — Tue, 26 Apr 2005 15:57:35 GMT

In the Coffehouse have the number of replies a hyperlink were you can click it and it would take you to that reply (the last reply). For those who watch threads as they come in.

VBJB

in reply to Feature addition to C9??

Business Object Question [Business Object Question]

VBJB — Tue, 22 Feb 2005 02:29:06 GMT

I am building a bindable business object. I need help deciding whether to inherit from a dataset or to implement the proper interfaces. Obviously, there is much less code if I inherit from a dataset. What are the Pros and Cons of doing it either way? Here are my own thoughts, correct me if I am wrong:
-------------------------------------------------------------------------

Pros of Inheritance:
   -Less code for me to write
   -Easier in the future to add functionality

Cons of Inheritance
   -Probably more overhead then I would ever need

-------------------------------------------------------------------------

Pros of Interfaces
   -Streamline code
   -very customizable

Cons of Interfaces
   -TIME

-------------------------------------------------------------------------

What do you think?

Thanks,

VBJB

in reply to Business Object Question

Server Time [Server Time]

VBJB — Tue, 15 Feb 2005 18:16:17 GMT

I guess the best way to get the time from a network sever in .net is to use NetRemoteTOD?

VBJB

in reply to Server Time

Font Question?? [Font Question??]

VBJB — Fri, 11 Feb 2005 16:36:56 GMT

Let's see how should I put this? I have been developing with VS.net 2003 and have not liked the default font for C#. I have been watching many videos showing the source code of upcoming languages/markup. When I watch these videos I like the font they are using, very bold elegant font. My question is, what font are they using?!? I want to change my font is 2003 to match what I have seen on the videos. Reasons being, in the videos C#’s "{" and "}" are very bold and easy to see, unlike the default font in VS 2003.

So if anyone can tell me what the "xaml" font is (for a lack of a better word) it would be appreciated.

VBJB

in reply to Font Question??