General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>(( fields: Name, iemail, content, sendto, sendcc, sendbcc))
>>>John,11,Test,.t.,.f.,.f.
>>>Koen,11,Test,.t.,.f.,.f.
>>>Rob,11,Test,.f.,.t.,.f.
>>>Maria,11,Test,.f.,.t.,.f.
>>>Bill,11,Test,.f.,.f.,.t.
>>>Somebody to assist me?
>>
>>create UNION of all combinations of cursors 1+2 found in send cursors with dummy send fields an run update statements,
>>updates needed to allow distinct handling of UNION
>>
>Thomas,
>your solution 1 works OK for my first requirement and adapted a little bit with 3 extra fields which to be set .T. or .F. it also works for my second requirement.
That is the main thing ;-)
That said, instead of boolean fields in 2nd requirement I'd use integers: you have the cheap check of 0 or higher to get your current needs but also have a check with >1 for programming errors sending same mail twice via same send channel or adding all # to see how often same recipient received that specific mail ;-))
Filling those integers via SQL not really harder to code - perhaps a bit slower as more records need to be checked, but should not create a perf problem.
>I find your solution 1 better than 2 with updating.
I went at it from the base requirement of existing tables - also hinting, that my base tables would be different (the union of send-cursors as base table), which would allow to answer a greater range of questions thrown at the data directly ;-))
Previous
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