473,735 Members | 11,066 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Select Count(*) problem

MP
vb6,ado,mdb,win 2k
i pass the sql string to the .Execute method on the open connection to
Table_Name(cons t) db table
fwiw
(the connection opened via class wrapper:)
msConnString = "Data Source=" & msDbFilename
moConn.Properti es("Persist Security Info") = False
moConn.Connecti onString = msConnString
moConn.CursorLo cation = adUseClient
moConn.Mode = adModeReadWrite ' or using default...same result
moConn.Open
can't seem to get my sql right
here's a few versions of the many ways i've tried with the resulting error
codes following each

' sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
' " WHERE fldType.Value = '" & sType & "' AND " & _
' " fldCondName.Val ue = '" & sCond & "' AND " & _
' " fldCondVar.Valu e = '" & sCondVar & "' AND " & _
' " fldCondLBR.Valu e = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)

sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
" WHERE fldTypeName.Val ue = '" & sType & "' AND " & _
" fldCondName.Val ue = '" & sCond & "' AND " & _
" fldCondVar.Valu e = '" & sCondVar & "' AND " & _
" fldCondLBR.Valu e = '2L' ORDER BY fldTypeName"
'ErrState: -2147217887 <You tried to execute a query that does not include
the specified expression 'fldTypeName' as part of an aggregate function.>
' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE fldTypeName.Val ue = '" & sType & "' AND " & _
' " fldCondName.Val ue = '" & sCond & "' AND " & _
' " fldCondVar.Valu e = '" & sCondVar & "' AND " & _
' " fldCondLBR.Valu e = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = '2L'"
'ErrState: -2147217900 (Invalid use of '.', '!', or '()'. in query
expression 'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '3' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = '2L''.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = '2L'"
'ErrState: -2147217900 (Invalid use of '.', '!', or '()'. in query
expression 'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '4' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = '2L''.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".fldTypeName.V alue = '" & sType & "'
AND " & _
' TABLE_NAME & ".fldCondName.V alue = '" & sCond & "' AND " & _
' TABLE_NAME & ".fldCondVar.Va lue = '" & sCondVar & "' AND " & _
' TABLE_NAME & ".fldCondLBR.Va lue = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)
' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = ''2L''"
'ErrState: -2147217900 (Syntax error (missing operator) in query expression
'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '4' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = ''2L'''.)

eliminate the where clause maybe that's the problem?
'Try execute sql <Select Count(*) As 'Total' From tblTypeCond>
'ErrState: ErrNum 3265 (Item cannot be found in the collection corresponding
to the requested name or ordinal.)

yikes...what's the problem???

i'm running out of ideas
any help?
Thanks
Mark
Oct 25 '06 #1
22 12485

MP wrote:
vb6,ado,mdb,win 2k
i pass the sql string to the .Execute method on the open connection to
Table_Name(cons t) db table
fwiw
(the connection opened via class wrapper:)
msConnString = "Data Source=" & msDbFilename
moConn.Properti es("Persist Security Info") = False
moConn.Connecti onString = msConnString
moConn.CursorLo cation = adUseClient
moConn.Mode = adModeReadWrite ' or using default...same result
moConn.Open
can't seem to get my sql right
here's a few versions of the many ways i've tried with the resulting error
codes following each

' sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
' " WHERE fldType.Value = '" & sType & "' AND " & _
' " fldCondName.Val ue = '" & sCond & "' AND " & _
' " fldCondVar.Valu e = '" & sCondVar & "' AND " & _
' " fldCondLBR.Valu e = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)

sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
" WHERE fldTypeName.Val ue = '" & sType & "' AND " & _
" fldCondName.Val ue = '" & sCond & "' AND " & _
" fldCondVar.Valu e = '" & sCondVar & "' AND " & _
" fldCondLBR.Valu e = '2L' ORDER BY fldTypeName"
'ErrState: -2147217887 <You tried to execute a query that does not include
the specified expression 'fldTypeName' as part of an aggregate function.>
' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE fldTypeName.Val ue = '" & sType & "' AND " & _
' " fldCondName.Val ue = '" & sCond & "' AND " & _
' " fldCondVar.Valu e = '" & sCondVar & "' AND " & _
' " fldCondLBR.Valu e = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = '2L'"
'ErrState: -2147217900 (Invalid use of '.', '!', or '()'. in query
expression 'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '3' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = '2L''.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = '2L'"
'ErrState: -2147217900 (Invalid use of '.', '!', or '()'. in query
expression 'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '4' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = '2L''.)

' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".fldTypeName.V alue = '" & sType & "'
AND " & _
' TABLE_NAME & ".fldCondName.V alue = '" & sCond & "' AND " & _
' TABLE_NAME & ".fldCondVar.Va lue = '" & sCondVar & "' AND " & _
' TABLE_NAME & ".fldCondLBR.Va lue = '2L'"
'ErrState: -2147217904 (No value given for one or more required parameters.)
' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE " & TABLE_NAME & ".Fields.Item(' fldTypeName').V alue = '"
& sType & "' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondName').V alue = '" & sCond & "'
AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondVar').Va lue = '" & sCondVar &
"' AND " & _
' TABLE_NAME & ".Fields.Item(' fldCondLBR').Va lue = ''2L''"
'ErrState: -2147217900 (Syntax error (missing operator) in query expression
'tblTypeCond.Fi elds.Item('fldT ypeName').Value = 'A' AND
tblTypeCond.Fie lds.Item('fldCo ndName').Value = '1' AND
tblTypeCond.Fie lds.Item('fldCo ndVar').Value = '4' AND
tblTypeCond.Fie lds.Item('fldCo ndLBR').Value = ''2L'''.)

eliminate the where clause maybe that's the problem?
'Try execute sql <Select Count(*) As 'Total' From tblTypeCond>
'ErrState: ErrNum 3265 (Item cannot be found in the collection corresponding
to the requested name or ordinal.)

yikes...what's the problem???

i'm running out of ideas
any help?
Thanks
Mark
You don't need to dereference the column names to determine or set the
value. Taking your first example:

sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
' " WHERE fldType = '" & sType & "' AND " & _
' " fldCondName = '" & sCond & "' AND " & _
' " fldCondVar = '" & sCondVar & "' AND " & _
' " fldCondLBR = '2L'"
etc. Obviously I can't vouch for the actual efficacy of this, since
you don't provide table defs.

Edward

Oct 25 '06 #2
MP

<te********@hot mail.comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .
>
You don't need to dereference the column names to determine or set the
value. Taking your first example:

sSql = "Select Count(*) As 'Total' From " & TABLE_NAME & _
' " WHERE fldType = '" & sType & "' AND " & _
' " fldCondName = '" & sCond & "' AND " & _
' " fldCondVar = '" & sCondVar & "' AND " & _
' " fldCondLBR = '2L'"

etc. Obviously I can't vouch for the actual efficacy of this, since
you don't provide table defs.

Edward
Thanks for looking at it.
I knew I didn't *need* to explicitly use .Value but I always heard it's best
not to rely on default properties.
I'm not sure its' *wrong* to explicitly specify the .Value in a Select
statement either...but maybe it is.
In any case it still doesn't work, the error running the above is:
'ErrState: ErrNum 3265 (Item cannot be found in the collection corresponding
to the requested name or ordinal.)

There was a typo in the first example but i fixed it before running this
again ... fldType is fldTypeName
the actual string run was:
' sSql = "Select Count(*) From " & TABLE_NAME & _
' " WHERE fldTypeName = '" & sType & "' AND " & _
' " fldCondName = '" & sCond & "' AND " & _
' " fldCondVar = '" & sCondVar & "' AND " & _
' " fldCondLBR = '2L'"

Earlier in the prog I run a string to get a distinct group
sSql = "SELECT DISTINCT fldTypeName, fldCondName, fldCondvar, fldcondlbr"
& _
" FROM " & TABLE_NAME & _
" ORDER BY fldTypeName, fldCondName, fldCondvar, fldcondlbr"
FormReport "Try execute sql <" & sSql & ">"
Set oRs = moDb.Execute(sS ql)
that returns me a set with several records so the field names are right
(Table_Name is a string constant for the table name.)

now i'm trying to use the same open connection to get another recordset with
the count
maybe you cant' reuse a connection?????

i'm looping through the above recordset to try to get a count for each group
within it
While Not oRs.EOF
sType = oRs.Fields.Item ("fldTypeName") .Value
sCond = oRs.Fields.Item ("fldCondName") .Value
sCondVar = oRs.Fields.Item ("fldCondVar"). Value
FormReport "Check " & sType & sCond & sCondVar
so now i build the sql string using those variables
sSql = "Select Count(*) From " & TABLE_NAME & _
" WHERE fldTypeName = '" & sType & "' AND " & _
" fldCondName = '" & sCond & "' AND " & _
" fldCondVar = '" & sCondVar & "' AND " & _
" fldCondLBR = '2L'"

'try to get another recordset via same connection...ma yb that the problem?
Set oRsCount = moDb.Execute(sS ql)
and thats when i get the errors

I can't even drop all the wheres' and get it to work
sSql = "Select Count(*) From " & TABLE_NAME

Try execute sql <Select Count(*) From tblTypeCond>
ErrState: ErrNum 3265 (Item cannot be found in the collection corresponding
to the requested name or ordinal.)

I know i don't have a field named Count or one named * but I thought that
was a generic function that should run on any table...
do you see what i'm doing wrong?

I spent about 4 hours on google reading tons of posts on Select Count(*) etc
and don't see what I'm doing wrong.

Thanks
mark
Oct 25 '06 #3
MP

"MP" <no****@Thanks. comwrote in message
news:JR******** **********@torn ado.rdc-kc.rr.com...
>
<te********@hot mail.comwrote in message
news:11******** **************@ b28g2000cwb.goo glegroups.com.. .

You don't need to dereference the column names to determine or set the
value. Taking your first example:
I should have tried this earlier...
the problem isn't in the select count statement it's in reusing the
connection...
if i isolate the count to a single call on the connection it works
sSql = "Select Count(*) From " & TABLE_NAME
FormReport "Try execute sql <" & sSql & ">"
Set oRs = moDb.Execute(sS ql)
lCount2 = oRs.Fields(0).V alue
FormReport "Lcount2: <" & lCount2 & ">"

result:
Try execute sql <Select Count(*) From tblTypeCond>
Lcount2: <37>

so I guess I have to establish multiple connections to get multiple
recordsets???
seems I cant do
Set oRs1 = oConn.Execute(s ql1)
while not ors1.eof
set ors2 = oconn.execute(s ql2)
etc
ors1.movenext
wend

i guess i need something like
Set oRs1 = oConn1.Execute( sql1)
Set oConn2 = new connnection to same database
while not ors1.eof
sql2 = based on ors1 values
set ors2 = oconn2.execute( sql2)
etc
ors1.movenext
wend

is that right?
thanks
Oct 25 '06 #4
"MP" <no****@Thanks. comwrote in
news:JR******** **********@torn ado.rdc-kc.rr.com:
I knew I didn't *need* to explicitly use .Value but I always heard
it's best not to rely on default properties.
There is no Value property in a SQL statement. The fields in a
recordset have a Value property, but not in SQL.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 25 '06 #5
"MP" <no****@Thanks. comwrote in
news:JR******** **********@torn ado.rdc-kc.rr.com:
I spent about 4 hours on google reading tons of posts on Select
Count(*) etc and don't see what I'm doing wrong.
I don't think you need to do that. Look at my other post about the
self-join. You might want to do the Count() in the virtual table I
suggested in that post if that number is important and you want only
one record returned by the self-join. But I think you need both the
count and the value assigned to your last field, no?

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 25 '06 #6
"MP" <no****@Thanks. comwrote in
news:Zj******** **********@torn ado.rdc-kc.rr.com:
so I guess I have to establish multiple connections to get
multiple recordsets???
[]
is that right?
I don't do ADO. There are none of these problems in DAO at all.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Oct 25 '06 #7
MP
"David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...
"MP" <no****@Thanks. comwrote in
news:JR******** **********@torn ado.rdc-kc.rr.com:
I knew I didn't *need* to explicitly use .Value but I always heard
it's best not to rely on default properties.

There is no Value property in a SQL statement. The fields in a
recordset have a Value property, but not in SQL.

--
AH HA!
:-)
Thanks for that.
But i dont' think that was my *only* problem <g>
somethings wrong in the loop i'm calling this in
(see other posts this thread)

even with no fieldnames in the sql it wasnt' working
(see other posts this thread)

if i call it outside of a loop...on it's own it works....
still looking for the solution
Oct 25 '06 #8
MP
David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...
"MP" <no****@Thanks. comwrote in
news:JR******** **********@torn ado.rdc-kc.rr.com:
I spent about 4 hours on google reading tons of posts on Select
Count(*) etc and don't see what I'm doing wrong.

I don't think you need to do that. Look at my other post about the
self-join. You might want to do the Count() in the virtual table I
suggested in that post if that number is important and you want only
one record returned by the self-join. But I think you need both the
count and the value assigned to your last field, no?
I'm studying that post now and will post back when I get it figured out.
Thanks again
Oct 25 '06 #9
MP
"David W. Fenton" <XX*******@dfen ton.com.invalid wrote in message
news:Xn******** *************** ***********@127 .0.0.1...
"MP" <no****@Thanks. comwrote in
news:Zj******** **********@torn ado.rdc-kc.rr.com:
so I guess I have to establish multiple connections to get
multiple recordsets???

[]
is that right?

I don't do ADO. There are none of these problems in DAO at all.
ok ok, don't rub it in :-)
you're eventually gonnna talk me into having to learn dao now eh?
<vbg>


Oct 25 '06 #10

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

Similar topics

21
5253
by: John Fabiani | last post by:
Hi, I'm a newbie and I'm attempting to learn howto create a select statement. When I use >>> string1='18 Tadlock Place' >>> cursor.execute("SELECT * FROM mytest where address = %s",string1) All works as expected. But >>> numb=10 >>> cursor.execute("SELECT * FROM mytest where clientID = %d",numb) Traceback (innermost last): File "<stdin>", line 1, in ?
0
4999
by: Fatt Shin | last post by:
Hi, I'm running MySQL 4.0.13, connecting from PowerBuilder 9 using ODCB Connector 3.51. I'm facing a problem where whenever I issue a SELECT COUNT(*) statement from PowerBuilder, I always get SQL syntax error back from MySQL. (Refer to ODBC Trace I captured below). metrohouse af8-b94 ENTER SQLExecDirect HSTMT 014D2360 UCHAR * 0x020A0EA2 "select count ( *) from code
3
3548
by: Ian T | last post by:
Hi, I've got what I think (probably incorrectly) should be a simple SELECT : Two colums with data like col1 col2 1 50 1 51 2 50
4
2863
by: jimh | last post by:
I'm not a SQL expert. I want to be able to write a stored procedure that will return 'people who bought this product also bought this...'. I have a user table that links to a transaction table that links to a transaction items table that links to the products table: (User Table) UserID Other user data
5
2358
by: Silvio Matthes | last post by:
Hello, I'm new to the list and did not find a suitable answer to my question so here it is: I try to select the rows of a table where the content of a varchar-column is empty ('') and PostgresQL is doing a seqscan. I've tried this on a PostgresQL-Serverversion 7.3.4 and 8.0 beta1.
3
12557
by: imrantbd | last post by:
This is my first problem.Please help me. I have the following code: <head> <script language="JavaScript"> function addSrcToDestList() { destList1 = window.document.forms.destList; srcList = window.document.forms.srcList;
3
8718
by: imrantbd | last post by:
I need array type name like "destList" must use for my destlist select box,not a single name.Or need a solution to capture multiple value of "destList" select box and send all selected value in php page.The multiple select value then insert in database added by comma.The following is my code: Form Page:form.php <head> <script language="JavaScript"> function addSrcToDestList() { destList1 = window.document.forms.destList; srcList...
15
3325
by: Simon Gare | last post by:
Hi, trying to retrieve postal codes from the db but only want the query to look at the first 3 digits of the code tried using (LEFT(dbo.booking_form.COLL_POST_CODE),3) but that doesn't work. I don't want the query to count individual post codes but instead look at an area found in the first 3 digits e.g. HA0 3TD is for a particular house but HA) is for the area Harrow.
0
1519
by: cmrhema | last post by:
Hi, I have two controls one html select control and one asp.net dropdownlist control. In html select control i have three maps loaded. It is loaded in the following manner. <SELECT class="TextBoxLabel" id="ddlMap" style="WIDTH: 128px;" tabIndex="1" onchange="fnChangeMap();" name="ddlMap" runat="server">
0
8962
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 usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8785
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 synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
1
9251
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9200
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
8201
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6747
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4559
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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3273
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
2188
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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.