Display a SAY from within a GET.
Posted:
Tue Sep 14, 2010 4:19 pmby HunterEC
Guys:
After GETting the field nNumber, how can I display the customer name from the database from within the GET at position 25,40 ?
- Code: Select all Expand view
@ 10,05 SAY oSays[1] VAR "Number" OF oDlg PIXEL
@ 25,05 SAY oSays[2] VAR "Name" OF oDlg PIXEL
@ 25,40 SAY oSays[3] VAR Cust_name OF oDlg PIXEL
@ 40,05 SAY oSays[4] VAR "Balance" OF oDlg PIXEL
@ 55,05 SAY oSays[5] VAR "Date" OF oDlg PIXEL
@ 10,40 SAY oGets[1] VAR nNumber OF oDlg PIXEL
VALID IIF(DBSEEK(nNumber, .F.), ..., MsgALert("Customer Not Found"))
@ 40,40 SAY oGets[2] VAR nBalance OF oDlg PIXEL
Thank you.
Re: Display a SAY from within a GET.
Posted:
Tue Sep 14, 2010 4:26 pmby nageswaragunupudi
Assuming that the field name of Customer Name in the DBF is CUSTNAME:
- Code: Select all Expand view
@ 10,05 SAY oSays[1] VAR "Number" OF oDlg PIXEL
@ 25,05 SAY oSays[2] VAR "Name" OF oDlg PIXEL
@ 25,40 SAY oSays[3] VAR FIELD->CUSTNAME OF oDlg PIXEL UPDATE
@ 40,05 SAY oSays[4] VAR "Balance" OF oDlg PIXEL
@ 55,05 SAY oSays[5] VAR "Date" OF oDlg PIXEL
@ 10,40 SAY oGets[1] VAR nNumber OF oDlg PIXEL
VALID IIF(DBSEEK(nNumber, .F.), ;
(oDlg:Update(), .t. ), ;
(MsgALert("Customer Not Found"), oDlg:Update(), .f. ))
@ 40,40 SAY oGets[2] VAR nBalance OF oDlg PIXEL
Re: Display a SAY from within a GET.
Posted:
Thu Sep 16, 2010 4:59 pmby James Bott
I am assuming this var is an array: oSays[1]
This is not really correct Hungarian syntax. An array datatype should be prefixed with an "a" regardless of what datatype the array contains (in this case an object). So it should be aSays instead. It does contain oSay objects.
Regards,
James