Doug - this is off topic but was hoping you could describe in general terms how the tableupdate routine in SDT works. By that i mean in the event where new fields are being added to an existing table AND existing fields are being removed from the same table, is the processing order to ADD the new, then REMOVE the "old" fields? I ask because i encountered a "too many columns" error during an update where a couple of new fields were being added while a large number of fields were being removed. The NET result would have altered a table so that the field count was below the max allowed. Using SDT5.1.
>Hi Jeff.
>
>>The Stonefield Query help file provides an example of GetValuesForField method and the equals operator. Does any one have an example of how to call this method with the "is one of" parameter.
>
>I don't have a specific example, but the only difference between "equals" and "is one of" is that the collection returned by the method has more than one parameter object. So, you can use something like:
>
>
for lnI = 1 to loValues.Count
>loValue = loValues.Item(lnI)
>* do something with loValue.Value
>next
>
>Doug