Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Multiple records update validation question
Message
From
16/05/2007 12:56:07
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01226060
Message ID:
01226087
Views:
25
>>>Thanks in advance.
>>
>>
>>I would
>>
>>- take the focus off the grid
>>- select grid.RecordSource
>>- Success = TRUE
>>- scan all while Success
>>    Success = ValidateInfo()
>>  endscan
>>
>>do case
>>case !m.Success
>>
>>otherwise
>>    begin transaction
>>    save the lot
>>
>>    if( SomeErrorDuringSave )
>>      rollback
>>    else
>>      end transaction
>>    endif
>>
>>endcase
>>
>
>Gregory,
>
>Why do we need to check not modified records?

It was the general idea. You can skip the untouched records in both the validate and the save of course

>But you agree I need a loop here, right?

Yes

>I'm now thinking, I need to save touched records somehow simply, say, in extra cursor. And I do need to add EditBox valid at least.

Isn't there any other means to determine whether a record has been changed ?
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform