>Dear all,
>
>What are the possible problems if I have coded the following:
>
>select &sqlview
>cursorsetprop("buffering",5,"&sqlview")
>tableupdate(.t.)
>
>and it is not updating.
>
>thanks for your time.
>
>Ed
You should add aerror(laError) after tableupdate and check each element of the array.
Also, why do you have "&sqlView" here, would sqlView (no "" and macro) work the same? Use name expression where appropriate.
You may review
Choosing between Macro substitution and Name expressions FAQ #7841
So, your code may be
select (sqlview)
cursorsetprop("buffering",5,sqlview)
if not tableupdate(.t.)
local array laError[1]
=aerror(laError)
=messagebox("Error " + laError[1,2])
endif
If it's not broken, fix it until it is.
My Blog