Search found 250 matches

by GomezL
Fri May 19, 2023 12:26 pm
Forum: General Development
Topic: SQL Server Connection String
Replies: 1
Views: 748

Re: SQL Server Connection String

It turns out that the message is just informational. (False Positive)
by GomezL
Wed May 17, 2023 3:03 pm
Forum: General Development
Topic: Folder Name -- Picker
Replies: 3
Views: 469

Re: Folder Name -- Picker

Nifty!: I had a problem running the code, I ran your sample through ChatGPT, and it returned the following: I ran the code using a command like this: cscript Folder_Picker.vbs "d:\Rejections\" >d:\work\output_file.txt Option Explicit Dim strPath, objArgs Set objArgs = WScript.Arguments str...
by GomezL
Fri Mar 03, 2023 9:02 am
Forum: General Development
Topic: Folder Name -- Picker
Replies: 3
Views: 469

Folder Name -- Picker

I am looking for a utility that will display a dialog box and then request the user pick a folder.

I know that BR has the "NAME=OPEN:" command, but that is a FILENAME picker, and I only want them to pick the folder.

Does anyone have something that I could use?
by GomezL
Fri Mar 03, 2023 8:56 am
Forum: General Development
Topic: Folder Name -- Picker
Replies: 0
Views: 235

Folder Name -- Picker

I am looking for a utility that will display a dialog box and then request the user pick a folder.

I know that BR has the "NAME=OPEN:" command, but that is a FILENAME picker, and I only want them to pick the folder.

Does anyone have something that I could use?
by GomezL
Tue Dec 06, 2022 9:03 am
Forum: General Development
Topic: SQL Server Connection String
Replies: 1
Views: 748

SQL Server Connection String

I am trying to create a connection string and am receiving the following error: • SQLDriverConnect(with connect string): connecting to database message SQL Dagnostic Info SQLState:01000 DB Err:5703 [Microsoft][SQL Server Native Client 11.0][SQL Server]Changed language setting to us_english. Does any...
by GomezL
Tue Aug 16, 2022 8:32 am
Forum: Advanced Concepts
Topic: Convert Unix Timestamp
Replies: 4
Views: 2468

Re: Convert Unix Timestamp

David provided the magic formula!

pr date$(days(19700101)+timer/86400,'M/D/CY') = 8/16/2022
by GomezL
Tue Aug 16, 2022 8:28 am
Forum: Advanced Concepts
Topic: Convert Unix Timestamp
Replies: 4
Views: 2468

Re: Convert Unix Timestamp

See: https://www.unixtimestamp.com/ Seconds Since Jan 1/1970 Also, TIMER is BR is the same value: Human Readable Time Seconds 1 Hour 3600 Seconds 1 Day 86400 Seconds 1 Week 604800 Seconds 1 Month (30.44 days) 2629743 Seconds 1 Year (365.24 days) 31556926 Seconds I didn't do the math, but you should ...
by GomezL
Tue Aug 09, 2022 7:18 am
Forum: Advanced Concepts
Topic: MFA authentication using BR's HTTP Client
Replies: 1
Views: 1283

Re: MFA authentication using BR's HTTP Client

Nice tool! In our application, I create an environment variable that stores an encrypted "Hex Code." In the setup routine of my primary library, I check to make sure it's properly configured, and if not, then I trap it for "Unauthorized Use." Sometimes a sophisticated user will t...
by GomezL
Mon Feb 28, 2022 3:13 pm
Forum: Printing
Topic: Printing a Signature
Replies: 4
Views: 5398

Re: Printing a Signature

I am sure this solution falls into the "Costs A Fortune" category: https://www.wycomsystems.com/

I particularly like their solutions because you lock the solution with two separate keys. Both the Manager and the operator need to unlock the device in order to print checks.
by GomezL
Sat Aug 07, 2021 8:45 am
Forum: General Development
Topic: Mixing Keyed and Relative File Access
Replies: 11
Views: 12835

Re: Mixing Keyed and Relative File Access

Your example reminded me why I don't use REC= for updating keyed files. BR is being helpful and is adding a NEW INDEX ENTRY, but it's also keeping the "OLD INDEX ENTRY" as well. I think that's a "Bug" and that BR should be deleting the original key information. If you run your pr...
by GomezL
Tue Aug 03, 2021 9:37 am
Forum: General Development
Topic: Mixing Keyed and Relative File Access
Replies: 11
Views: 12835

Re: Mixing Keyed and Relative File Access

I would try the program Gordon uploaded to see if it works in your specific BR Version. Here is a function we use to use "Keys" instead of "Delete Rec=" The program figures out the proper index based on the file handle passed, and then uses the key to read comparing record #s. Pl...
by GomezL
Mon Aug 02, 2021 2:23 pm
Forum: General Development
Topic: Mixing Keyed and Relative File Access
Replies: 11
Views: 12835

Re: Mixing Keyed and Relative File Access

00005 DIM Key$*8,Data$*100 00010 OPEN #1: "Name=[Temp]Datafile.int,kfname=[temp]datafile.idx,Replace,RECL=128,KPS=1,KLN=8",INTERNAL,OUTIN,KEYED 00015 ! Write Blank Records & Keys 00020 FOR _Write_Loop=1 TO 10 00030 WRITE #1,USING 40: "","" 00040 FORM Pos 1,C 8,C 80...
by GomezL
Wed Jan 06, 2021 3:42 pm
Forum: General Development
Topic: running BR 3.91
Replies: 7
Views: 21721

Re: running BR 3.91

I think you are remembering ISAM. OPTION 5 is OFF - default to ISAM indexes. As I remember, if you don't specify indexing the file in the new BR will convert to the "new Index Format." Some people used to actually open an ISAM index as it was a "Special internal file" that contai...
by GomezL
Wed Jan 06, 2021 12:47 pm
Forum: General Development
Topic: running BR 3.91
Replies: 7
Views: 21721

Re: running BR 3.91

My WAG: Provide user full administrator rights. Disable UAC I remember in the compatibility settings one of the options is "Run as Administrator" use that too! BR did a pretty good job of creating "Options" that make the most current release work much like BR 3.91, there are many...
by GomezL
Tue May 12, 2020 6:32 am
Forum: Non-BR Topics
Topic: video conferencing
Replies: 6
Views: 11357

Re: video conferencing

We have been using Zoom for almost a year now. One of the things that I really enjoy is that besides having a "Paid Tier" they have a very functional free tier. Everyone at our office has a Zoom account. Most have the free tier that limits their multi-attendee (3 or more) meetings to 40 mi...