cancel
Showing results for 
Search instead for 
Did you mean: 

Problem with strings in DBDatasource.SetValue

Former Member
0 Kudos

Hi everybody:

I have the next problem: I need show in a matrix object several data. The matrix fields are bounded by a Table. I have a string containing "Subgerente de sucursal", but when I apply DBDatasources.SetValue, I just see a tuncated string with 8 characters. I see in the matrix the string "Subgeren".

I watched the field in Database and it has 254 characters lenght.

Is this a bug? Can anyone help me, please?

My code example is:


Dim oFuenteDatosIncentivos As DBDataSource
Dim sDescripcionPuesto as string = "Subgerente de sucursal"

oFuenteDatosIncentivos = oForma.DataSources.DBDataSources.Item("@SYS_PDETALLEINCEN")

FuenteDatosIncentivos.SetValue("U_SYS_DEPU", iIndice, sDescripcionPuesto)

Thanks in advance.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi everybody:

I could solve this problem. The edit lenght to this field was incorrect. I modified this value and the form works fine!

Thanks so much!

Misael Reséndiz

Former Member
0 Kudos

hi misael

i think u have a problem for dbdata bind, i bound the matrix colum by a user table i hope this code help u

oDBDataSource = oForm.DataSources.DBDataSources.Add("@OPDT1");

public void BindDataToForm()

{

oColumn = oColumns.Item("tot_sal");

oColumn.DataBind.SetBound(true, "@OPDT1", "U_tot_sal");

oColumn.Editable = false;

oColumn = oColumns.Item("tot_det");

oColumn.DataBind.SetBound(true, "@OPDT1", "U_tot_det");

oColumn.Editable = false;

oColumn = oColumns.Item("net_sal");

oColumn.DataBind.SetBound(true, "@OPDT1", "U_net_sal");

oColumn.Editable = false;

oColumn = oColumns.Item("bas_sal");

oColumn.DataBind.SetBound(true, "@OPDT1", "U_bas_sal");

oColumn.Editable = false;

regards by

rakeshnagar

Former Member
0 Kudos

Misael,

Wht datatype u r using for that field? Is this AlphaNumeric? Else u can use Memo datatype it allow more than 2000 charaters.........

Regards,

Anitha