Search found 255 matches

by GomezL
Thu Jun 20, 2013 9:02 am
Forum: General Development
Topic: Linux client server
Replies: 5
Views: 9597

PS: If you want it to work like it did before

Enhance WBCONFIG.SYS with:

SPOOLPATH .
WORKPATH .
by GomezL
Thu Jun 20, 2013 8:59 am
Forum: General Development
Topic: Linux client server
Replies: 5
Views: 9597

We found the same problem, but decided that we wanted to have better control over the folder. We execute the following upon startup EXECUTE "CONFIG SPOOLPATH "&SERVER_PATH$ EXECUTE "CONFIG SPOOLPATH @::"&CLIENT_PATH$ As long as this happens early during startup (WBCONFIG....
by GomezL
Fri Apr 05, 2013 8:50 am
Forum: Advanced Concepts
Topic: delayed write failure
Replies: 9
Views: 21980

We used to be a strong Netware supporter, but they never got their Windows Driver to work properly. As you mentioned, disabling the Cache seems to work fairly well. Client Server is a game changer, it will require either a Linux or a Windows Server, but we experience 30 to 100 times performance impr...
by GomezL
Sun Mar 17, 2013 3:36 am
Forum: Advanced Concepts
Topic: Listviews of big files are taking too long to load
Replies: 10
Views: 21932

You just answered your own question!

Make a new field "LEGACY_INVENTORY", or something like that. Then you can filter those records out (Sales Analysis should still work).

You can add an index by this field, then the list view will only Display Active_Inventory.
by GomezL
Sat Mar 16, 2013 6:01 pm
Forum: Advanced Concepts
Topic: Listviews of big files are taking too long to load
Replies: 10
Views: 21932

My first question is "What is unacceptably slow?". Ultimately, it's all relative. My second question, If this is a multi-user application, are you using client server? I would expect 90K entries to take about 14 seconds to load in Client Server Mode. The same query would take 125 seconds f...
by GomezL
Wed Feb 27, 2013 10:29 am
Forum: Advanced Concepts
Topic: Windows 8
Replies: 4
Views: 14308

I am using 4.20m without any issues. These problems are often brconfig.sys issues. I usually make a small BR installation with Bare minimum config options. Then I start adding back all the config settings. Also, try running the Debug version of BR, it might cause a crash dump that can help diagnose ...
by GomezL
Wed Feb 06, 2013 10:25 am
Forum: Advanced Concepts
Topic: 4.3 SQL
Replies: 0
Views: 9839

4.3 SQL

I started playing with SQL in BR 4.3, and am wondering what to do about "Dates" in SQL. In FileIO, you typically use READ # ... :mat table_data$,mat table_data This works great in BR where we only have 2 data types. We have used both Char & Numeric Dates, so depending on the situation,...
by GomezL
Fri Jan 04, 2013 4:34 pm
Forum: General Development
Topic: ODBC
Replies: 3
Views: 6263

Version is specific to the ODBC drivers. It's somewhat hard to check version, but in the ODBC control panel, there is a Drivers Tab, this can help Check the version. Crystal is sometimes "Ornery", so make sure your queries work in MS-Access before you attempt to use Crystal. (MS-Access is ...
by GomezL
Fri Jan 04, 2013 11:02 am
Forum: General Development
Topic: ODBC
Replies: 3
Views: 6263

PROBLEM: User is attempting to use crystal reports with ODBC the users gets error DATABASE CONNECTOR ERROR: "22003:[ADS][BRODBCDRIVER]OUT OF RANGE [DATABASE VENDOR CODE:1011] when they attempt to access a table. RESOLUTION: In Crystal Reports, there are several ways to connect. **MAKE SURE ODBC...
by GomezL
Sun Dec 02, 2012 1:05 pm
Forum: General Development
Topic: Client-Server error
Replies: 1
Views: 4557

15 Clients seems like a small number, but we have found problems when running with Windows 2003 Server. It's actually the number of sessions and not workstations/users.

Windows 2008 Server does not seem to have these limits.
by GomezL
Fri Oct 12, 2012 5:48 am
Forum: Advanced Concepts
Topic: Accessing 3rd party data via their ODBC driver
Replies: 1
Views: 10709

On the CD, there is a sample program in my section. CLSINC\CSV\CSV_EXPORT.WB My goal was to make this both an example of creating a CSV file using the "Mat2Str" command, as well as a usable example of using BR 4.3 to connect to an ODBC source. In my Example, I used an MS-Access Table, but ...
by GomezL
Wed Sep 12, 2012 7:51 am
Forum: General Development
Topic: BR 4.3 EXE Statement - (Much Faster!)
Replies: 3
Views: 6623

BR 4.3 EXE Statement - (Much Faster!)

In BR 4.3, the EXE statement is now much faster than in BR 4.2 EXE in Line 30 uses the “*”, and Line 60 does not. In BR 4.2, Line 30 took over 2.365 seconds. In BR 4.2, Line 60 took over .0338 seconds. In BR 4.3, they are not only both similar in performance, but quite a bit faster! Stats Descending...
by GomezL
Thu Aug 30, 2012 4:48 am
Forum: Printing
Topic: Easy Precision
Replies: 2
Views: 11783

This is a Printing Command: PRINTER NWP [ROWCOL(ROW,COL)], "\E&aROWrCOLC" ! Set Position in Rows and Columns, Vertical, Horizontal. Use +- for Relative PRINTER PCL [ROWCOL(ROW,COL)], "\E&aROWrCOLC" ! Set Position in Rows and Columns, Vertical, Horizontal. Use +- for Relat...
by GomezL
Tue Aug 07, 2012 1:45 pm
Forum: Advanced Concepts
Topic: HTTP Control File
Replies: 0
Views: 9841

HTTP Control File

I have created some simple HTTP programs, both as CLIENT & SERVER. My next step is to use a "CONTROL FILE" CONTROL=display-filename I assume that this would look something like : NAME=http://www.state.nj.us/dobi/bankwebinfo.htm,CONTROL=Control.txt, http=client Does anyone have a sample...
by GomezL
Fri Jun 08, 2012 11:55 am
Forum: General Development
Topic: Repositioning record in display file
Replies: 3
Views: 6593

We often read a display file into an array, and the use the array for "Random Access".

We also sometime "Cache the Data" so that we have the "Last Few Records" stored in memory.