If your value is in a TXT file:

You might GATEWAY IMPORT TXT. [filename] CREATE [tablename]

then set a variable equal to field1 from [tablename]

DROP TABLE [tablename] so there will be only a single row each time. 

Randy Peterson. 

Sent from my iPhone

> On Apr 22, 2022, at 12:59 PM, Dan Goldberg <[email protected]> wrote:
> 
> 
> 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 | LinkedIn | Twitter | Facebook
> ___________________________________________________________
> 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.
> -- 
> 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/WC20220422134549.620127%40jjcalibrations.com.
> -- 
> 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/BL3PR07MB8755CD85C64E6AB621194A74B4F79%40BL3PR07MB8755.namprd07.prod.outlook.com.
> -- 
> 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/2E4830CEC16615458329D3D83342F8D0014EFEE46D%40EXCHANGE10.
> -- 
> 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/2E4830CEC16615458329D3D83342F8D0014EFEE820%40EXCHANGE10.

-- 
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/06954A74-E97D-44B5-A4F9-8E8ECE216B44%40ctags.com.

Reply via email to