Hi
Sir what is table validation, how we validate table . I am using vfp 9.0
it gives me lot of errors of table validation. Is there any tool available to
repair the table.



--
Qaiser Me

Re: Table validation by Imaginecorp

Imaginecorp
Mon Jun 12 20:54:35 CDT 2006

Table validation is when you check if the whole record being inserted or
edited meets with some criteria or you want something to happen. If not, you
don't allow it. Its normally written in the stored procedures of the Dbc.
modify the table go to the table tab and remove the text in Rule, Message,
all 3 triggers. That should prevent the validation.
Mohammed

"QaiserMehmood" <qaiserme@fastmail.fm> wrote in message
news:1A7FA853-7BBE-4F12-A75F-91040B82E413@microsoft.com...
> Hi
> Sir what is table validation, how we validate table . I am using vfp 9.0
> it gives me lot of errors of table validation. Is there any tool available
> to
> repair the table.
>
>
>
> --
> Qaiser Me



Re: Table validation by Dan

Dan
Tue Jun 13 10:26:19 CDT 2006

The other form of table validation, of course (and I'm betting it's what
he's asking about), is caused by SET TABLEVALIDATE.

VFP compares the table header and record count to make sure they're in
synch. If they're not, VFP throws an error.

If you're routinely falling afoul of these errors, your environment is
causing potential corruption and your data is in peril. Fix your
environment.

Dan


Imaginecorp wrote:
> Table validation is when you check if the whole record being inserted
> or edited meets with some criteria or you want something to happen.
> If not, you don't allow it. Its normally written in the stored
> procedures of the Dbc. modify the table go to the table tab and
> remove the text in Rule, Message, all 3 triggers. That should prevent
> the validation.
> Mohammed
>
> "QaiserMehmood" <qaiserme@fastmail.fm> wrote in message
> news:1A7FA853-7BBE-4F12-A75F-91040B82E413@microsoft.com...
>> Hi
>> Sir what is table validation, how we validate table . I am using
>> vfp 9.0 it gives me lot of errors of table validation. Is there any
>> tool available to
>> repair the table.
>>
>>
>>
>> --
>> Qaiser Me