how to refresh grid

[sremias]

This should be relatively simple (the easy things really trip me up!)

I have a grid (I'm running version 11) and I added logic to the OnSqlSelectQuery server side event. If the alpha generated SQL select returns no records, I want to pull data from another table to populate the grid. I have that all working fine (logic is below) and can confirm the data gets added to the table correctly by viewing the information in SQL Server. However, I need to have the grid do a REFRESH after the OnSqlSelectQuery runs so the new records that were entered are visible to the user. I cannot figure out how to do this! PLEASE HELP!

Here is my logic to insert the new recs. I just need the syntax to refresh the grid. Thanks in advance for your advice!



if e.recordcount = 0 .and. eval_valid("session.SESS_SEQ") then

dim fai_id as N
dim part_number as C
dim seq_number as C

dim sql as C
dim args as SQL::Arguments

' fyi, links passed from qtfai contain:
' e.rtc.links[1].fieldname = "FAI_ID"
' e.rtc.links[2].fieldname = "PART_NUMBER"
' e.rtc.links[1].value = contains value of fai_id
' e.rtc.links[2].value = contains value of part_number

if e.cn.BeginTransaction() then

fai_id = e.rtc.links[1].value
part_number = e.rtc.links[2].value
seq_number = session.SESS_SEQ

'e.handled = .t. 'override the auto generated sql with the following 'GET FATAL ERROR WHEN ADD THIS LINE
sql = "INSERT INTO QTFAINSPECT (fai_id, part_number, sequence_number, item_description, nominal, upper_limit, lower_limit, um) SELECT :fai_id, part_number, sequence_number, dim_description, nominal, upper_limit, lower_limit, um FROM partdim WHERE part_number = :part_number AND sequence_number = :seq_number" ;

args.set("fai_id", fai_id)
args.set("part_number", part_number)
args.set("seq_number", seq_number)


if e.rtc.cn.execute(sql,args) == .f. then
e.flagerror = .t.
e.errorText = "Unable to update record at this time. [CONNEXEC4] "+ e.rtc.cn.CallResult.NativeText+" | "+ e.rtc.cn.CallResult.Text
e.rtc.cn.RollBackTransaction()
else
e.rtc.cn.CommitTransaction()

end if
end if
end if


session.RemoveAll()

end function

[sremias]

Re: how to refresh grid

I added an Xbasic function as follows and I know it is executing because I hit the debug statement:

function MyTestCallback as c (e as p)
debug(1)
MyTestCallback = "{grid.Object}.refresh();"
end function

I added a call to it in the server side script in my original post in the OnSqlSelectQuery immediately following the COMMIT statement as follows but the grid is still not refreshing:
MyTestCallback(e)

Can anyone tell me what I am doing wrong? I have to physically close the grid and reopen it to see the new data.

[aal_fareed]

Re: how to refresh grid

why u dont just try {grid.Object}.refresh();
on after submit event as java script

i have this working with me

[aal_fareed]

Re: how to refresh grid

and one more thing ,
if you want you can add javascript on click of that button you have place xbasic code in .. and type {grid.Object}.refresh();
there it will work too .. let me know how it goes with you i will try to check post at night ...

good luck

[sremias]

Re: how to refresh grid

Thanks for the response Ahmed.

Unfortunately, user is not executing a SUBMIT (I did try just to confirm and I do not hit the AfterGridSubmit). I am running my logic when the SELECT query is run and basically overriding the SELECT if the initial alpha generated query returns 0 records. I insert new records from another table to autopopulate the grid to save the user data entry time. So I am looking for a way to kick off the refresh immediately after my logic runs (in OnSQLSelectQuery event).

I probably could use a button and put the refresh in the onclick, but I was trying to do all this without any interaction from the user.

[aal_fareed]

Re: how to refresh grid

Thanks for the response Ahmed.

Unfortunately, user is not executing a SUBMIT (I did try just to confirm and I do not hit the AfterGridSubmit). I am running my logic when the SELECT query is run and basically overriding the SELECT if the initial alpha generated query returns 0 records. I insert new records from another table to autopopulate the grid to save the user data entry time. So I am looking for a way to kick off the refresh immediately after my logic runs (in OnSQLSelectQuery event).

I probably could use a button and put the refresh in the onclick, but I was trying to do all this without any interaction from the user.

have you tried to place it in onrendercomplete event or canrender at client side event ?

[sremias]

Re: how to refresh grid

Hi Ahmed,
After much trial and error and thanks to your suggestion, I got it to work in the OnRenderComplete client side event. This component was accessed from another component vian a link using Action JavaScript to open grid component. I had to uncheck the USE CACHED GRID property to make it work. It was only working for the first record accessed and not when accessing additional records. Probably doing that would've fixed my issue prior to all this, but I am EXTREMELY THANKFUL for your help and happy that is now working.

Thanks again for taking the time to read and offer suggestions on my post. It is much appreciated.

[CharlesParker]

Re: how to refresh grid

couldnt you put the refresh in the Onchange event?