<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
<p>What is the error?</p>
<p>Your lookup commands says to push error upon fail ( -e )</p>
<p>Have you tried to rebuild free chain?</p>
<p>Have you tried to rebuild index files?</p>
<p>If file is locked, you may get an error since it cannot open a
free record and you are<br>
implicitly asking for an error to be pushed.</p>
<p>I think fp introduced methods to check if error was due to record
locking or something of that<br>
effect to provide a more efficient way to handle such situations.</p>
<p>Also, I personally never liked the use of -e, it does not exit
gracefully, it is like a "no mas" scenario <br>
in a middle of a boxing match. <br>
</p>
<p>Hard to offer you a more direct suggestion without supporting
info to base it on.<br>
</p>
<p><br>
</p>
<div class="moz-cite-prefix">On 8/24/21 3:23 PM, Jeff Bandle via
Filepro-list wrote:<br>
</div>
<blockquote type="cite"
cite="mid:02a201d7991d$91005b60$b3011220$@gmail.com">
<pre class="moz-quote-pre" wrap="">Ok. The following is the code that I think is the culprit as it is handling
the reversal of an invoice and that is where it blew up. It is in a piece
of code called REVERSIT.PRC that is called from GFSALES/KEYR.prc code. That
code handles the user entering R while looking at an invoice to
reverse/refund the amount. The code with line numbers is as follows:
809 INVHIST:'inventory history for items that are not sets::
810 ::lookup his = gfinvhis r=free -e:
811 : 'item code:his(1)=xx:
812 : 'today's date:his(2)=orddate:
813 : 'time:his(3)=@tm:
814 : 'action (sold):his(4)="reversed sale on
inv. #"<10:
815 : 'quantity:his(5)=qt:
816 ::his(6)=inv(16):
817 ::inv(7)=10:
818 ::write his:
819 ::return:
It appears we are getting a free record from the inventory hist table and
fill it in with some info and then on line 816 filling his(6) with a value
from inv(16). I'm having trouble figuring out what inv points to..either an
inventory record or an invoice record, I think.
Any thoughts? Thanks for the response.
Cheers,
Jeff
-----Original Message-----
From: <a class="moz-txt-link-abbreviated" href="mailto:mschw@athenet.net">mschw@athenet.net</a> <a class="moz-txt-link-rfc2396E" href="mailto:mschw@athenet.net"><mschw@athenet.net></a>
Sent: Tuesday, August 24, 2021 1:37 PM
To: 'Jeff Bandle' <a class="moz-txt-link-rfc2396E" href="mailto:jeffbandle@gmail.com"><jeffbandle@gmail.com></a>
Subject: RE: Newbie advice
Hi Jeff:
Line 816 is trying to do something with a gfinvhis (filePro database
name) record that has not been looked up yet. I'm guessing that gfinvhis
is probably an invoice history file.
If you can send us line 816, and perhaps a line or two before that, we
may be able to give you more help.
Line 816 should tell you the name of the aliased lookup. Line 816 might
say, "IF: HISTORY(3)=2", and not have the word gfinvhis in it at all. By
aliasing, I mean to look for a line that says something like "lookup
HISTORY=gfinvhis". That's why we need you to find the lookup line that
looks up the gfinvhis file using the alias name in line 816.
Hope that helps!
Mike Schwartz
-----Original Message-----
From: Filepro-list
<a class="moz-txt-link-rfc2396E" href="mailto:filepro-list-bounces+mschw=athenet.net@lists.celestial.com"><filepro-list-bounces+mschw=athenet.net@lists.celestial.com></a> On Behalf Of
Jeff Bandle via Filepro-list
Sent: Sunday, August 22, 2021 8:11 PM
To: <a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subject: Re: Newbie advice
Hi All -
A followup to my original 2+ month old post. I first want to thank the
many folks who responded and reached out to me to help me start up the
FilePro learning curve. I still have a way to go but I feel I am making
good progress and I've gotten to the point where I've been able to start
making a few simple fixes/enhancements to the FlowreSoft application. I got
the Stuart L Werner Developer's Reference from the STN folks and that has
been a great help in answering questions and providing insight as I start to
tackle more difficult problems.
Given that, I do have a question. In FlowerSoft, there is an operation
where you can reverse the charge on an invoice if that order gets cancelled
by the original customer. However, that operation is failing with the
following abort..I'm linking a screenshot as a reference:
Any hints/recommendations on how to proceed debugging this? I've looked at
the .prc code in the gfinvhis folder but I'm not seeing anything referencing
the index.P at line 816 anywhere. What I've been able to figure out is
gfinvhis keeps track of the history of each invoice and I've seen a lot of
code make references to get a free value from the index when a new order is
being processed. This makes sense to me as you would need a new entry for a
new invoice. However, in this case, I think we are working on an existing
invoice.
I want to figure this out but not sure how to proceed after what I think is
the obvious..maybe not.
Anyway, any ideas would be a great help.
Thanks and cheers,
Jeff
From: Jeff Bandle <a class="moz-txt-link-rfc2396E" href="mailto:jeffbandle@gmail.com"><jeffbandle@gmail.com></a>
Sent: Monday, June 7, 2021 7:59 PM
To: '<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>' <a class="moz-txt-link-rfc2396E" href="mailto:Filepro-list@lists.celestial.com"><Filepro-list@lists.celestial.com></a>
Subject: Newbie advice
Hi All -
Long time lurker on this list but I'm compelled to ask for some advice.
A few weeks ago Nancy posted a notice that a long time FilePro programmer,
George Simon had unexpectedly passed away. I knew George from working with
him the last 10 years, assisting him on the FlowerSoft Silver application
used by quite a few independent flower shops throughout the US. I didn't do
any FilePro development but helped by providing standalone applications
George called to handle things such as decrypting wire orders and processing
credit card transactions.
George's sudden passing has left these shops in an unsupported situation
and I've agreed to see if I can take this on in a very limited manner to at
least buy time for these shops to move onto another solution. I've been
working with Nancy and the fptech folks and have gotten a 6.0 license for
the newest FilePro development environment. In researching the installed
FlowerSoft software at several difference locations, it looks like George
included the source code with the executable bits.
What I'm asking is advice/guidance on the best way to proceed with ramping
up on FilePro so I can at least try to diagnose issues if they were
reported. George and I had talked about me helping him and he was going to
provide guidance but sadly that never happened before his passing. A
complicating factor is George was on FilePro 5.0 and I guess there are
potential conflicts if I use the 6.0 version that I will have to watch out
for.
I apologize up front if this is too vague. I've programmed in C, C++ and
C# along with MySQL and MS SQL, so I have a fair amount of programming
experience. I've looked at the training materials available on the fptech
site but what I've seen seems to be geared for starting from scratch, not
how to support an existing project.
Thanks in advance for any tips. I would like to have a setup where I make
changes on my local development machine and then role those changes to the
customer system, but maybe that isn't a good way to do it. Any thoughts on
a recommendation for setting up a support "lab" would be very helpful.
Best regards,
Jeff Bandle
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
<a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96314c92/attachment.html"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96
314c92/attachment.html></a>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.jpg
Type: image/jpeg
Size: 68868 bytes
Desc: not available
URL:
<a class="moz-txt-link-rfc2396E" href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96314c92/attachment.jpg"><http://mailman.celestial.com/pipermail/filepro-list/attachments/20210822/96
314c92/attachment.jpg></a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
_______________________________________________
Filepro-list mailing list
<a class="moz-txt-link-abbreviated" href="mailto:Filepro-list@lists.celestial.com">Filepro-list@lists.celestial.com</a>
Subscribe/Unsubscribe/Subscription Changes
<a class="moz-txt-link-freetext" href="http://mailman.celestial.com/mailman/listinfo/filepro-list">http://mailman.celestial.com/mailman/listinfo/filepro-list</a>
</pre>
</blockquote>
<div class="moz-signature">-- <br>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
<title></title>
Jose Lerebours<br>
(954) 559-7186<br>
<theader> </theader>
<table>
<tbody>
<tr>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.asisuites.com">https://www.asisuites.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="http://www.shipsuites.com">http://www.shipsuites.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.cargosaas.com">https://www.cargosaas.com</a></td>
<td style="vertical-align: top;"><a class="moz-txt-link-freetext" href="https://www.helpsuites.com">https://www.helpsuites.com</a></td>
</tr>
<tr>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">ASI Suites</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">Ship Suites</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">CargoSaaS</th>
<th style="background-color: #3498db; color: #ffffff;
text-align: center;">Help Suites</th>
</tr>
</tbody><tbody>
<tr>
<td style="vertical-align: top;">A robust, scalable &
fully integrated application suitable for the most
demanding business environment!</td>
<td style="vertical-align: top;">A load board designed to
give you the flexibility to manage traffic from/to your
warehouse.
<p>B2B UX/UI to allow your trucking partners pick the day
and time they are coming in thus preventing backlog in
your yard.</p>
</td>
<td style="vertical-align: top;">TMS SaaS aimed to transform
the way you do Transportation.
<p>Designed with 3PL and Brokers in mind, this application
has it all, from RFQ to POD.</p>
<p>Need someone to handle your shipping? Give us a call,
we offer very competitive rates!</p>
</td>
<td style="vertical-align: top;">A friendly way to manage
open & closed issues or requests for assistance.</td>
</tr>
</tbody>
</table>
<table padding="0" border="0">
<tbody>
<tr>
<td> </td>
</tr>
<tr>
<td style="background-color: #566573; color: #ffffff;
padding: 12px; font-weight: bolder;">WANTED! If you are
looking for ready to roll out web based application, give
us a call and lets talk about great business opportunity
with no out of pocket investment.</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>