Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table buffering error
Message
 
To
06/11/2001 17:30:52
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00577587
Message ID:
00578267
Views:
35
Tried another ID in the command button and it updated both of it's products.
This is test data, a copy of real data and most orders are only 1 or 2 items.
BTW - The items are types of trees.
The tally was 2 and my message box came up twice.
I'll make new invoice with even more, but it looks like the scan works.

I'll stay here for as long as you'll put up with me.
Out of curisoty I decided to visit hnjinc.com to see what kind of business you were, but your site was down or not at all. I did a search for HNJ and found "Holy Name Of Jesus", but I don't think He's incorporated.



>Don't worry about it. How late ya workin'? I'll be here for a while.
>
>So, where are we at? Do you have a commandButton with the code I provided that works? It has a hard-coded invoice_id? I would try it with another invoice. Choose one that has several line items on it.
>
>
>>I'm realy starting to get frustrated at myself, so I know you have to be a little bothered. It turns out that the Invoice Number on the screen is not the invoice ID. I knew this but forgot. The ID is 2420.
>>
>>However, that should not have effected the stuff in the forms that was not hard coded. The correct record was displayed so the ID should have been right.
>>
>>I went back to the earlier code you told me to try in the commnand window with the correct ID.
>>
>>lnInvoice_ID = 2420
>>Select * from InvoiceDetail Where Invoice_ID = lnInvoice_ID ;
>>into cursor InvLinesCursor
>>browse
>>
>>That pulls up the InvLinesCursor successfully and shows me the one record. This invoice has only one product.
>>It does have the correct produt ID (94).
>>
>>I have gone back to the command button that had the ID hard coded and it updates the product file OK and I get my message box telling me it should be updating and the Tally is 1.
>>
>>Sorry for sending you down the wrong path.
>>
>>
___________________________
Kenneth Wonderley
http://www.wonderley.com


...the fruit of the Spirit is love, joy, peace, patience, kindness, goodness, faithfulness, gentleness and self-control.
Galatians 5:22 & 23
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform