Browse problem
Nancy Palmquist
nancy.palmquist at vss3.com
Tue Feb 23 09:31:23 PST 2021
Richard,
I have one very big question with regard to this programming. Do you
define variables?
For example, have you set aa(79,*), ab(79,*), ac(79,*)
If you always use them for browses then the size should be set. Might
need more than 76 but not by much.
If you just use dummy variables and long variables without definition,
filePro will use a new memory location each time the variable is used,
instead of reusing the space first used. I ran across this years ago
when a report I was running always crashed at about the same distance
into the count each time. I was lucky and it did a core dump. When I
looked at the core dump, I kept seeing the value of this one string (it
was something like an 80 character string that was being printed on a
form) everywhere in the core dump. It had filled up the allocated
memory and then crashed the report.
From that I learned it is very important to always, with rare and
considered exception, assign lengths to variables. FilePro does not
make that easy, since it does not collect the assignments from auto
tables but it does warn you when a variable is double assigned.
I know you have been doing this a very long time Richard, but could
something like this be affecting this processing.
Remember, you allocate memory for AUTO TABLES, INPUT/REPORT, FORM/CALL
tables with the Token settings. This includes space for variables.
Also would add this while I am talking about variables and space. I have
found that I like to reserve 2 letter variables for what needs to appear
on Screens or reports and use long variables for everything else. I
know you think you are running out of variable space, but I am finding
that very difficult to accept. I have some very complex and long
programming with many tables, etc. and the only problem I have run into
is the limit on the number of edits you may have. 200 by the way which
is the sum of global edits and local edits. If you have more, filepro
does some very strange things you will think are programming issues but
are caused by some conflict with edits and memory. Trust me on this
one. It is not easy to trace to the source. One of things to check
when you are doing complex programming in filePro and you are having issues.
Nancy
On 2/19/2021 2:41 PM, Richard Kreiss via Filepro-list wrote:
> Again thank to everyone who responded.
>
> However, no one addressed the main issue I am having. The browse window comes up but no records appear. I copied the processing out to another file and everything works as it should.
>
> This is in the file which had issues with the long variables not able to accept a value. I am not sure if this is a memory issue or something else. I added the busybox option to see if the records are being accessed.
>
> I am going to added an @key function and a GOTO to test the browse. Again there are only 6 records that should appear. The file has only 10 records total.
>
> Browse code:
>
> 63 ------- - - - - - - - - - - - - - - - -
> ◄ If:
> Then: AA="(brw=10 xkey=XS show=keep pop=0 fill=asc,top)"
> 64 ------- - - - - - - - - - - - - - - - -
> ◄ If:
> Then: AB="[ Card Type Card Number Exp Date Security Key]"
> 65 ------- - - - - - - - - - - - - - - - -
> ◄ If:
> Then: AC="*1 *3 *2 *4"
> 66 ------- - - - - - - - - - - - - - - - -
> ◄ If:
> Then: lv="a"
> 68 ------- - - - - - - - - - - - - - - - -
> busy ◄ If:
> Then: Busybox "Looking for Records"
> 69 ------- - - - - - - - - - - - - - - - -
> ◄ If: busy
> Then: MSGBOX "Busybox is running"
> 70 ------- - - - - - - - - - - - - - - - -
> lokcard◄ If:
> Then: lookup test = testccnumbersforcardworks k=lv i=A -NG b=(AA&AB&AC)
> 71 ------- - - - - - - - - - - - - - - - -
> ◄ If: @bk = "S"
> Then: CCnumber=test(3);display;CLEARB;MSGBOX "The letter S was Pressed"
> 72 ------- - - - - - - - - - - - - - - - -
> ◄ If: @sk = "BRKY" or @bk= "X" or @bk = "s"
> Then: CLEARB
> 73 ------- - - - - - - - - - - - - - - - -
> ◄ If: @sk = "BRKY" or @bk = "X" or @bk = "S"
> Then: Exit
> 74 ------- - - - - - - - - - - - - - - - -
> ◄ If: @bk ne ""
> Then: MSGBOX "The key Was pressed"<@bk<"at line"<@li
>
>
> Thisa is the code that does not display any records when run from ther transaction file in a called process. It does display the records when run form an @keyT option in my test file. The processing was saved and loaded into the test file input processing. The file is names "TEST".
>
>
>> 2/16/2021 2:32 PM, Richard Kreiss via Filepro-list wrote:
>>> I have a new browse that is not showing any records in the processing table
>> that has the code. If I move the same processing to a test file al of the browse
>> records appear. There are only 6 records in the file and the index has all 6. I am
>> only using this to test the programming as I need on of the values from the
>> browse record. I do not want to hard code the value as I need to use at least 4
>> of the values which are 15 or 16 number long. At my age I can't remember these
>> numbers and it was easier to program the browse.
>>> The browse does not have a drop in it as I need all of the records. As I
>> indicated nothing appears in the browse window in the primary program but the
>> records do appear in the test file when using an @key command.
>>> I am running this on both filePro (windows) 5.8.03 and 6.0.02. the problem
>> exists with both versions.
>>> By the way this is the same processing that had the issue with the long
>> variables.
>>> Richard Kreiss
>>> GCC Consulting
>>>
>>>
>>> -------------- next part -------------- A non-text attachment was
>>> scrubbed...
>>> Name: winmail.dat
>>> Type: application/ms-tnef
>>> Size: 14591 bytes
>>> Desc: not available
>>> URL:
>>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210
>>> 216/b752863a/attachment.bin>
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>> --
>> Nancy Palmquist MOS & filePro Training Available
>> Virtual Software Systems Web Based Training and Consulting
>> PHONE: (412) 835-9417 Web site:http://www.vss3.com
>>
>> -------------- next part --------------
>> An HTML attachment was scrubbed...
>> URL:<http://mailman.celestial.com/pipermail/filepro-
>> list/attachments/20210217/8ea03a81/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: winmail.dat
> Type: application/ms-tnef
> Size: 15083 bytes
> Desc: not available
> URL:<http://mailman.celestial.com/pipermail/filepro-list/attachments/20210219/70126f67/attachment.bin>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
On 2/19/2021 5:47 PM, Bruce Easton via Filepro-list wrote:
> Since you say the browse box is appearing, but no records appear, I
> would check that dummy "AC" is not already being used for another
> purpose, thereby overriding part of your browse definition.
>
> Also, does the clerk call for this indicate a qualifier? And if so, are
> you sure you're looking at the right data set for the file
>
>
>
>
>
>
> On 2/19/21 2:41 PM, Richard Kreiss via Filepro-list wrote:
>> Again thank to everyone who responded.
>>
>> However, no one addressed the main issue I am having. The browse window comes up but no records appear. I copied the processing out to another file and everything works as it should.
>>
>> This is in the file which had issues with the long variables not able to accept a value. I am not sure if this is a memory issue or something else. I added the busybox option to see if the records are being accessed.
>>
>> I am going to added an @key function and a GOTO to test the browse. Again there are only 6 records that should appear. The file has only 10 records total.
>>
>> Browse code:
>>
>> 63 ------- - - - - - - - - - - - - - - - -
>> ◄ If:
>> Then: AA="(brw=10 xkey=XS show=keep pop=0 fill=asc,top)"
>> 64 ------- - - - - - - - - - - - - - - - -
>> ◄ If:
>> Then: AB="[ Card Type Card Number Exp Date Security Key]"
>> 65 ------- - - - - - - - - - - - - - - - -
>> ◄ If:
>> Then: AC="*1 *3 *2 *4"
>> 66 ------- - - - - - - - - - - - - - - - -
>> ◄ If:
>> Then: lv="a"
>> 68 ------- - - - - - - - - - - - - - - - -
>> busy ◄ If:
>> Then: Busybox "Looking for Records"
>> 69 ------- - - - - - - - - - - - - - - - -
>> ◄ If: busy
>> Then: MSGBOX "Busybox is running"
>> 70 ------- - - - - - - - - - - - - - - - -
>> lokcard◄ If:
>> Then: lookup test = testccnumbersforcardworks k=lv i=A -NG b=(AA&AB&AC)
>> 71 ------- - - - - - - - - - - - - - - - -
>> ◄ If: @bk = "S"
>> Then: CCnumber=test(3);display;CLEARB;MSGBOX "The letter S was Pressed"
>> 72 ------- - - - - - - - - - - - - - - - -
>> ◄ If: @sk = "BRKY" or @bk= "X" or @bk = "s"
>> Then: CLEARB
>> 73 ------- - - - - - - - - - - - - - - - -
>> ◄ If: @sk = "BRKY" or @bk = "X" or @bk = "S"
>> Then: Exit
>> 74 ------- - - - - - - - - - - - - - - - -
>> ◄ If: @bk ne ""
>> Then: MSGBOX "The key Was pressed"<@bk<"at line"<@li
>>
>>
>> Thisa is the code that does not display any records when run from ther transaction file in a called process. It does display the records when run form an @keyT option in my test file. The processing was saved and loaded into the test file input processing. The file is names "TEST".
>>
>>
>>> 2/16/2021 2:32 PM, Richard Kreiss via Filepro-list wrote:
>>>> I have a new browse that is not showing any records in the processing table
>>> that has the code. If I move the same processing to a test file al of the browse
>>> records appear. There are only 6 records in the file and the index has all 6. I am
>>> only using this to test the programming as I need on of the values from the
>>> browse record. I do not want to hard code the value as I need to use at least 4
>>> of the values which are 15 or 16 number long. At my age I can't remember these
>>> numbers and it was easier to program the browse.
>>>> The browse does not have a drop in it as I need all of the records. As I
>>> indicated nothing appears in the browse window in the primary program but the
>>> records do appear in the test file when using an @key command.
>>>> I am running this on both filePro (windows) 5.8.03 and 6.0.02. the problem
>>> exists with both versions.
>>>> By the way this is the same processing that had the issue with the long
>>> variables.
>>>>
>>>>
>>>>
>>>> Richard Kreiss
>>>> GCC Consulting
>>>>
>>>>
>>>> -------------- next part -------------- A non-text attachment was
>>>> scrubbed...
>>>> Name: winmail.dat
>>>> Type: application/ms-tnef
>>>> Size: 14591 bytes
>>>> Desc: not available
>>>> URL:
>>>> <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210
>>>> 216/b752863a/attachment.bin>
>>>> _______________________________________________
>>>> Filepro-list mailing list
>>>> Filepro-list at lists.celestial.com
>>>> Subscribe/Unsubscribe/Subscription Changes
>>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>> --
>>> Nancy Palmquist MOS & filePro Training Available
>>> Virtual Software Systems Web Based Training and Consulting
>>> PHONE: (412) 835-9417 Web site: http://www.vss3.com
>>>
>>> -------------- next part --------------
>>> An HTML attachment was scrubbed...
>>> URL: <http://mailman.celestial.com/pipermail/filepro-
>>> list/attachments/20210217/8ea03a81/attachment.html>
>>> _______________________________________________
>>> Filepro-list mailing list
>>> Filepro-list at lists.celestial.com
>>> Subscribe/Unsubscribe/Subscription Changes
>>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>> -------------- next part --------------
>> A non-text attachment was scrubbed...
>> Name: winmail.dat
>> Type: application/ms-tnef
>> Size: 15083 bytes
>> Desc: not available
>> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210219/70126f67/attachment.bin>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>
> --
> Bruce Easton
> STN, Inc.
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
--
Nancy Palmquist MOS & filePro Training Available
Virtual Software Systems Web Based Training and Consulting
PHONE: (412) 835-9417 Web site: http://www.vss3.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20210223/63d0ef6e/attachment.html>
More information about the Filepro-list
mailing list