C
ChUIMonster
Guest
The -id field is the unique key for most VSTs. _myConnection is an exception since there is only ever just the one record. In almost all cases when you are working with VSTs you want to use the "id" field as the unique key. (This is a good reason to keep the distinction between "vst" and "meta schema" clear because this is NOT the case with meta schema tables.) It is also useful to note that: _connect-id = _connect-usr + 1 It is also useful to note that _connect-usr = ? means that there is no session active for that _connection. The *efficient way to find the _connect record corresponding to a given usr# is: find _myconn no-lock. display _myconn. find _connect no-lock where _connect-id = _myconn-userid + 1. display _connect-id _connect-usr _connect-name _connect-pid .
Continue reading...
Continue reading...