Logical Default - Microsoft Access / VBA

Dominic Vella

I am using MS-Access2000. I can't seem to set the default values for Logical
type fields. I start with
Dim dbsTmp As Object ' I think it's DAO.Database
Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path & "\data_be.m db")

and then use the following to run my SQL ststement
dbsTmp.Execute
-----------------------------------------------------
Something like this SQL statement works:
"ALTER TABLE tblStudent ADD COLUMN student_number long NULL"

But all of these SQL statements don't seem to work
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical -1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical 1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical TRUE"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical .T."

------------------------------------------------------
Can anyone tell me how to set the default value for a logical field?

Thanks
Dominic

Jan 16 '08 #1

Subscribe Reply

4676

Allen Browne

Try something like this:

strSql = "ALTER TABLE tblStudent ADD COLUMN student_accommo dation YESNO
DEFAULT True;"
CurrentProject. Connection.Exec ute strSql

The important thing is executing the string with ADO code.

-1 should also work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@ optusnet.com.au wrote in message
news:47******** *************** @news.optusnet. com.au...

>I am using MS-Access2000. I can't seem to set the default values for
Logical type fields. I start with
Dim dbsTmp As Object ' I think it's DAO.Database
Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path &
"\data_be.m db")

and then use the following to run my SQL ststement
dbsTmp.Execute
-----------------------------------------------------
Something like this SQL statement works:
"ALTER TABLE tblStudent ADD COLUMN student_number long NULL"

But all of these SQL statements don't seem to work
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical -1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical 1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical TRUE"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical .T."

------------------------------------------------------
Can anyone tell me how to set the default value for a logical field?

Jan 17 '08 #2

Dominic Vella

Thanks for the reply.

It didn't work as in I received a 'Syntax Error in ALTER TABLE statement.'
Error

I decided it could have been because I'm using DAO instead of ABODB, so I
tried this:

Dim cnn As New ADODB.Connectio n
Dim rst As New ADODB.Recordset

' Open the connection.
Set cnn = New ADODB.Connectio n
With cnn
.Provider = "Microsoft.Jet. OLEDB.4.0"
.Open CurrentProject. path & "\data_be.m db"
End With

cnn.Execute "ALTER TABLE [tblStudent] ADD COLUMN [student_accommo dation]
YESNO True;"

cnn.Close
Set cnn = Nothing

I had to leave the word DEFAULT out as it caused it's own 'Database default
definition' error.
Still, using True, -1 and 1 created the field but did not set the default
value. Using .T. was definately no good.
I think it's a quirk with Logical fields, other field types don't have any
problems setting the default (that I found so far). This is frustrating
though.

Dominic

"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...

Try something like this:

strSql = "ALTER TABLE tblStudent ADD COLUMN student_accommo dation YESNO
DEFAULT True;"
CurrentProject. Connection.Exec ute strSql

The important thing is executing the string with ADO code.

-1 should also work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@ optusnet.com.au wrote in message
news:47******** *************** @news.optusnet. com.au...
>>I am using MS-Access2000. I can't seem to set the default values for
Logical type fields. I start with
Dim dbsTmp As Object ' I think it's DAO.Database
Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path &
"\data_be.mdb" )

and then use the following to run my SQL ststement
dbsTmp.Execute
-----------------------------------------------------
Something like this SQL statement works:
"ALTER TABLE tblStudent ADD COLUMN student_number long NULL"

But all of these SQL statements don't seem to work
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical -1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical 1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical TRUE"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical .T."

------------------------------------------------------
Can anyone tell me how to set the default value for a logical field?

Jan 17 '08 #3

Allen Browne

Dominic, it looks like DEFAULT works with CREATE TABLE executed under ADO,
but not with ALTER TABLE.

Much simpler to use DAO to set the DefaultProperty of the Field in the
TableDef anyway.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@ optusnet.com.au wrote in message
news:47******** *************** @news.optusnet. com.au...

Thanks for the reply.

It didn't work as in I received a 'Syntax Error in ALTER TABLE statement.'
Error

I decided it could have been because I'm using DAO instead of ABODB, so I
tried this:

Dim cnn As New ADODB.Connectio n
Dim rst As New ADODB.Recordset

' Open the connection.
Set cnn = New ADODB.Connectio n
With cnn
.Provider = "Microsoft.Jet. OLEDB.4.0"
.Open CurrentProject. path & "\data_be.m db"
End With

cnn.Execute "ALTER TABLE [tblStudent] ADD COLUMN
[student_accommo dation] YESNO True;"

cnn.Close
Set cnn = Nothing

I had to leave the word DEFAULT out as it caused it's own 'Database
default definition' error.
Still, using True, -1 and 1 created the field but did not set the default
value. Using .T. was definately no good.
I think it's a quirk with Logical fields, other field types don't have any
problems setting the default (that I found so far). This is frustrating
though.

Dominic

"Allen Browne" <Al*********@Se eSig.Invalidwro te in message
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au ...
>Try something like this:

strSql = "ALTER TABLE tblStudent ADD COLUMN student_accommo dation
YESNO DEFAULT True;"
CurrentProject. Connection.Exec ute strSql

The important thing is executing the string with ADO code.

-1 should also work.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dominic Vella" <do***********@ optusnet.com.au wrote in message
news:47******* *************** *@news.optusnet .com.au...
>>>I am using MS-Access2000. I can't seem to set the default values for
Logical type fields. I start with
Dim dbsTmp As Object ' I think it's DAO.Database
Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path &
"\data_be.mdb ")

and then use the following to run my SQL ststement
dbsTmp.Execute
-----------------------------------------------------
Something like this SQL statement works:
"ALTER TABLE tblStudent ADD COLUMN student_number long NULL"

But all of these SQL statements don't seem to work
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical -1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical 1"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical TRUE"
"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical .T."

------------------------------------------------------
Can anyone tell me how to set the default value for a logical field?

Jan 17 '08 #4

Dominic Vella

Yes, I have been using TableDef. It's just now a 2 step process that has
more variables in it.

I was developing a self updating database package, and it was simpler using
SQL statements. Now my Update Table will require table names and
fieldnames to make it work. Check out the difference

Preferred method - tblUpdate has only one field
------------------
cnn.Execute tblUpdate.updat e_sql

NonPrefered method - tblUpdate has 5 fields
---------------------
Const cUpdateSQL =1
Const cUpdateDefaultS tring = 2
Const cUpdateDefaultN umber = 3

Select Case tblUpdate.Type
Case 1: cnn.execute tblUpdate.updat e_sql
Case 2
cnn.TablesDef(t blUpdate.update _table).Field(t blUpdate.update _field).default (tblUpdate.upda te_value_string )Case 3 cnn.TablesDef(t blUpdate.update _table).Field(t blUpdate.update _field).default ( tblUpdate.updat e_value_number )End Selectetc.... and I'd have to do it twice, first time to run the SQL to create thefield, and again to set the default It's horrible, but seems necessary.Mind you, it's not all bad as I could use something like this (Tables andFields) in the future as I modify Forms and Controls, Commands andArguments, etc. Can't do those with SQL statements.Than ks anywayDominic"A llen Browne" <Al*********@Se eSig.Invalidwro te in messagenews:47* *************** *******@per-qv1-newsreader-01.iinet.net.au ...Dominic, it looks like DEFAULT works with CREATE TABLE executed under ADO,but not with ALTER TABLE.>Much simpler to use DAO to set the DefaultProperty of the Field in theTableDef anyway.>--Allen Browne - Microsoft MVP. Perth, Western AustraliaTips for Access users - http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at mvps dot org.>"Dominic Vella" <do***********@ optusnet.com.au wrote in messagenews:47* *************** *******@news.op tusnet.com.au.. .>Thanks for the reply.>>>It didn't work as in I received a 'Syntax Error in ALTER TABLEstatement. ' Error>>>I decided it could have been because I'm using DAO instead of ABODB, so Itried this:>>> Dim cnn As New ADODB.Connectio n> Dim rst As New ADODB.Recordset >>> ' Open the connection.> Set cnn = New ADODB.Connectio n> With cnn> .Provider = "Microsoft.Jet. OLEDB.4.0"> .Open CurrentProject. path & "\data_be.m db"> End With>>> cnn.Execute "ALTER TABLE [tblStudent] ADD COLUMN[student_accommo dation] YESNO True;">>> cnn.Close> Set cnn = Nothing>>>I had to leave the word DEFAULT out as it caused it's own 'Databasedefaul t definition' error.>Still, using True, -1 and 1 created the field but did not set the defaultvalue. Using .T. was definately no good.>I think it's a quirk with Logical fields, other field types don't haveany problems setting the default (that I found so far). This is frustratingthou gh.>>>Dominic>> >"Allen Browne" <Al*********@Se eSig.Invalidwro te in messagenews:47* *************** *******@per-qv1-newsreader-01.iinet.net.au ...>>Try something like this:>>>>> strSql = "ALTER TABLE tblStudent ADD COLUMN student_accommo dationYESNO DEFAULT True;">> CurrentProject. Connection.Exec ute strSql>>>>>The important thing is executing the string with ADO code.>>>>>-1 should also work.>>>>>-->>Allen Browne - Microsoft MVP. Perth, Western Australia>>Tips for Access users - http://allenbrowne.com/tips.html>>Repl y to group, rather than allenbrowne at mvps dot org.>>>>>"Domin ic Vella" <do***********@ optusnet.com.au wrote in message>>news:4 7************** *********@news. optusnet.com.au ...>>>>I am using MS-Access2000. I can't seem to set the default values forLogical type fields. I start with>>> Dim dbsTmp As Object ' I think it's DAO.Database>>> Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path &"\data_be.mdb" )>>>>>>>and then use the following to run my SQL ststement>>> dbsTmp.Execute> >>----------------------------------------------------->>>Something like this SQL statement works:>>>"ALTER TABLE tblStudent ADD COLUMN student_number long NULL">>>>>>>But all of these SQL statements don't seem to work>>>"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical -1">>>"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical 1">>>"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical TRUE">>>"ALTER TABLE tblStudent ADD COLUMN student_accommo dation logical .T.">>>>>>>------------------------------------------------------>>>Can anyone tell me how to set the default value for a logical field?>>>>>>>>

Jan 17 '08 #5

Dominic Vella

Oh, that was scarey. that didn't come out the same way I wrote it.

Thanks Anyway.

Ok
"Dominic Vella" <do***********@ optusnet.com.au wrote in message
news:47******** *************** @news.optusnet. com.au...

Yes, I have been using TableDef. It's just now a 2 step process that has
more variables in it.

I was developing a self updating database package, and it was simpler
using SQL statements. Now my Update Table will require table names and
fieldnames to make it work. Check out the difference

Preferred method - tblUpdate has only one field
------------------
cnn.Execute tblUpdate.updat e_sql

NonPrefered method - tblUpdate has 5 fields
---------------------
Const cUpdateSQL =1
Const cUpdateDefaultS tring = 2
Const cUpdateDefaultN umber = 3

Select Case tblUpdate.Type
Case 1: cnn.execute tblUpdate.updat e_sql
Case 2
cnn.TablesDef( tblUpdate.updat e_table ).Field(
tblUpdate.updat e_field ).default( tblUpdate.updat e_value_string )
Case 3 cnn.TablesDef( tblUpdate.updat e_table ).Field(
tblUpdate.updat e_field ).default( tblUpdate.updat e_value_number )
End Select
etc.... and I'd have to do it twice, first time to run the SQL to create
the field, and again to set the default It's horrible, but seems
necessary.
Mind you, it's not all bad as I could use something like this (Tables
andFields) in the future as I modify Forms and Controls, Commands
andArguments , etc. Can't do those with SQL statements.

Thanks anyway

Dominic

"Allen Browne" <Al*********@Se eSig.Invalidwro te in
messagenews:47* *************** *******@per-qv1-newsreader-01.iinet.net.au ...>
Dominic, it looks like DEFAULT works with CREATE TABLE executed under
ADO,but not with ALTER TABLE.>Much simpler to use DAO to set the
DefaultProperty of the Field in theTableDef anyway.>--Allen Browne -
Microsoft MVP. Perth, Western AustraliaTips for Access users -
http://allenbrowne.com/tips.htmlReply to group, rather than allenbrowne at
mvps dot org.>"Dominic Vella" <do***********@ optusnet.com.au wrote in
messagenews:47* *************** *******@news.op tusnet.com.au.. .>Thanks for
the reply.>>>It didn't work as in I received a 'Syntax Error in ALTER
TABLEstatement. ' Error>>>I decided it could have been because I'm using
DAO instead of ABODB, so Itried this:>>> Dim cnn As New
ADODB.Connectio n> Dim rst As New ADODB.Recordset >>> ' Open the
connection.> Set cnn = New ADODB.Connectio n> With cnn> .Provider
= "Microsoft.Jet. OLEDB.4.0"> .Open CurrentProject. path &
"\data_be.m db"> End With>>> cnn.Execute "ALTER TABLE [tblStudent] ADD
COLUMN[student_accommo dation] YESNO True;">>> cnn.Close> Set cnn =
Nothing>>>I had to leave the word DEFAULT out as it caused it's own
'Databasedefaul t definition' error.>Still, using True, -1 and 1 created
the field but did not set the defaultvalue. Using .T. was definately no
good.>I think it's a quirk with Logical fields, other field types don't
haveany problems setting the default (that I found so far). This is
frustratingthou gh.>>>Dominic>> >"Allen Browne"
<Al*********@Se eSig.Invalidwro te in
messagenews:47* *************** *******@per-qv1-newsreader-01.iinet.net.au ...>>>
Try something like this:>>>>> strSql = "ALTER TABLE tblStudent ADD
COLUMN student_accommo dationYESNO DEFAULT True;">>>
CurrentProject. Connection.Exec ute strSql>>>>>The important thing is
executing the string with ADO code.>>>>>-1 should also work.>>>>>-->>>
Allen Browne - Microsoft MVP. Perth, Western Australia>>Tips for Access
users - http://allenbrowne.com/tips.html>>Repl y to group, rather than
allenbrowne at mvps dot org.>>>>>"Domin ic Vella"
<do***********@ optusnet.com.au wrote in message>>>
news:47******** *************** @news.optusnet. com.au...>>>>I am using
MS-Access2000. I can't seem to set the default values forLogical type
fields. I start with>>> Dim dbsTmp As Object ' I think it's
DAO.Database>>> Set dbsTmp = DBEngine.OpenDa tabase(CurrentP roject.path
&"\data_be.mdb" )>>>>>>>and then use the following to run my SQL
ststement>>>>
dbsTmp.Execute> >>----------------------------------------------------->>>>
Something like this SQL statement works:>>>"ALTER TABLE tblStudent ADD
COLUMN student_number long NULL">>>>>>>But all of these SQL statements
don't seem to work>>>"ALTER TABLE tblStudent ADD COLUMN
student_accommo dation logical -1">>>"ALTER TABLE tblStudent ADD COLUMN
student_accommo dation logical 1">>>"ALTER TABLE tblStudent ADD COLUMN
student_accommo dation logical TRUE">>>"ALTER TABLE tblStudent ADD COLUMN
student_accommo dation logical
..T.">>>>>>>------------------------------------------------------>>>Can
anyone tell me how to set the default value for a logical field?>>>>>>>>

>

Jan 17 '08 #6

lyle fairfield

"Allen Browne" <Al*********@Se eSig.Invalidwro te in
news:47******** *************** @per-qv1-newsreader-01.iinet.net.au :

Dominic, it looks like DEFAULT works with CREATE TABLE executed under
ADO, but not with ALTER TABLE.

Much simpler to use DAO to set the DefaultProperty of the Field in the
TableDef anyway.

This works:

CurrentProject. Connection.Exec ute "ALTER TABLE Table1 ADD COLUMN
[Sudent_Acommoda tion] YesNo DEFAULT Yes"
--
lyle fairfield

In ancient times Ulysses had to outwit the sirens, who had the power to
charm by their song all sailors who heard them, so that the mariners were
compelled to cast themselves into the sea to their destruction.
Today, he would have to deal with (free) Aim-Mail.

Jan 17 '08 #7

lyle fairfield

"Dominic Vella" <do***********@ optusnet.com.au wrote in
news:47******** *************** @news.optusnet. com.au:

Thanks for the reply.

It didn't work as in I received a 'Syntax Error in ALTER TABLE
statement.' Error

I decided it could have been because I'm using DAO instead of ABODB,
so I tried this:

Dim cnn As New ADODB.Connectio n
Dim rst As New ADODB.Recordset

' Open the connection.
Set cnn = New ADODB.Connectio n
With cnn
.Provider = "Microsoft.Jet. OLEDB.4.0"
.Open CurrentProject. path & "\data_be.m db"
End With

cnn.Execute "ALTER TABLE [tblStudent] ADD COLUMN
[student_accommo dation]
YESNO True;"

cnn.Close
Set cnn = Nothing

I had to leave the word DEFAULT out as it caused it's own 'Database
default definition' error.
Still, using True, -1 and 1 created the field but did not set the
default value. Using .T. was definately no good.
I think it's a quirk with Logical fields, other field types don't have
any problems setting the default (that I found so far). This is
frustrating though.

This is not frustrating (to me, anyway):

CurrentProject. Connection.Exec ute "ALTER TABLE Table1 ADD COLUMN
[Sudent_Acommoda tion] YesNo DEFAULT Yes"

--
lyle fairfield

In ancient times Ulysses had to outwit the sirens, who had the power to
charm by their song all sailors who heard them, so that the mariners were
compelled to cast themselves into the sea to their destruction.
Today, he would have to deal with (free) Aim-Mail.

Jan 17 '08 #8

lyle fairfield

"Dominic Vella" <do***********@ optusnet.com.au wrote in
news:47******** *************** @news.optusnet. com.au:

Yes, I have been using TableDef. It's just now a 2 step process that
has more variables in it.

I was developing a self updating database package, and it was simpler
using SQL statements. Now my Update Table will require table names
and fieldnames to make it work.

Either that or you could try the correct SQL, I suppose.

--
lyle fairfield

In ancient times Ulysses had to outwit the sirens, who had the power to
charm by their song all sailors who heard them, so that the mariners were
compelled to cast themselves into the sea to their destruction.
Today, he would have to deal with (free) Aim-Mail.

Jan 17 '08 #9

Allen Browne

"lyle fairfield" <ly******@yahoo .cawrote in message
news:2A******** *******@read1.c gocable.net...

"Dominic Vella" <do***********@ optusnet.com.au wrote in
news:47******** *************** @news.optusnet. com.au:

CurrentProject. Connection.Exec ute "ALTER TABLE Table1
ADD COLUMN [Sudent_Acommoda tion] YesNo DEFAULT Yes"

Hi Lyle. I still can't get DEFAULT to work with an existing column, i.e.:

strSql = "ALTER TABLE MyTable ALTER COLUMN MyYesNo DEFAULT Yes;"
CurrentProject. AccessConnectio n.Execute strSql
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Jan 17 '08 #10

Similar topics

44097

SQL*Loader - Commit point reached - logical record count 27

by: Hari Om | last post by:

Here are the details of my error log files: I execute the command and get following message at console: ---------------------------------------------------------------------- ../sqlldr scott/tiger@common control=/full_path/test.ctl log=/full_path/adhoc/test.log SQL*Loader: Release 9.2.0.1.0 - Production on Tue Sep 2 10:49:27 2003 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.

Oracle Database

2880

Need some guidance with ENUM (logical) fields in MySQL

by: Charles Crume | last post by:

Hello all; I have used dBASE, and other computer languages/databases, for years. They all have a logical field type. However, the version of MySQL used by the ISP hosting my site does not support a "logical" field type. It does support ENUM and I have set some up in a couple of tables that accept the values 'T' and 'F'. Sometimes they work like a logical field: if ($myrow) echo 'New';

MySQL Database

6553

Change Logical Name of Db and Log file

by: A.M. de Jong | last post by:

Hi, Is there an option (stored procedure) or whatever to change to logical name of the databasefile and the database log file ? Arno de Jong, The Netherlands.

Microsoft SQL Server

35084

Why isn't there a logical XOR operator?

by: Christopher Benson-Manica | last post by:

Of course one can get the effect with appropriate use of existing operators, but a ^^ operator would make for nice symmetry (as well as useful to me in something I'm working on). Am I the only one who would find it useful? -- Christopher Benson-Manica | I *should* know what I'm talking about - if I ataru(at)cyberspace.org | don't, I need to know. Flames welcome.

C / C++

1589

Logical On

by: Cor | last post by:

Hi group, A question to the group, would it not be for a lot of the users better when there was beside "Option strict on" an "Option logical Strict on". I was automaticaly writting Textbox1.text = 0.tostring. I know what it has to be, but I did this automaticly. I find this crazy, it cannot be something else than a string, so the compiler must have to find this very easy, but for the puritains, than that

Visual Basic .NET

1572

Query Optimization: CPU speed or Logical Reads better?

by: serge | last post by:

How do I determine which method I should use if I want to optimize the performance of a database. I took Northwind's database to run my example. My query is I want to retrieve the Employees' First and Last Names that sold between $100,000 and $200,000. First let me create a function that takes the EmployeeID

Microsoft SQL Server

6807

slow insert, logical fragmentation

by: Dave | last post by:

We had a table that had logical fragmentation of 50%. After rebuilding (with default fillfactor 0) I noticed that inserts are much faster. If my page density is 100% wouldn't I get more page splits? I know I am missing something fundamental here. Could someone get me back on track? Table Size 1.5 million Insert Size 70K Before: 15 minutes

Microsoft SQL Server

5535

Logical Reads = CPU Consumption ???

by: dbtwo | last post by:

Until today I always thought as long as you see a lot of logical reads as compared to physical reads, then you're good. But it looks like it isn't so. But doesn't logical read mean it's being read from memory and no I/O involved? So why is Logical Reads = CPU Consumption ? I ran into an exact scenario last week when our applciation were running something, and each time an application started, the CPU would go from 99% idle to 48% idle. I...

DB2 Database

3549

How To center a logical drawing space much bigger than your screen?

by: raylopez99 | last post by:

I have a logical drawing space much bigger than the viewport (the screen) and I'd like to center the viewport (the screen) to be at the center of the logical drawing space. After following the excellent transforms specified on Bob Powell's site, I still wonder if there's an easier way of centering it than the following procedure? Here is what I do now (it's awkward but it works): 1) I follow the transforms specified on Bob Powell's...

C# / C Sharp

8233

What is ONU?

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...

General

8170

Changing the language in Windows 10

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,...

Windows Server

8675

Problem With Comparison Operator <=> in G++

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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

8334

The easy way to turn off automatic updates for Windows 10/11

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,...

Windows Server

5561

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4078

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

2604

transfer the data from one system to another through ip address

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

C# / C Sharp

1784

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

1482

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General