473,549 Members | 2,670 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Help needed in using FSO's, TextStreams, etc. --- Code Review and Advice requested

Hello All,

I'd like your comments on the code below. The sub does exactly what I want it to do but I don't feel that it is solid as all. It seems like I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in vb.net 2005.

This test sub just reads an input text file, writing out records to another text file, eliminating records that have a '99' in them (it is similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream rename?

I want to do this the vb.net way as much as possible, but it seems that while searching the net that I wind up with a mix of VB6, Net2003 and Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()
'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records that have a '99'
' in them. An output file is created (without the 99's), the original file is
' deleted and the new file is renamed to the original.
'************** *************** *************** *************** *************** ***
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File Scripting object
Dim FSO1 ' A File Scripting object
Dim TSI ' Input Text Stream
Dim TSO ' Output Text Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub
Nov 22 '06 #1
53 4627


"Hexman" <He****@binary. comwrote in message
news:f8******** *************** *********@4ax.c om...
Hello All,

I'd like your comments on the code below. The sub does exactly what I
want it to do but I don't feel that it is solid as all. It seems like I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in
vb.net 2005.

This test sub just reads an input text file, writing out records to
another text file, eliminating records that have a '99' in them (it is
similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I
missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream
rename?

I want to do this the vb.net way as much as possible, but it seems that
while searching the net that I wind up with a mix of VB6, Net2003 and
Net2005
code.
. . ..
You were absolutely right to be dissatisfied with this code. It's very
old-looking and very sloppy. VB.NET can do much better. First is to turn
Option Explicit and Option Strict on. First thing you will find is that you
had both TS0 (with zero) and TSO (with capital 'o'). Option Explicit Off
allows this, which is why it's an abomination. Next is to get rid of your
forward declarations and the COM interop and use .NET framework classes for
IO.

Resulting in something like:

Option Explicit On
Option Strict On

Imports System.IO

Module Module1
Private Sub RemoveRecs()
'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records that have
a '99'
' in them. An output file is created (without the 99's), the original
file is
' deleted and the new file is renamed to the original.
'************** *************** *************** *************** *************** ***

Dim AnyChanges As Boolean = False
Dim InFileName As String = "C:\jjj.txt "
Dim OutFileName As String = "c:\kkk.txt "

Using TSI As New StreamReader(In FileName)
Using TS0 As New StreamWriter(Ou tFileName)
Do While Not TSI.EndOfStream
Dim strRecord As String = TSI.ReadLine()

If strRecord.Conta ins("99") Then
AnyChanges = True
Else
TS0.WriteLine(s trRecord)
End If
Loop
TS0.Close()
End Using
TSI.Close()
End Using

If AnyChanges Then
File.Delete(InF ileName)
File.Move(OutFi leName, InFileName)
Else
File.Delete(Out FileName)
End If

End Sub
End Module

David

Nov 22 '06 #2
Hexman wrote:
FSO = Nothing 'Clean up - destroy objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
And just for reference, in .Net setting a COM object to Nothing does
not clean it up. For COM objects you must call
Marshal.Release ComObject(FSO).

Nov 22 '06 #3
Thank you both, David & Chris,

Your code is well written and concise! Great example!

I'll certainly take your advice on options Explicit & Strict and the forward declarations. As for the COM interop, I'll have to see what that really
is (I don't have a deep background in VB). As for .Net Framework (2005), it seems like all the books I've browsed at Borders mix VB6, .Net 2003, and
..Net 2005.

If you know of any .Net 2005 specific books/websites/etc. that will show me only the .Net 2005 way, please let me know. The one other thing is that I
don't read technical books cover to cover. I usually find a chapter that applies to the task at hand and try to adapt their solutions to my code.
(Maybe I better start reading the "Architectu re" parts first!!!)

Thanks again,

Hexman
On Wed, 22 Nov 2006 06:45:31 -0600, "David Browne" <davidbaxterbro wne no potted me**@hotmail.co mwrote:
>

"Hexman" <He****@binary. comwrote in message
news:f8******* *************** **********@4ax. com...
>Hello All,

I'd like your comments on the code below. The sub does exactly what I
want it to do but I don't feel that it is solid as all. It seems like I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in
vb.net 2005.

This test sub just reads an input text file, writing out records to
another text file, eliminating records that have a '99' in them (it is
similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I
missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream
rename?

I want to do this the vb.net way as much as possible, but it seems that
while searching the net that I wind up with a mix of VB6, Net2003 and
Net2005
code.
. . ..

You were absolutely right to be dissatisfied with this code. It's very
old-looking and very sloppy. VB.NET can do much better. First is to turn
Option Explicit and Option Strict on. First thing you will find is that you
had both TS0 (with zero) and TSO (with capital 'o'). Option Explicit Off
allows this, which is why it's an abomination. Next is to get rid of your
forward declarations and the COM interop and use .NET framework classes for
IO.

Resulting in something like:

Option Explicit On
Option Strict On

Imports System.IO

Module Module1
Private Sub RemoveRecs()
'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records that have
a '99'
' in them. An output file is created (without the 99's), the original
file is
' deleted and the new file is renamed to the original.
'************** *************** *************** *************** *************** ***

Dim AnyChanges As Boolean = False
Dim InFileName As String = "C:\jjj.txt "
Dim OutFileName As String = "c:\kkk.txt "

Using TSI As New StreamReader(In FileName)
Using TS0 As New StreamWriter(Ou tFileName)
Do While Not TSI.EndOfStream
Dim strRecord As String = TSI.ReadLine()

If strRecord.Conta ins("99") Then
AnyChanges = True
Else
TS0.WriteLine(s trRecord)
End If
Loop
TS0.Close()
End Using
TSI.Close()
End Using

If AnyChanges Then
File.Delete(InF ileName)
File.Move(OutFi leName, InFileName)
Else
File.Delete(Out FileName)
End If

End Sub
End Module

David

Nov 22 '06 #4
how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005

-Aaron
Hexman wrote:
Hello All,

I'd like your comments on the code below. The sub does exactly what I want it to do but I don't feel that it is solid as all. It seems like I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in vb.net 2005.

This test sub just reads an input text file, writing out records to another text file, eliminating records that have a '99' in them (it is similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream rename?

I want to do this the vb.net way as much as possible, but it seems that while searching the net that I wind up with a mix of VB6, Net2003 and Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()
'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records that have a '99'
' in them. An output file is created (without the 99's), the original file is
' deleted and the new file is renamed to the original.
'************** *************** *************** *************** *************** ***
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File Scripting object
Dim FSO1 ' A File Scripting object
Dim TSI ' Input Text Stream
Dim TSO ' Output Text Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub
Nov 22 '06 #5
blah blah blah blah blah. It's the broken record again.

Robin S.
-----------------------------------
<aa*********@gm ail.comwrote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...
how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005

-Aaron
Hexman wrote:
>Hello All,

I'd like your comments on the code below. The sub does exactly what I
want it to do but I don't feel that it is solid as all. It seems like
I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in
vb.net 2005.

This test sub just reads an input text file, writing out records to
another text file, eliminating records that have a '99' in them (it is
similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I
missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream
rename?

I want to do this the vb.net way as much as possible, but it seems that
while searching the net that I wind up with a mix of VB6, Net2003 and
Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()

'************* *************** *************** *************** *************** ****
' This routine reads the .pgh file and eliminates any records
that have a '99'
' in them. An output file is created (without the 99's), the
original file is
' deleted and the new file is renamed to the original.

'************* *************** *************** *************** *************** ****
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File
Scripting object
Dim FSO1 ' A File
Scripting object
Dim TSI ' Input Text
Stream
Dim TSO ' Output Text
Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy
objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub

Nov 22 '06 #6
you're the broken record.

a _GIRL_ trying to be a programmer?

no wonder you have short-mans complex lol

Larry Linson Jr
RobinS wrote:
blah blah blah blah blah. It's the broken record again.

Robin S.
-----------------------------------
<aa*********@gm ail.comwrote in message
news:11******** *************@b 28g2000cwb.goog legroups.com...
how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005

-Aaron
Hexman wrote:
Hello All,

I'd like your comments on the code below. The sub does exactly what I
want it to do but I don't feel that it is solid as all. It seems like
I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in
vb.net 2005.

This test sub just reads an input text file, writing out records to
another text file, eliminating records that have a '99' in them (it is
similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I
missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream
rename?

I want to do this the vb.net way as much as possible, but it seems that
while searching the net that I wind up with a mix of VB6, Net2003 and
Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()

'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records
that have a '99'
' in them. An output file is created (without the 99's), the
original file is
' deleted and the new file is renamed to the original.

'************** *************** *************** *************** *************** ***
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File
Scripting object
Dim FSO1 ' A File
Scripting object
Dim TSI ' Input Text
Stream
Dim TSO ' Output Text
Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy
objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub
Nov 22 '06 #7
Interesting, again a judgment without even knowing me.

Robin S.
-------------------------------
"Larry Linson" <la***********@ hotmail.comwrot e in message
news:11******** *************@j 44g2000cwa.goog legroups.com...
you're the broken record.

a _GIRL_ trying to be a programmer?

no wonder you have short-mans complex lol

Larry Linson Jr
RobinS wrote:
>blah blah blah blah blah. It's the broken record again.

Robin S.
-----------------------------------
<aa*********@g mail.comwrote in message
news:11******* **************@ b28g2000cwb.goo glegroups.com.. .
how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005

-Aaron
Hexman wrote:
Hello All,

I'd like your comments on the code below. The sub does exactly what I
want it to do but I don't feel that it is solid as all. It seems like
I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing
in
vb.net 2005.

This test sub just reads an input text file, writing out records to
another text file, eliminating records that have a '99' in them (it is
similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in -
am I
missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream
rename?

I want to do this the vb.net way as much as possible, but it seems
that
while searching the net that I wind up with a mix of VB6, Net2003 and
Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()

'************* *************** *************** *************** *************** ****
' This routine reads the .pgh file and eliminates any records
that have a '99'
' in them. An output file is created (without the 99's), the
original file is
' deleted and the new file is renamed to the original.

'************* *************** *************** *************** *************** ****
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File
Scripting object
Dim FSO1 ' A File
Scripting object
Dim TSI ' Input Text
Stream
Dim TSO ' Output Text
Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy
objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub

Nov 22 '06 #8
Yes I can confirm this, they are dropping vb. It will not be in the
next VS.

The Grand Master
aa*********@gma il.com wrote:xt
how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005

-Aaron
Hexman wrote:
Hello All,

I'd like your comments on the code below. The sub does exactly what I want it to do but I don't feel that it is solid as all. It seems like I'm
using some VB6 code, .Net2003 code, and .Net2005 code. I'm developing in vb.net 2005.

This test sub just reads an input text file, writing out records to another text file, eliminating records that have a '99' in them (it is similar to
a CSV file).

Some of my concerns are:

1, 'writeline' does not convert to upper/lower case when keyed in - am I missing a reference?
2. Am I unnecessarily setting too many objects to '= Nothing'?
3. The 'Rename' statement seems like VB6 - isn't there a textstream rename?

I want to do this the vb.net way as much as possible, but it seems that while searching the net that I wind up with a mix of VB6, Net2003 and Net2005
code.

I appreciate your help,

Hexman
Private Sub RemoveRecs()
'************** *************** *************** *************** *************** ***
' This routine reads the .pgh file and eliminates any records that have a '99'
' in them. An output file is created (without the 99's), the original file is
' deleted and the new file is renamed to the original.
'************** *************** *************** *************** *************** ***
Const ForReading = 1
Const ForWriting = 2
Dim FSO ' A File Scripting object
Dim FSO1 ' A File Scripting object
Dim TSI ' Input Text Stream
Dim TSO ' Output Text Stream
Dim strRecord As String
Dim InFileName As String
Dim OutFileName As String
Dim AnyChanges As Boolean

AnyChanges = False
InFileName = "C:\jjj.txt "
OutFileName = "c:\kkk.txt "
FSO = CreateObject("S cripting.FileSy stemObject")
FSO1 = CreateObject("S cripting.FileSy stemObject")
TSI = FSO.OpenTextFil e(InFileName, ForReading, True)
TSO = FSO1.opentextfi le(OutFileName, ForWriting, True)
Do While TSI.AtEndOfStre am <True
strRecord = TSI.ReadLine
If InStr(1, strRecord, "99") = 0 Then
TSO.writeline(s trRecord)
Else
AnyChanges = True
End If
Loop
TSI.Close()
TSO.close()
If AnyChanges Then
TSI = FSO.GetFile(InF ileName)
TSI.Delete()
Rename(OutFileN ame, InFileName)
Else
TSO = FSO.GetFile(Out FileName)
TSO.Delete()
End If
FSO = Nothing 'Clean up - destroy objects
FSO1 = Nothing
TSI = Nothing
TSO = Nothing
End Sub
Nov 23 '06 #9
So when the next version of Visual Studio comes out and includes Visual Basic--and
it will, since I've already tried out an early version of it--will you promise
to leave these forums with the shame of a false prophet and never post again?
One can only hope.

Yes I can confirm this, they are dropping vb. It will not be in the
next VS.

The Grand Master

aa*********@gma il.com wrote:xt
>how DARE you use Com in .NET?

I mean seriously what the heck is wrong with you?

you should just rewrite everything in PHP; Microsoft has given up on
VB.net; they should be making an announcement soon
I should know; I have a friend that works there they told me that
they're killing VB.net 2002, 2003 AND 2005
-Aaron

Nov 23 '06 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
5209
by: Arvie | last post by:
I need some advice guys.. I am proposing that we get someone to do a complete audit/review of our Java application codebase, about 1000 JSPs/Servlets and 100 EJBs. If I get firms to submit proposals, what should I be asking /looking out for? I realise that running the applications through a migration tool will help but I am looking for a more...
1
3588
by: wtnt | last post by:
Hello. I've searched all over and haven't seen another thread with this problem. Please bear with me as I try to explain. thanks. :) I have some programs that need to be cross-platform compatible (unix and windowsXP). The first program parses a text file and records where snippets are in terms of where it begins (char offset from begin of...
9
1698
by: Adam Monsen | last post by:
I kindly request a code review. If this is not an appropriate place for my request, where might be? Specific questions are in the QUESTIONS section of the code. ========================================================================== #include <stdio.h> #include <stdlib.h> #include <string.h>
1
1207
by: Tony Ciconte | last post by:
I have a table of customers who may have purchased numerous types of products. Finding out who purchased what is easy. However, what I need to determine is which customer has purchased ONLY one or two particular products and NOTHING else. There is a customers table where each customer has a unique ID, a product table where each product has...
8
1223
by: pmm | last post by:
hi all , I am working on a router which is Coded in ansi C ,it uses number of semaphores,threads I want to know that how can we know what threads are currently alive in a program being executed ,I do not have the support of <bold> GDB on my target board ,not even gdbserver,</bold> my way is very crude by placing print stmts in between the...
1
3681
by: Peter Williams | last post by:
Hello All, I'm a newbie to this ng. I'm posting here because I have a question about debugging some javascript on some pages of my website. Please don't call me a "troll" -- because I'm not one. :-))) The next page is called "basic_snake" and creates a message which follows the cursor. Up until today, I used this type of message attached...
4
5496
by: Dave Harry | last post by:
I found the RS232 class from MS's 101 VB samples. Writing to the port works fine. (I've got hyperterminal on the other comm port and a crossover cable between COM1 and COM2) The port is opened with: Public switchcom As New Rs232 switchcom.Open(2, 57600, 8, Rs232.DataParity.Parity_None, Rs232.DataStopBit.StopBit_1, 512)
7
2056
by: Emma Burrows | last post by:
Hello all, I've been writing C# applications and web sites for some time, but I'm now planning to share my latest code with the world at www.codeproject.com. The code works fine, but I'd like someone with a bit more experience and some spare time to take a look at how it's organised. Being self-taught, I don't have much experience of coding...
1
5982
by: sumanthsclsdc | last post by:
hello friends, i am using the os.path.walk to search to filter the files with the given word, this function i m using in many modules. i just want to place this function in some class and call it whenever required by passing the necessary word. for e.g i want to filter files with "Spec" which is specification documents and store in...
0
7521
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7451
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7720
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7959
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6044
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
3501
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3483
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1061
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
764
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.