Hi All, I'm trying to chang

Hi All, I‘m trying to change the first field in a table which has copied data from another table.

I have tried using the following code but it does not change the last record. I have tried this code as a stand alone bit of code on another button on the form and it works. The variable as can be viewed and are correct

Paradox  11 is the version.

if not tc2.open(":caliachData:CopyWindingData.DB") then

errorshow()
else

while tc2.eot() = false
tc2.edit()

if tc2.fldTrfWdgPartNum = oldpno then

tc2.fldTrfWdgPartNum = cpno

tc2.nextrecord()

Endif

endwhile

Endif

Thanking yo in advance

Cheers

Bill

yes, that should work, unless you have a postrecord failure, invalid lookup value, etc

but you can also

scan tc2:

endscan

and the edit/endedit goes outside the while or the scan

Steven Green
Senior Software Engineer
Paradox Support Specialist DOS/WIN

I have found that when I use that TC.EOT() = False format for my loop,

If I fail to to properly close my tcursor, then the last record change will fail to post.

I think you need to add these lines after the  endWhile

tc2.EndEdit()
txc2.Close()

Thanks, worked perfectly..