Hi - I just wanted to get some advice really - I use this code in the LOAD of all my forms where there is data involved...
if !dbused('gen_data')
open database gen_data shared
endif
set database to gen_data
set date british
set exclusive off
set multilocks on
set exact on
* open views
if !used('v_customers')
use v_customers shared in 0 nodata
endif
I have a couple of questions...
1. Should I be opening the database at the start of application rather than attempting it whenever I open a new form?
2. Is the order that I am doing things correct? ie. open and set database then set exclusive off?
3. Any other comments?