>>>>Hi everybody,
>>>>
>>>>I select data from SQL Server and display in the combobox. If the Hidden column value = 1 in SQL Server I want to display these values disabled.
>>>> I tried appending \ in front of the description using case when statement, but as a result I got entries with \ in front of them.
>>>>
>>>>Is there a way to achieve what I want?
>>>>
>>>>Thanks in advance.
>>>
>>>Put cursor data into an array and uses RowSourceType = 5
>>
>>Fabio,
>>
>>There are 6 similar fields. Currently we use fields as RowSource (6) for each of these 6 fields. Would I be able to use the same array for each of these 6 fields?
>
>
>SELECT &RowSource INTO ARRAY ComboArray FROM ...
>Combo.ColumnCount = ALEN(ComboArray,2)
>
>
>VFP uses \ on first column only.
No, you misunderstood me.
I have 6 fields (profit 1, profit2, etc.). All of them use combobox and right now they use fields (6) from the cursor I create in the DE of the form. Suppose, I do
select * from myCursor into array thisform.Profits
would I be able to use the exact same array for each of these 6 fields or I'd need 6 different arrays?
If it's not broken, fix it until it is.
My Blog