got it. note, though, that finding the target "connected" is no sure
thing.
In my example I searched the netsh output for NOT CONTAINS ':
connected', because I've not experimented to discover whether the
not-wifi output of netsh reads ': not connected'
I'm sure there's a straight CMD_EXE way to do it, but you may also
consider the "Take Command" ( jpsoft.com ) console replacement which
takes command line tools where Microsoft never dared to tread.
Best, Bruce
Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | [email protected]
------ Original Message ------
From: "Dan Goldberg" <[email protected]>
To: "[email protected]" <[email protected]>
Sent: 4/22/2022 2:26:49 PM
Subject: RE: Re[2]: [RBASE-L] - detect wireless connection
Thx but I need to do it before it connects to the database. So it has
to be loaded into a variable and then I can do:
If vfiletxt contains ‘connected’ then
Pause 1 using ‘You cannot run using wifi. Please plug into the
matrix’
Goto endproc
Endif
--connect to database
Connect dbname
Label endproc
Exit
Dan Goldberg
From:[email protected] <[email protected]> On Behalf Of
Bruce Chitiea
Sent: Friday, April 22, 2022 2:01 PM
To:[email protected]
Subject: Re[2]: [RBASE-L] - detect wireless connection
Dan: A quick and dirty scientific wild a** guess, and the absolute long
way around, here (just sayin'):
Courier New Font:
(1)
LAUNCH netsh wlan show interfaces > d:\wiFiCheck.txt (with required
formatting)
... which produces:
There is 1 interface on the system:
Name : Wi-Fi
Description : Intel(R) Dual Band Wireless-AC 8265
GUID : 397b2529-0dfe-4991-8a60-30b14707f60c
Physical address : 18:1d:ea:31:b8:84
Interface type : Primary
State : connected
...
(2)
GATEWAY IMPORT TXT +
d:\wiFiCheck.txt +
CREATE TEMP wiFiCheck +
OPTION COLUMN_COUNT 1
...where each text line appears as a separate record
(4)
CLS
SELECT FIELD1 +
INTO vwiFiState INDICATOR vind +
FROM wiFiCheck +
WHERE field1 CONTAINS 'state'
(5)
IF vwiFiState NOT CONTAINS ': connected' THEN
SET VAR vwiFi_flag TEXT = 'hey buddy, get to work'
ELSE
SET VAR vwiFi_flag TEXT = 'wasted your gas today,huh?'
ENDIF
RETURN
------ Original Message ------
From: "Dan Goldberg" <[email protected]>
To: "[email protected]" <[email protected]>
Sent: 4/22/2022 10:59:50 AM
Subject: RE: [RBASE-L] - detect wireless connection
So my first hurdle is to find a way to put the contents of a txt file
into a variable. Does anyone know how to do that? I am drawing a
blank.
TIA
Dan Goldberg
From:[email protected] <[email protected]> On Behalf Of
Dan Goldberg
Sent: Friday, April 22, 2022 7:26 AM
To:[email protected]
Subject: RE: [RBASE-L] - detect wireless connection
Hmm interesting. I am going to play with that and see how it works.
Gunna create the text file, have rbase look in the text file for
“connected” before connecting to the database and if exists then close
rbase.
Dan Goldberg
From:[email protected] <[email protected]> On Behalf Of
Richardson, Jeff
Sent: Friday, April 22, 2022 7:21 AM
To:[email protected]
Subject: RE: [RBASE-L] - detect wireless connection
Dan/Jan:
I’m no expert, but some time ago I cobbled together a way to detect a
network:
This DOS command allows me to get network information:
Netsh WLAN show interfaces
This DOS command sends the output to a file:
Netsh WLAN show interfaces > C:\CTC\TOOLS\RBX5\WifiTestOutput.txt
I put this line in a batch file, run it from RBase, and then import
the file into a temporary table and extract what I need from it.
Hope this guides you a little.
Jeff Richardson | Project Manager, Asset Verification Services (AVS)
DMA – DuCharme, McMillen & Associates, Inc. | 828 S Harrison Street
Suite 650, Fort Wayne, IN 46802
Cell: 724-366-1724
Connect: [email protected] | Website <http://www.dmainc.com/> |
LinkedIn
<https://www.linkedin.com/company/ducharme-mcmillen-&-associates> |
Twitter <https://twitter.com/DMATAX> | Facebook
<https://www.facebook.com/DMAtaxservices>
___________________________________________________________
ATTENTION: This message and all attachments are PRIVATE, and may
contain information that is CONFIDENTIAL and PRIVILEGED. If you have
received this message in error, please notify the sender by reply
e-mail and delete the message immediately.
From:[email protected] <[email protected]> On Behalf Of
jan johansen
Sent: Friday, April 22, 2022 9:46 AM
To:[email protected]
Subject: Re: [RBASE-L] - detect wireless connection
Dan,
I'm interested in this idea as well.
One option I've been wondering about is including ALL the forms,
reports and labels inside the compiled app.
That way the only stuff that should be flying through the ether is the
actual data.
Maybe someone else has an idea.
Jan
From: Dan Goldberg <[email protected]>
To: "[email protected]" <[email protected]>
Date: Fri, 22 Apr 2022 13:36:54 +0000
Subject: [RBASE-L] - detect wireless connection
Does anyone know If there is a way to detect if the active network
connection is wireless?
I want to be able to not allow them to run our compiled rbase app on
their laptops when they are on wireless.
TIA
Dan Goldberg
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it,
send an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE31D%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE31D%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/WC20220422134549.620127%40jjcalibrations.com
<https://groups.google.com/d/msgid/rbase-l/WC20220422134549.620127%40jjcalibrations.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/BL3PR07MB8755CD85C64E6AB621194A74B4F79%40BL3PR07MB8755.namprd07.prod.outlook.com
<https://groups.google.com/d/msgid/rbase-l/BL3PR07MB8755CD85C64E6AB621194A74B4F79%40BL3PR07MB8755.namprd07.prod.outlook.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE46D%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE46D%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE820%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE820%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
<http://www.rbase.com/support/usersgroup_guidelines.php>
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em23977fef-2e18-4e33-b66e-da880bcc818a%40pathfinder
<https://groups.google.com/d/msgid/rbase-l/em23977fef-2e18-4e33-b66e-da880bcc818a%40pathfinder?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE9E8%40EXCHANGE10
<https://groups.google.com/d/msgid/rbase-l/2E4830CEC16615458329D3D83342F8D0014EFEE9E8%40EXCHANGE10?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em2283f31b-fdad-4b5f-9321-626842ee3983%40pathfinder.
