>>>>>>The situation is like this. I have a form with a parent-child
>>>>>>table. The child table is shown in the grid. When the user wants
>>>>>>to add a record, I change the control source of the parent table to the memory fields.(I am using
>>>>>>table buffering ).
>>>>>
>>>>>Alarm bells are going off in my head when I read this line. Why do you need to change
>>>>>any control sources? Why are you using memory fields and Table Buffering? If you're
>>>>>using buffering, you should be able to work directly with the table fields, and Fox
>>>>>will handle whether they're in memory or on disk.....
>>>>
>>>>Bells have broken loose in my head. The problem is I am too afraid to try on the table buffering to handle everything
>>>>I tried it once and I was gettig strange results and after that I never tried. The main problem is the primary key
>>>>validation. I accept the view of surrogate keys but the users want a sort of their own key and it has to be
>>>>also unique. In my experiment with buffering, I was not able to validate the fields before the user leaves the
>>>>control. Somehow I dont understand how all of you are using it. May be I am too dumb to understand.
>>>>
>>>>Thanks for the reply.
>>>>
>>>>alex
>>>
>>>Alex,
>>>If your VALID returns .F. no one is going anywhere.
>>>You can also return a number to get you where you want.
>>>Using This.Value for your validation rules is fine.
>>
>>Thanks. I did it once and I got into big problems. I was not able to come out of the valid without injury.
>>Thank you very much.
>>
>>alex
>
>Now that you mention it I had some problems calling another form from within a grid's ,textbox's VALID.
>I ended up putting the validation in the lost focus and using the GETFLDSTATE() and
>SETFLDSTATE() to trigger validation. This was a problem with both 3.0 and 5.0. ;
>however, I just got the Visual Studio service pack 3 and did a quick test using the same in a valid
>and it worked. I haven't checked it out in detail yet. I don't know if this really applies to your
>situation but I know what you mean about problems in the VALID.
Thank you for the tip. I am yet to download the service pack. I have big problems with downloads. The ISP
is not very reliable.
thanks
alex
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only