Hiya All
I've got an SQL teaser
I want a master - child structure but the children must be sequenced
i.e MasterTbl can have a record A and ChildTbl A.1,A.2,A.3
The trick is
1/ The sequence must be enforced within a range ie cannot iadd A.5 to above
set but can A.4
2/ Ideally inserting A.Null should add the record to the end
3/ The must be a method for moving children in the sequence by simply
editing a live child result set i.e.
edit A.3 -> A.2 causes A.2 -> A.3 or A.3 -> A.1 causes A.1 -> A.2 and
A.2 ->A.3
Anyone bored on Friday?
Regards Neven
N.K. MacEwan B.E. E&E
[EMAIL PROTECTED]
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
