>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
Joao,
SQL would never read from uncommitted data. With multiusers and buffering you have no chance to read max order_id. Your best bet is to use another table unbuffered to dispatch order_id. See solution.app nextid using.
Cetin