The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
pls help datagrid problem
Posted: 12 Mar 07 1:56 PM
|
fiogf49gjkf0d i've updated a column in a table but the update is not reflecting on the datagrid. Its a checkbox column(if value is "T" then checked else then uncheck)
what seems to be the problem here? |
|
|
|
Re: pls help datagrid problem
Posted: 13 Mar 07 8:10 AM
|
fiogf49gjkf0d Are you calling DataGrid1.Refresh after updating the value? Are you setting the recordset property of the datagrid? You may want to include the code you are using here so someone can help you. |
|
|
|
Re: pls help datagrid problem
Posted: 13 Mar 07 10:22 AM
|
fiogf49gjkf0d Thanks for replying. Heres the code:
strFlag = "T"
Set objCon = Application.GetNewConnection
strSQL = "UPDATE SALESPROCESSAUDIT SET" 'DNL
strSQL = strSQL & " COMPLETED = '" & strFlag &"'" 'DNL
strSQL = strSQL & " WHERE SALESPROCESSAUDITID ='QBPDVA000HOK'" 'DNL
objCon.Execute(strSQL)
grdSalesProcess.Refresh
i also tried reruning the whole application but still the update didnt reflect the datagrid. am i missing something? |
|
|
|
Re: pls help datagrid problem
Posted: 13 Mar 07 2:27 PM
|
fiogf49gjkf0d This looks OK to me. Assuming grdSalesProcess is the name of the correct datagrid, here are a few other things to look for:
Is there any code that sets the recordset property (e.g. grdSalesProcess.Recordset = ...)
Is 'QBPDVA000HOK' the correct id? What happens if you run the following SQL From Administrator?
Select Completed From SalesProcessAudit Where SalesProcessAuditId = 'QBPDCA000HOK'
Are you sure the code that updates the database is actually running? |
|
|
|
Re: pls help datagrid problem
Posted: 13 Mar 07 3:41 PM
|
fiogf49gjkf0d 'QBPDVA000HOK' is a valid id. I'm sure the code that updates the databse is actually running. it executes the sql statement but the update is not reflecting on the datagrid. i check sql managestudio after running the code the value is already updated but on the datagrid column is still not checked. i also rerunning the whole application but still the column isn't checked at all. pls help i'm stuck at this problem. 
theres no code that sets the recordset property, but theres a bunch of included script in there i just don't know w/ those included scripts. i think this sales process also checks for completeddate idk i'll have to try updating the completeddate as well and see if whether updating that thing will solve the problem.
thanks! |
|
|
|