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]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Dan Goldberg Sent: Friday, April 22, 2022 7:26 AM To: [email protected]<mailto:[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]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of Richardson, Jeff Sent: Friday, April 22, 2022 7:21 AM To: [email protected]<mailto:[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]<mailto:[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. [cid:[email protected]] From: [email protected]<mailto:[email protected]> <[email protected]<mailto:[email protected]>> On Behalf Of jan johansen Sent: Friday, April 22, 2022 9:46 AM To: [email protected]<mailto:[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]<mailto:[email protected]>> To: "[email protected]<mailto:[email protected]>" <[email protected]<mailto:[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]<mailto:[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 --- 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]<mailto:[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 --- 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]<mailto:[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 --- 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]<mailto:[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 --- 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]<mailto:[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 --- 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]<mailto:[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.
