General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Select max() from a table with tablebuffer - HELP !!
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only