Hi !!

Hi have two users and i want to find the maxium of a table column but ....
I´m using table buffer and the tableupdate is decided by the user !!

please help !! what i'm doing wrong ??

Thank you ALL

SET MULTILOCKS ON
create database demo
open database demo
CREATE TABLE "orders.dbf" NAME orders ( order_id N(5))

select 1
use orders shared
lSuccess=CURSORSETPROP("Buffering", 5, "orders")

append blank
replace orders.order_id with 1 &&->user 1

append blank
replace orders.order_id with 2 &&->user 2

browse

select max(order_id) from orders into array max_order_id &&->by user 1

if type("max_order_id[1]") = "N"
wait window str(max_order_id[1],5)
else
wait window type("max_order_id[1]")
endif