How to add column

Posted by Rajivksharma under Others on 11/5/2008 | Views : 2713 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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)

Reply | Reply with Attachment

Alert Moderator

Responses

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

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) & "', " & _ 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

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

0	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

0	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

Latest Posts