Search results for query: *

SOLVED-- Thanks to Mark and Olaf for your responses and thanks for suggesting that I learn more about TABLEUPDATE(), OLDVAL(), AND CURVAL(). it helped a lot. Ultimately, the problem was the fact that my field name for the logical field was "order". I assume that since this is a 'command word'...

Clearly, my knowledge of the inner workings of the update process is limited. But the fact that it is working for other data types ie. Character, Numeric and Date but not Logical is what baffles me. With my limited knowledge, I don't see a difference between them with respect to how they would...

I have a form with a grid that contains 6 columns. Each of the 6 column's ControlSource is from a view ('vParts_used')created with view designer. The parent table for this is 'Parts_used'. In the designer, the keyid is checked and all fields are checked to be updated and "Send SQL Updates" is...

I have to remake all of the forms, most of the VFP code is cut and paste with very little change. Again, I am not sure what the IAS part did but feel very confident that I don't need it. So far all is working well. Thanks to all of you.

Tamar, That is it. Yea, I'm not sure what it is. That's above my knowledge level. Regardless, I need to get free of it and stick with VFP on it's own. Thanks Jimmy

Mike, I understand your curiosity. The original program was written by a local software company over 20 years ago. When we purchased it, we purchased the program, source code, copy of VFP7 and of course all rights to it. I have been modifying it over the decades as my company's needs changed...

Excellent explanation as to why this was causing trouble and a lesson to all. Removed the ALLTRIM() and all works well now. Back to regrowing my hair. As to why it worked in VFP7 and not in VFP9... Well, I'm sure that's well above my level and I am not going to ponder it. Thanks to all Jimmy

Thank you, Olaf, for your reply. As usual your response was educational and in this case got me on the right track. It seemed that the original detail table's index (ordnum) was actually the expression ALLTRIM(ordnum). After reading your post, and learning some things that I didn't know, I...

I've been rewriting a program that my company uses ,and that I have been maintaining for the last 20 years, written in VFP7. I am rewriting this in VFP9. One of my forms is to create and track Purchase Orders. It uses 2 tables (header and detail). I join them with a common field "ordnum". I have...