Editable Table - Device & Desktop

[Rioven]

Hi

I made this changes on Erel's EditableTable...but doesn't work when selecting partially diplayed cells and scroll bars...

Sub eventScrollH_NewEvent
btnAccept_Click
End Sub
Sub eventScrollV_NewEvent
btnAccept_Click
End Sub

Needs to put it back to original...

Sub eventScrollH_NewEvent
pnlEdit.Visible = False
End Sub
Sub eventScrollV_NewEvent
pnlEdit.Visible = False
End Sub

CORRECTED File on my previous post...

My only problem now is on device, when updating cell entry and then drag scroll bars, the cell will display unchanged content, but when you select this cell again, it will appear the updated content. What is the best thing to do?

[Erel]

A new version (1.10) was uploaded. See the first post.

[outlawz]

Hi to you all. Can someone help me how the sub: Sub Validate(column, value) is called? I wanna check if i can add another parameter (the row or another field value of that record, like the primary key field).
If i can, then it is easy to update de database by a SQL command.
I can´t believe i was the entire morning with this isue. Help me masters please.

Thanks,

[Erel]

Sub btnAccept_Click
If cmbEdit.Visible = True Then
value = cmbEdit.Item(CmbEdit.SelectedIndex)
Else
value = txtEdit.Text
End If
pnlEdit.Visible = False
If tables(currentTable).validator <> "" AND _
CallSub(tables(currentTable).validator,Control(Tab leName,Table).SelectedCol,value, New Parameter) = False Then
Return
End If
Control(TableName,Table).Cell(Control(TableName,Ta ble).SelectedCol, _
Control(TableName,Table).SelectedRow) =value
End Sub

[outlawz]

Good night, Erel i have a problem that i´m not able to solve. As I said today, I´m struggling to get database update working. As it is right now, the DB is updating but gives a overflow error. I tried to put the SQL update where you said, but in there is before the validation process, so i put it after that process.
Could you please take a look when you can? I don´t like to be asking things all the time, i like to fight the things till i figure it out how to solve, but in that case is very hard, i guess i started with a not newbie project.

Thanks again for all your help.

Regards

[Erel]

You should use ExecuteNonQuery instead of ExecuteTable.
An UPDATE operation doesn't return any value. ExecuteTable takes the result of a query and inserts it to a table.

 (line 36)
        cmd.CommandText = "UPDATE inventario SET conta = "& value & " WHERE IDPK = "& chave
        cmd.ExecuteNonQuery

[outlawz]

Thanks Erel, i need to read more the Basic4PPC commands to avoid stupid questions like i did. Now it works fine on the desktop but gives me always errors on the device: "NullReferenceException". I searched the forum but i was not able to find any related problem.
Anybody here had the same issue?

Thanks,

[Erel]

Which line gives this error?

[outlawz]

Hi Erel, don't indicates lines:

First - An error occurred on sub __main_tamanhocolunas. NullReferenceException
Continue? -- If I put yes then i try to change a cell value and:

Second - An error occurred on sub __main_validate.
NullReferenceException
Continue? -- If I put yes ther errors repeat on the sames choices.

Never updates. On desktop all OK.

Thanks

[Erel]

Please start a new thread and also post the code of these two subs.
Thanks,
Erel