David,
Thanks for the suggestion. I think I'm going to stay with using the cursors however. I will be allowing the user to edit or add to the list. I think it might be easier to just use the SELECT .. INTO CURSOR .. READWRITE statement. What do you think?
Elgin
>Elgin,
>
>You can run the SELECT into an array property of the cbo itself. Create a couple of custom properties on the cbo subclass and they can easily read their list of values as they Init():
>
>
select dispvalue, pk ;
> from metadata ;
> into array this.maList ;
> where datafield = this.cListType ;
> order by dispvalue
>
>>I have a dropdown list combobox with the following SQL statement as the RowSourceType:
>>
>>SELECT * FROM metadata NOCONSOLE WHERE datafield = "cboRef"
>>
>>The Table "metadata" is placed in the Form's DataEnvironment. When I start the form, the results of this SQL statement appear in a browse window just before the form displays. How do I avoid this? I thought that's what the "NOCONSOLE" instruction is for. I know I can have the result set go to a cursor. But I prefer it not to, as I will have several other ComboBoxes using the same "metadata" table and similar SQL statements as their RowSourceType and I don't want all these temporary cursors being opened if I can avoid it.