Search found 216 matches

by gtisdale
Tue Mar 26, 2013 10:59 am
Forum: Advanced Concepts
Topic: Custom Array Sorting
Replies: 7
Views: 17482

By "Custom order" do you mean other than ASCII hiarchy? or do you mean a subset of positions within each string? For example do you want all item that contain an "X" regardless of where it exxists in the string to sort before "A" and after "?". If so you would...
by gtisdale
Tue Mar 26, 2013 9:56 am
Forum: Advanced Concepts
Topic: Custom Array Sorting
Replies: 7
Views: 17482

FNSNAP fnsrtary or fnsortarray 60320 DEF LIBRARY FNSRTARY(MAT L$;MAT M$,DESENDING,HEADER,FOOTER) !: ! Sorts MAT L$ in ascending order !: ! OPtionally based on MAT M$ !: ! In Descending order if DESending !: ! starting down from top to allow for a HEADER !: ! stopping before the bottom to allow for a...
by gtisdale
Sat Mar 16, 2013 4:23 pm
Forum: Advanced Concepts
Topic: Listviews of big files are taking too long to load
Replies: 10
Views: 21355

I am not using ScreenIO so I'm not sure that I can be helpful. However, when I have this situation, on manufacturing client in particular stands out, I have set a few fields in the file that can be used for "pre-editing" and speed up the process. For example, if a part is obsolete I mark i...
by gtisdale
Sun Feb 24, 2013 8:26 am
Forum: Advanced Concepts
Topic: XML
Replies: 2
Views: 17626

The XMLLIB that I posted earlier had a capitalization problem with one of the parameters which casued it not to work with a SCHEMA.


schemalocation should have been schemaLocation.

The attched file corrects this problem.

The file expects to be renamed to XMLLIB.dll

FNGeorge
by gtisdale
Sat Feb 09, 2013 7:15 pm
Forum: Advanced Concepts
Topic: XML
Replies: 2
Views: 17626

Library for the XML file creation.

Rename it to .DLL from .br

FNGeorge
by gtisdale
Sat Feb 09, 2013 7:10 pm
Forum: Advanced Concepts
Topic: XML
Replies: 2
Views: 17626

XML

More and more I am running into states equesting or requiring payroll tax documents in XML format. So I need to be able to create an XML document that is "Well Formed" with various levels of nesting. In doing this I have come up with a few librry functions that will create the file and kee...
by gtisdale
Thu Jul 12, 2012 1:56 pm
Forum: General Development
Topic: SYSTEM call
Replies: 4
Views: 6545

Maybe... It depends on what you want to do. For example, I often load and run Excel and Word and a few other programs through a system call. I used to either put a short-cut .lnk file in my WB directory or crete a batch file to call. I now use a registry reader to determin the installed location of ...
by gtisdale
Fri Jun 08, 2012 11:14 am
Forum: General Development
Topic: Repositioning record in display file
Replies: 3
Views: 6563

Not with LINPUT and a DISPLAY file. Becasue every line is a different length it is not easy to reposition backwards. However, you could write a function that would do this if you kept track of how many lines you have read since starting to read the file. Let assume that the current line is XL and yo...
by gtisdale
Wed Jun 06, 2012 3:24 pm
Forum: General Development
Topic: 4.3 SQL Interface
Replies: 12
Views: 13270

No, I tried that to start with.

Just the values as ? worked (assuming I used the same number of "?"'s as I did values) Thanks Steve for pointing that out!

FNGeorge
by gtisdale
Wed Jun 06, 2012 1:52 pm
Forum: General Development
Topic: 4.3 SQL Interface
Replies: 12
Views: 13270

Put “?” in the OPEN SQL statement then those are replaced by the parameters that follow the WRITE in the order that they appear? If I want to make multiple WRITES can I then just put in more WRITE statements with the correct parameters following. SQL$=”INSERT into ACCOUNT ([fdAccount],[FDType]) VALU...
by gtisdale
Wed Jun 06, 2012 8:11 am
Forum: General Development
Topic: 4.3 SQL Interface
Replies: 12
Views: 13270

The dissappearing "SQL" still exists in 4.30beta-yg.
by gtisdale
Wed Jun 06, 2012 5:32 am
Forum: General Development
Topic: 4.3 SQL Interface
Replies: 12
Views: 13270

I am getting closer. Thank you for the help Steve and Luis. Next question related to adding information to the database. If an INSERT statement is processed in the SQL$ phrase does this happen on the WRITE statement? If so then it seems that the variables being written to the database should be list...
by gtisdale
Sun Jun 03, 2012 3:28 pm
Forum: General Development
Topic: 4.3 SQL Interface
Replies: 12
Views: 13270

4.3 SQL Interface

I'm trying to update my old VB interface to an ACCESS GL to the new BR4.30 SQL interface becasue I need to be able to process the link on the Server side, the current VB interface is on the Client side. The issue that I do not understand is the function of the various commands There is a CONFIG comm...
by gtisdale
Mon May 28, 2012 6:34 pm
Forum: General Development
Topic: [BR_forum] plugin test
Replies: 15
Views: 20555

[BR_forum] plugin test

Worked fine for me on a Vista Professional running IE9 on a 32bit machine. George L. Tisdale, CPA Tisdale CPA 75 Junction Square Drive Concord, MA 01742 (978) 369-5585 IRS Circular 230 Notice: "To ensure compliance with requirements imposed by the IRS, we inform you that any U.S. tax advice con...
by gtisdale
Thu May 17, 2012 11:24 am
Forum: General Development
Topic: Font substitutions
Replies: 3
Views: 5745

Printer.sys is available in the DLL_DIST/PRINTING directory of the ADS FTP site.

Posting to this site is restricted so Gordon would control any updates tothe file.

FNGeorge