table upation problem in some systems

TheMSsForum.com: The Microsoft Software Forum

I think somebody can give solution to the following problem in vfp 7 version,
it
would be very tankful.
I am facing a severe problem, that in some of my clients systems some
records are missing or not updating properly. for example, if I have 3 tables
to be updated in a Transactions, one of the table found not updated. the
records
çan be find updated before 'End Transactions'. but after the 'End
Transactions'
Records are vanished(the records which is inserted or appened this session)
it is not showing any error messages even i put error handling functions.
After running reindex or regenerate database records(new records not
vanished) are update properly for sometimes. but the same problem repeats
after sometimes

It is happening only in some systems. Suppose, if it is a index problem how
can i check
secondly how i can check database/index file integrity before updating
records.
following commands are given for updation
***************************
begin transactions

program detail--------

if !Tableupdate(1,.t.,'invoice')
rollback
=messabox('')
thisform.txtinvoiceno.setfocus()
return
endif
if !Tableupdate(2,.t.,'invTrans')
rollback
=messabox('')
thisform.txtinvoiceno.setfocus()
return
endif

if !Tableupdate(2,.t.,'LedgerTransactions')
rollback
=messabox('')
thisform.txtinvoiceno.setfocus()
return
endif

&& after table updation we can find the records thro' seek / locate / brows

end transactions

select invoice
if !eof()
skip
else
skip -1
endif
&& but here records are missed (not in all, but in one table the records
which inserted in last transactions )
**************************
sam



Expand AllCollapse All


Manage Your Profile |Legal |Contact Us |MSDN Flash Newsletter
Top

Re: table upation problem in some systems by Anders

Anders
Mon Oct 25 09:14:06 CDT 2004

Sameer
You can add a fourth parameter to TABLEUPDATE(2, ... ) which is the name of
an array where any error messages are reported.
-Anders

"sameer" <sameer@discussions.microsoft.com> wrote in message
news:83A1A99F-A9E9-436F-BADD-B361A0835C7C@microsoft.com...
> I think somebody can give solution to the following problem in vfp 7
version,
> it
> would be very tankful.
> I am facing a severe problem, that in some of my clients systems some
> records are missing or not updating properly. for example, if I have 3
tables
> to be updated in a Transactions, one of the table found not updated. the
> records
> çan be find updated before 'End Transactions'. but after the 'End
> Transactions'
> Records are vanished(the records which is inserted or appened this
session)
> it is not showing any error messages even i put error handling functions.
> After running reindex or regenerate database records(new records not
> vanished) are update properly for sometimes. but the same problem repeats
> after sometimes
>
> It is happening only in some systems. Suppose, if it is a index problem
how
> can i check
> secondly how i can check database/index file integrity before updating
> records.
> following commands are given for updation
> ***************************
> begin transactions
>
> program detail--------
>
> if !Tableupdate(1,.t.,'invoice')
> rollback
> =messabox('')
> thisform.txtinvoiceno.setfocus()
> return
> endif
> if !Tableupdate(2,.t.,'invTrans')
> rollback
> =messabox('')
> thisform.txtinvoiceno.setfocus()
> return
> endif
>
> if !Tableupdate(2,.t.,'LedgerTransactions')
> rollback
> =messabox('')
> thisform.txtinvoiceno.setfocus()
> return
> endif
>
> && after table updation we can find the records thro' seek / locate /
brows
>
> end transactions
>
> select invoice
> if !eof()
> skip
> else
> skip -1
> endif
> && but here records are missed (not in all, but in one table the records
> which inserted in last transactions )
> **************************
> sam
>
>
>
> Expand AllCollapse All
>
>
> Manage Your Profile |Legal |Contact Us |MSDN Flash Newsletter
>
>

Top