Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Hi Edward,
I tried using the alias with the field name but that still didn't make it work.
At first I put the setall statement in the form's init, then in the method that fills my cursor with my query(after the cursor is filled), but neither worked. There seems to be no way of having the iif(mycursor.myfield='data',.t.,.f.)validate each record in my cursor, and I can't use a scan/endscan since I'm using a setall command.
I'll leave a clip of my line for you look at:
with this.grdExample
.setall('dynamicfontitalic',"IIF(myCursor.myField='somedata',.t.,.f.)","column")
endwith
If you spot what I might have done wrong, please let me know.
Thanks
Allen
>>
>>Hi all,
>>
>>I've been fumbling with this problem all day and I decided to ask for help.
>>I have a grid with it's columns controlsources set to a cursor.
>>When I populate the cursor from a query, I want to set certain rows to italics. It is dependent upon what the value of a field in my cursor is.
>>Ok so I've realized that if I were to setup a dynamicfontitalic-setall statement in the init method and I was using a table in my data environment, it would be like this:
>>thisform.grdMygrid.setall('dynamicfontitalic',"iif(my_field='cancelled',.t.,.f.)","column")
>>
>>BUT, my problem is that this doesn't seem to work when my field is not from a table but from a cursor. Can it be done?
>>
>>Thanks
>>
>>-------------
>
>Hi, Allen!
>
>It works the same way for table and cursor. You should use proper alias (mycursor.myfield) in setall expression.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement