FiveTech Software tech support forums

Thanks Mr. "Genius" Rao!

Thanks!

but what if I have a query and I want to update the edited row?
Especially when it comes to a "query" that has "INNER JOIN" included...

Do you need to edit and modify a field of a joined table?

Try this sample:
function EditJoin()

local oCn, oRs, cSql

TEXT INTO cSql
SELECT C.ID, C.City, C ...

Mr Rao:

1) Yes, yes, surely something is wrong in my xbrowse development.

2) I use Dolphin, understood....

3) Ok! Thanks!

4) Ok, tested. Works perfect!

Thank you very much for giving me your help!

Roberto

1) Are you convinced that
:bOnPostEdit := {|oCol,xVal,nKey,f| If(nKey==VK_RETURN,MsgStop("alerta"),)}
is not giving error?

2) Are you using ADO, TDolphin, TMySql or FWH built-in maria/mysql lib?
FWH natively supports all of them, The same code works.

3) Modifying Joined tales is not normally a ...

Thank you very much Mr. Rao!

I didn't know this method was obsolete.

The query is, what was the recording in the MySql table in this case?

The example is from a DBF, but what if I have a query and I want to update the edited row?
Especially when it comes to a "query" that has "INNER JOIN ...

¡excelente! Espectacular, me gustó este comando.

Gracias, regards, saludos.

Please never use bOnPostEdit.

This was deprecated almost 15 years back. It is still there only for backward compatibility with very very old programs.

XBrowse internally builds bOnPost edit codeblock suitable for the database used. XBrowse knows how to save changes, including locking and unlocking ...

I tested here your bOnPostEdit codeblock with FWH2409 and I have no problems at all. It is running well.

This is the program I tested with fwh2409:
#include "fivewin.ch"

REQUEST DBFCDX

function Main()

local oDlg, oBrw, oFont

USE WWONDERS NEW SHARED VIA "DBFCDX"

DEFINE FONT oFont NAME "TAHOMA ...

Hola Rober,

si mal no recuerdo, Rao desaconsejaba usar bonpostedit, en su lugar bEditValid o ceditvalue.

Slds.

Karinha...

después de un edit de un xbrowse, al dar enter o una tecla para seguir, te permite
realizar una opción, en este caso, yo, cuando le doy enter, necesito grabar
en un par de tablas.

Por ahora lo solucioné de otra manera, en vez de usar el EDIT_GET del xbrowse, tomé
la sugerencia del ...

Buenos días Roberto, ¿qué hace este comando bOnPostEdit? Nunca lo usé. ¿Puedes explicarlo?

Gracias.

Regards, saludos.

Hola amigos..

les consulto, tengo la siguiente funcionalidad en mi xbrowse:


oBrw:aCols[19]:nEditType :=EDIT_GET
oBrw:aCols[19]:bOnPostEdit:={|oCol,xVal,nKey,f| If(nKey==VK_RETURN,MsgStop("alerta"),)}

Cuando pulso 2click sobre la columna 19 de mi browse, me aparece get de tipo memo, escribo
lo ...

... GET
olbx101c:acols[3]:cEditPicture:="@!"
olbx101c:acols[3]:bEditWhen:= { || olbx101c:aArrayData[olbx101c:nArrayAt][5]="C" }
olbx101c:acols[3]:bOnPostEdit:= { |o,nval| hola(@acDescriptor,@acTemporal,olbx101c,nval) }

olbx101c:acols[4]:nEditType:=EDIT_GET_LISTBOX
olbx101c:aCols[4]:addbmpfile ...

... s.Marca = dbo.Marcas.Numero "

Como puedo hacer una edición por celdas de los campos de la base Stock

intente con:
WITH OBJECT oLbx:Costo
:bOnPostEdit := { | o, x, k | oRSSTK:Fields( "costo" ):Value := x } //PostEdit( o, x, k ) } // EditaCelda( oaufactu, 1, x, k, lFirstEdit ) } // PostEdit(o,x ...

... AliasRA autosort FASTEDIT LINES CELL font ofontBR // BACKGROUND aGrad HORIZONTAL
colorxbrw( oRApertur, .f. )
WITH OBJECT oRApertur:Nombre
:bOnPostEdit := { | o, x, k | RApertur->nombre := x } //PostEdit( o, x, k ) } // EditaCelda( oaufactu, 1, x, k, lFirstEdit ) } // PostEdit(o,x,k ...