How to add column

Posted by Rajivksharma under Others on 11/5/2008 | Views : 1439 | Status : [Member] | Replies : 3
This is the code in VB. I have to add one more column e_diff_loc but this column is in boolean .Plz telp me how to add this field in below code

Dim i As Integer
Dim lngRow As Long

lngRow = 0
For i = 1 To sprSatsangScheduleController.getNumberOfNonDeletedRows
lngRow = sprSatsangScheduleController.getNextNonDeletedRow(lngRow)
dbManager.executeSQL "centreSatsangScheduleIns " & Me.txtCentre.Tag & ", '" & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_day) & "', '" & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_time) & "', " & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_language_id)




Responses

Posted by: Deysomnath on: 11/6/2008 [Member] Starter

Up
0
Down
For i = 1 To sprSatsangScheduleController.getNumberOfNonDeletedRows
lngRow = sprSatsangScheduleController.getNextNonDeletedRow(lngRow)
dbManager.executeSQL "centreSatsangScheduleIns " & Me.txtCentre.Tag & ", '" & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_day) & "', '" & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_time) & "', " & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_language_id) & "', " & _
sprSatsangScheduleController.getTextOfCell(lngRow, sprSatsangScheduleColumns.e_diff_loc)

<\br>
Are you getting any error by adding it like above code

Rajivksharma, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Rajivksharma on: 11/6/2008 [Member] Starter

Up
0
Down
Thanks for replyin.
yes i'm getting an error because the field diff_loc is in boolean

Rajivksharma, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Deysomnath on: 11/9/2008 [Member] Starter

Up
0
Down
I think there should be a parameter in getTextOfCell(..) method where you can set the data type.
Can you please tell me what is sprSatsangScheduleController object.
you can also try like

sprSatsangScheduleColumns.e_diff_loc.ToString()

I am sure it will work

Rajivksharma, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response