Search found 255 matches

by GomezL
Tue Aug 03, 2021 9:37 am
Forum: General Development
Topic: Mixing Keyed and Relative File Access
Replies: 11
Views: 21029

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: 21029

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: 29883

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: 29883

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: 18707

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...
by GomezL
Tue Jan 21, 2020 7:30 am
Forum: General Development
Topic: 5.15-2.55-2.6
Replies: 4
Views: 16282

Re: 5.15-2.55-2.6

You can better see the results using formated output: pr using "form n 30.28":5.15-2.55-2.6 Returns: 0.000000000000000444 You can see that there are 15 0's after the decimal place. Loop 1 million times: 00001 PRINT Newpage 00010 FOR Loop=1 TO 1000000 00020 LET A+=(5.15-2.55-2.6) 00030 NEXT...
by GomezL
Sat Aug 17, 2019 7:11 am
Forum: Advanced Concepts
Topic: Fun with Fonts
Replies: 0
Views: 16626

Fun with Fonts

00010 PRINT Newpage 00019 EXECUTE "config attribute [Playbill],font=Playbill" 00020 PRINT FIELDS "10,1,80/C 1000,[PlayBill]": Rpt$("|",80) 00021 PRINT FIELDS "11,1,80/C 1000,[PlayBill]": Rpt$("-",80) 00029 EXECUTE 'config attribute [3of9],font=3 of 9...
by GomezL
Sat Jul 13, 2019 12:02 pm
Forum: General Development
Topic: System call to Atlantis word processor hanging
Replies: 29
Views: 54338

Re: System call to Atlantis word processor hanging

When I have a problem shelling to a program, I usually start by testing it at a command line. I make a small "Test.cmd" script (I call it something like t.cmd) The script will contain the actual command that you want to run In your case: c:\Program Files\atlantis\atlantis.exe /pt C:\BRLOCA...
by GomezL
Mon May 20, 2019 4:32 am
Forum: General Development
Topic: BREAK Command Features
Replies: 9
Views: 19493

Re: BREAK Command Features

I am sure that a good function should never close all open files!
by GomezL
Sun May 19, 2019 5:51 pm
Forum: General Development
Topic: BREAK Command Features
Replies: 9
Views: 19493

Re: BREAK Command Features

I think the user-defined function will be fantastic! I also give my +1 to file handle changes. As libraries start to call libraries, and sometimes those libraries are other peoples code (like screenio), I am finding that file handles that were set by the "Main Program" are being replaced b...
by GomezL
Mon Apr 29, 2019 11:45 am
Forum: General Development
Topic: missing accuracy
Replies: 6
Views: 15749

Re: missing accuracy

I updated the BR Wiki with information about Floating Point Numbers:

http://brwiki2.brulescorp.com/index.php ... nt_Numbers

Ultimately, you get 16 digits of preceision.
by GomezL
Fri Sep 07, 2018 3:54 pm
Forum: General Development
Topic: web services
Replies: 9
Views: 20517

Re: web services

This looked nifty, I decided to assign Line #'s and give it a try. Fnepochtime is probably simple, but I didn't try to figure it out. PRINT "Bitcoin Price:";Fngetprice("BTC",0,Time$,"") You can remove line 60, see how quickly it returns a value, but the program loops an...
by GomezL
Thu Sep 07, 2017 7:00 pm
Forum: General Development
Topic: Windows 10 BR! Server
Replies: 14
Views: 25237

Re: Windows 10 BR! Server

I don't know if this will help, but from Windows 10 run * Secpol.msc This will load the local security policy. Local Policies --> User Right Assignment --> Allow log on Locally I think the bad news is that on my system, Administrators, Users & Guest are on the list. On the other hand, if you are...
by GomezL
Thu Aug 31, 2017 10:31 am
Forum: General Development
Topic: Parameterized SQL queires from BR
Replies: 6
Views: 17233

Re: Parameterized SQL queires from BR

Good to know about the login information!

With your additional feedback I noticed that your write statement has a "Form Statement"

Code: Select all

write #sqlquery, using 'FORM C 10,L': str$(i), i
With SQL, you just write the fields without any FORM Statement:

Code: Select all

write #sqlquery: str$(i), i
by GomezL
Wed Aug 30, 2017 5:45 pm
Forum: General Development
Topic: Parameterized SQL queires from BR
Replies: 6
Views: 17233

Re: Parameterized SQL queires from BR

Using SYSERR$ should help to return the last actual SQL error. You might need to enable logging in BR since sometimes you get multiple errors. This is the connection string that I use: CONFIG database SQL-Query connectstring="DRIVER=SQL Server;Initial Catalog=vExchange;Persist Security Info=Tru...