472,958 Members | 2,185 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

[Fwd: Problems with PyGridTableBase]

--------- Mensaje reenviado --------
De: Mario Lacunza <ma***********@gmail.com>
Para: Lista Python Ing <py*********@python.org>
Asunto: Problems with PyGridTableBase
Fecha: Sat, 09 Sep 2006 00:03:20 -0500

Hello,

I attach two files:frmClientes and frmClientesNE.

frmClientes charge a Grid with resume Costumers data: Name, Commercial
ID, address, etc. and edition options.

frmClientes in

Line 178
def OnBtnNuevoButton(self, event):

call to frmClientesNE. Its append a new record to the database and clear
all controls and when I close it, the grid in frmClientes: grClte must
be recharge with the new data, but that dont work. Only work when a
Delete some record.

I couldnt send yours a runable .py version, because both of them files
pickup data from a Firebird's database.

I try to implement the wxPython Demo model: Grid_MegaExample, follow
that my class Grilla must be:

Line 224:
class Grilla(Grid.Grid):

but for the Boa Constructors controls creation I couldnt inherit from
Grid.Grid, thats my problem, I need your help I try for two days and
nothing :-( ... some ideas??

Thanks in advance!!

================================================== ====================
FILE: FRMCLIENTES.PY
================================================== ====================

# -*- coding: utf8 -*-#
#Boa:Frame:frmClientes

__version__='0.5'
__autor__='Mario Lacunza Vasquez <ml******@gmail.com>'

import wx
import wx.grid
import modGlobals
from Conectar import Conectar
import errores

def create(parent):
return frmClientes(parent)

[wxID_FRMCLIENTES, wxID_FRMCLIENTESBRNSALIR, wxID_FRMCLIENTESBTNBORRAR,
wxID_FRMCLIENTESBTNEDIT, wxID_FRMCLIENTESBTNNUEVO,
wxID_FRMCLIENTESGRCLTE,
wxID_FRMCLIENTESLBLTITULO, wxID_FRMCLIENTESPANEL1,
] = [wx.NewId() for _init_ctrls in range(8)]

class frmClientes(wx.Frame):
def _init_coll_fsGrid_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)

def _init_coll_fsGrid_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.grClte, 0, border=2, flag=wx.EXPAND |
wx.ALL)

def _init_coll_fsBtn_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.btnNuevo, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.btnEdit, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.btnBorrar, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.brnSalir, 0, border=2, flag=wx.EXPAND |
wx.ALL)

def _init_coll_fsTit_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.lblTitulo, 0, border=6, flag=wx.EXPAND)

def _init_coll_bsClte_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.panel1, 1, border=0, flag=wx.EXPAND)

def _init_coll_fsTit_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)

def _init_coll_fsClte_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)
parent.AddGrowableRow(1)
parent.AddGrowableRow(2)
parent.AddGrowableCol(0)

def _init_coll_fsClte_Items(self, parent):
# generated method, don't edit

parent.AddSizer(self.fsTit, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsGrid, 1, border=10,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsBtn, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)

def _init_sizers(self):
# generated method, don't edit
self.bsClte = wx.BoxSizer(orient=wx.VERTICAL)

self.fsClte = wx.FlexGridSizer(cols=1, hgap=0, rows=0, vgap=0)

self.fsTit = wx.FlexGridSizer(cols=1, hgap=0, rows=0, vgap=0)

self.fsGrid = wx.FlexGridSizer(cols=1, hgap=5, rows=0, vgap=5)

self.fsBtn = wx.FlexGridSizer(cols=4, hgap=0, rows=0, vgap=0)

self._init_coll_bsClte_Items(self.bsClte)
self._init_coll_fsClte_Growables(self.fsClte)
self._init_coll_fsClte_Items(self.fsClte)
self._init_coll_fsTit_Growables(self.fsTit)
self._init_coll_fsTit_Items(self.fsTit)
self._init_coll_fsGrid_Growables(self.fsGrid)
self._init_coll_fsGrid_Items(self.fsGrid)
self._init_coll_fsBtn_Items(self.fsBtn)

self.SetSizer(self.bsClte)
self.panel1.SetSizer(self.fsClte)

def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_FRMCLIENTES,
name=u'frmClientes',
parent=prnt, pos=wx.Point(352, 148), size=wx.Size(589,
514),
style=wx.DEFAULT_FRAME_STYLE, title=u'Clientes')
self.SetClientSize(wx.Size(589, 514))

self.panel1 = wx.Panel(id=wxID_FRMCLIENTESPANEL1, name='panel1',
parent=self, pos=wx.Point(0, 0), size=wx.Size(589, 514),
style=wx.TAB_TRAVERSAL)

self.lblTitulo = wx.StaticText(id=wxID_FRMCLIENTESLBLTITULO,
label=u'',
name=u'lblTitulo', parent=self.panel1, pos=wx.Point(258,
0),
size=wx.Size(72, 19), style=0)
self.lblTitulo.Center(wx.HORIZONTAL)
self.lblTitulo.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.BOLD,
False,
u'Sans'))

self.grClte = wx.grid.Grid(id=wxID_FRMCLIENTESGRCLTE,
name=u'grClte',
parent=self.panel1, pos=wx.Point(10, 63),
size=wx.Size(568, 326),
style=0)
self.grClte.EnableEditing(False)
self.grClte.Bind(wx.grid.EVT_GRID_SELECT_CELL,
self.OnGrClteGridSelectCell)

self.btnNuevo = wx.Button(id=wxID_FRMCLIENTESBTNNUEVO,
label=u'Nuevo',
name=u'btnNuevo', parent=self.panel1, pos=wx.Point(118,
435),
size=wx.Size(85, 34), style=0)
self.btnNuevo.SetToolTipString(u'Nuevo Cliente')
self.btnNuevo.Bind(wx.EVT_BUTTON, self.OnBtnNuevoButton,
id=wxID_FRMCLIENTESBTNNUEVO)

self.btnEdit = wx.Button(id=wxID_FRMCLIENTESBTNEDIT,
label=u'Editar',
name=u'btnEdit', parent=self.panel1, pos=wx.Point(207,
435),
size=wx.Size(85, 34), style=0)
self.btnEdit.SetToolTipString(u'Editar Cliente')
self.btnEdit.Bind(wx.EVT_BUTTON, self.OnBtnEditButton,
id=wxID_FRMCLIENTESBTNEDIT)

self.btnBorrar = wx.Button(id=wxID_FRMCLIENTESBTNBORRAR,
label=u'Eliminar', name=u'btnBorrar', parent=self.panel1,
pos=wx.Point(296, 435), size=wx.Size(85, 34), style=0)
self.btnBorrar.SetToolTipString(u'Eliminar Cliente')
self.btnBorrar.Bind(wx.EVT_BUTTON, self.OnBtnBorrarButton,
id=wxID_FRMCLIENTESBTNBORRAR)

self.brnSalir = wx.Button(id=wxID_FRMCLIENTESBRNSALIR,
label=u'Salir',
name=u'brnSalir', parent=self.panel1, pos=wx.Point(385,
435),
size=wx.Size(85, 34), style=0)
self.brnSalir.SetToolTipString(u'Salir')
self.brnSalir.Bind(wx.EVT_BUTTON, self.OnBrnSalirButton,
id=wxID_FRMCLIENTESBRNSALIR)

self._init_sizers()

def __init__(self, parent):
self._init_ctrls(parent)

self.CrearGrid()

#-------------------------------------------------------------------------------
def CrearGrid(self):
#Setea la Tabla para el Grid
self.table = Tabla()
self.grClte.SetTable(self.table, True)

#Setea el ancho de las columnas del Grid
self.grClte.SetColSize(0,50)
self.grClte.SetColSize(2,150)
self.grClte.SetColSize(4,250)

#-------------------------------------------------------------------------------

def OnBtnNuevoButton(self, event):
#Nuevo
import frmClientesNE
x=frmClientesNE.create(None,"N")
x.Show()

def OnBtnEditButton(self, event):
#Editar
import frmClientesNE
x=frmClientesNE.create(None,"E",self.Valor)
x.Show()

def OnBtnBorrarButton(self, event):
self.oD=D_Cltes()

dlg=wx.MessageDialog(self,u'¿Está seguro de eliminar este
Cliente?', \
'PymeGestor',wx.YES_NO | wx.ICON_QUESTION)
rpta=dlg.ShowModal()
if (rpta==wx.ID_YES):
self.oD.Borrar(self.Valor)
dlg2=wx.MessageDialog(self,u'El Cliente fue el eliminado con
éxito.', \
'PymeGestor',wx.OK | wx.ICON_INFORMATION)
dlg2.ShowModal()
dlg2.Destroy()
else:
pass

dlg.Destroy()

def OnBrnSalirButton(self, event):
self.Close(True)

def OnGrClteGridSelectCell(self, event):
#Obtiene el valor de la celda seleccionada.
self.R=event.GetRow()
#Fija como 0 la celda q contiene el campo ID.
self.C = 0

self.Valor=self.table.GetValue(self.R,self.C)

event.Skip()
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
class Tabla(wx.grid.PyGridTableBase):
"""Clase que maneja la grilla de Datos."""

def __init__(self):
wx.grid.PyGridTableBase.__init__(self)

self.oCltes=D_Cltes()
self.data=self.oCltes.CargarClientes()

#Setea el Numero de Columnas a mostrar por el SQL
self.Columnas=7

#Setea los titulos del Grid
self.colLabels = ["ID", "CODIGO", "CLIENTE", "NRO.DOC.",
"DIRECCION", "TELEFONO","EMAIL"]

def GetNumberRows(self):
r=len(self.data)
return r

def GetNumberCols(self):
return self.Columnas

def IsEmptyCell(self, row, col):
return False

def GetValue(self, row, col):
#Muestra los datos devueltos por el Recordset
value=self.data[row][col]
if value is not None:
return value
else:
return ''

def SetValue(self, row, col, value):
try:
self.data[row][col] = value
except IndexError:
# add a new row
self.data.append([''] * self.GetNumberCols())
self.SetValue(row, col, value)
# tell the grid we've added a row
msg = wxGridTableMessage(self, # The table
wxGRIDTABLE_NOTIFY_ROWS_APPENDED, # what we did to
it
1 # how many
)
self.GetView().ProcessTableMessage(msg)

def GetColLabelValue(self, col):
return self.colLabels[col]

#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------

class O_Cltes:
"""Clase de Negocios para el manejo de los Clientes."""
def __init__(self):
""" Constructor."""
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------

class D_Cltes:
"""Maneja las operaciones con clientes."""

mCodigo=None
mNombre=None
mTipoDoc=None
mNumDoc=None
mDireccion=None
mPostal=None
mFono1=None
mFono2=None
mFax=None
mEmail=None
mCelular=None
mWeb=None
mLinCredito=None

def __init__(self):
""" Constructor."""

#Instancia la Clase
self.cnn=Conectar()

#Obtiene cadena de Conexion
self.cnn.__class__.cnn=modGlobals.CNN

#-------------------------------------------------------------------------------

def CargarClientes(self):
"""Genera lista de Clientes."""

sql="Select ID, Codigo, Nombre, NumDoc, Direccion, Fono1, Email
from tblClientes"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
#-------------------------------------------------------------------------------
def Borrar(self, mCod):
"""Borra Cliente de la Bd."""

sql="Delete from tblClientes Where ID=%d"%(mCod)
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Delete')
return True

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
#-------------------------------------------------------------------------------

def CargaTDoc(self):

sql="Select ID, Detalle from tblTipoDoc"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#-------------------------------------------------------------------------------

def Graba(self):
"""Graba los datos."""

#Obtiene el codigo
self.__class__.mCodigo=self.GeneraCod()

sql="Insert into tblClientes(ID, CODIGO, NOMBRE, TIPODOC,
NUMDOC, DIRECCION, POSTAL,\
FONO1,FONO2,FAX, EMAIL, CELULAR, WEB, LINCREDITO)\
VALUES(GEN_ID(GEN_TBLCLIENTES_ID,1),\
'%s', '%s', %d, '%s', '%s','%s','%s','%s','%s','%s','%s','%s',%
d)"\
%(self.__class__.mCodigo, self.__class__.mNombre,
self.__class__.mTipoDoc, self.__class__.mNumDoc,\
self.__class__.mDireccion, self.__class__.mPostal,
self.__class__.mFono1,\
self.__class__.mFono2, self.__class__.mFax,
self.__class__.mEmail,\
self.__class__.mCelular, self.__class__.mWeb,
self.__class__.mLinCredito)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Insert')
if rs==False:
return False
else:
return True

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

self.CargarClientes()
#-------------------------------------------------------------------------------

def GeneraCod(self):
"""Genera el Codigo Unico para este cliente."""

sql="Select MAX(Codigo) from tblClientes"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#Si es el primer registro en la Tabla
if rs[0][0]==None:
cod=modGlobals.CrearCodigo('', 'C',9)
else:
cod=modGlobals.CrearCodigo(rs[0][0],'C', 9)

return cod

#-------------------------------------------------------------------------------

def Edita(self, mCod):
"""Edita los datos."""

sql="Update Where ID=%d" %(mCod)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Update')
if rs==False:
return False
else:
return True
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#-------------------------------------------------------------------------------
def BuscarClte(self,mCod):

sql="Select * From tblClientes Where ID=%d" %(mCod)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
================================================== ====================
================================================== ====================
================================================== ====================
================================================== ====================
FILE: FRMCLIENTESNE.PY
================================================== ====================

# -*- coding: utf8 -*-#
#Boa:Frame:Frame1

import wx
import modGlobals
from Conectar import Conectar
import errores
from frmClientes import D_Cltes

def create(parent, mTipo, mCodClte=''):
return Frame1(parent, mTipo, mCodClte)

[wxID_FRAME1, wxID_FRAME1BTNOK, wxID_FRAME1BTNSALIR,
wxID_FRAME1CBOTIPODOC,
wxID_FRAME1LBLCEL, wxID_FRAME1LBLCOD, wxID_FRAME1LBLCODIGO,
wxID_FRAME1LBLCP,
wxID_FRAME1LBLCTE, wxID_FRAME1LBLDIREC, wxID_FRAME1LBLEMAIL,
wxID_FRAME1LBLF1, wxID_FRAME1LBLF2, wxID_FRAME1LBLFAX,
wxID_FRAME1LBLLIN,
wxID_FRAME1LBLNUM, wxID_FRAME1LBLTD, wxID_FRAME1LBLWEB,
wxID_FRAME1PANEL1,
wxID_FRAME1TXTCELU, wxID_FRAME1TXTCLTE, wxID_FRAME1TXTDIREC,
wxID_FRAME1TXTEMAIL, wxID_FRAME1TXTFAX, wxID_FRAME1TXTFONO1,
wxID_FRAME1TXTFONO2, wxID_FRAME1TXTLINCRE, wxID_FRAME1TXTNUMDOC,
wxID_FRAME1TXTPOSTAL, wxID_FRAME1TXTWEB,
] = [wx.NewId() for _init_ctrls in range(30)]

class Frame1(wx.Frame):
TipoOper=None
CodClte=None

def _init_coll_fsClte_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)
parent.AddGrowableRow(1)
parent.AddGrowableCol(0)

def _init_coll_fsCtrls_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.lblCod, 0, border=5, flag=0)
parent.AddWindow(self.lblCodigo, 0, border=5, flag=0)
parent.AddWindow(self.lblCte, 0, border=5, flag=0)
parent.AddWindow(self.txtClte, 0, border=5, flag=0)
parent.AddWindow(self.lblTD, 0, border=5, flag=0)
parent.AddWindow(self.cboTipoDoc, 0, border=5, flag=0)
parent.AddWindow(self.lblNum, 0, border=5, flag=0)
parent.AddWindow(self.txtNumDoc, 0, border=5, flag=0)
parent.AddWindow(self.lblDirec, 0, border=5, flag=0)
parent.AddWindow(self.txtDirec, 0, border=5, flag=0)
parent.AddWindow(self.lblCP, 0, border=5, flag=0)
parent.AddWindow(self.txtPostal, 0, border=5, flag=0)
parent.AddWindow(self.lblF1, 0, border=5, flag=0)
parent.AddWindow(self.txtFono1, 0, border=5, flag=0)
parent.AddWindow(self.lblF2, 0, border=5, flag=0)
parent.AddWindow(self.txtFono2, 0, border=5, flag=0)
parent.AddWindow(self.lblFax, 0, border=5, flag=0)
parent.AddWindow(self.txtFax, 0, border=5, flag=0)
parent.AddWindow(self.lblEmail, 0, border=5, flag=0)
parent.AddWindow(self.txtEmail, 0, border=5, flag=0)
parent.AddWindow(self.lblWeb, 0, border=5, flag=0)
parent.AddWindow(self.txtWeb, 0, border=5, flag=0)
parent.AddWindow(self.lblCel, 0, border=5, flag=0)
parent.AddWindow(self.txtCelu, 0, border=5, flag=0)
parent.AddWindow(self.lblLin, 0, border=5, flag=0)
parent.AddWindow(self.txtLinCre, 0, border=5, flag=0)

def _init_coll_fsClte_Items(self, parent):
# generated method, don't edit

parent.AddSizer(self.fsCtrls, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsBtn, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)

def _init_coll_fsBtn_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.btnOk, 0, border=5, flag=wx.ALL |
wx.EXPAND)
parent.AddWindow(self.btnSalir, 0, border=5, flag=wx.ALL |
wx.EXPAND)

def _init_coll_bsClte_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.panel1, 0, border=0, flag=wx.EXPAND)

def _init_sizers(self):
# generated method, don't edit
self.bsClte = wx.BoxSizer(orient=wx.VERTICAL)

self.fsClte = wx.FlexGridSizer(cols=0, hgap=0, rows=2, vgap=0)

self.fsCtrls = wx.FlexGridSizer(cols=2, hgap=1, rows=0, vgap=2)

self.fsBtn = wx.FlexGridSizer(cols=2, hgap=0, rows=0, vgap=0)

self._init_coll_bsClte_Items(self.bsClte)
self._init_coll_fsClte_Items(self.fsClte)
self._init_coll_fsClte_Growables(self.fsClte)
self._init_coll_fsCtrls_Items(self.fsCtrls)
self._init_coll_fsBtn_Items(self.fsBtn)

self.SetSizer(self.bsClte)
self.panel1.SetSizer(self.fsClte)

def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_FRAME1, name='', parent=prnt,
pos=wx.Point(629, 243), size=wx.Size(263, 353),
style=wx.DEFAULT_FRAME_STYLE, title=u'Clientes')
self.SetClientSize(wx.Size(263, 353))

self.panel1 = wx.Panel(id=wxID_FRAME1PANEL1, name='panel1',
parent=self,
pos=wx.Point(0, 0), size=wx.Size(263, 348),
style=wx.TAB_TRAVERSAL)

self.lblCte = wx.StaticText(id=wxID_FRAME1LBLCTE,
label=u'Cliente',
name=u'lblCte', parent=self.panel1, pos=wx.Point(4, 14),
size=wx.Size(35, 12), style=0)

self.txtClte = wx.TextCtrl(id=wxID_FRAME1TXTCLTE,
name=u'txtClte',
parent=self.panel1, pos=wx.Point(58, 14),
size=wx.Size(200, 22),
style=0, value=u'')
self.txtClte.SetToolTipString(u'Nombre o Raz\xf3n Social')

self.lblTD = wx.StaticText(id=wxID_FRAME1LBLTD, label=u'Tipo
Doc.',
name=u'lblTD', parent=self.panel1, pos=wx.Point(4, 38),
size=wx.Size(45, 12), style=0)

self.cboTipoDoc = wx.ComboBox(choices=[],
id=wxID_FRAME1CBOTIPODOC,
name=u'cboTipoDoc', parent=self.panel1, pos=wx.Point(58,
38),
size=wx.Size(198, 24), style=0, value=u'')
self.cboTipoDoc.SetLabel(u'')
self.cboTipoDoc.Bind(wx.EVT_COMBOBOX, self.OnCboTipoDocCombobox,
id=wxID_FRAME1CBOTIPODOC)

self.lblNum = wx.StaticText(id=wxID_FRAME1LBLNUM, label=u'N
\xfamero',
name=u'lblNum', parent=self.panel1, pos=wx.Point(4, 64),
size=wx.Size(38, 12), style=0)

self.txtNumDoc = wx.TextCtrl(id=wxID_FRAME1TXTNUMDOC,
name=u'txtNumDoc',
parent=self.panel1, pos=wx.Point(58, 64), size=wx.Size(80,
22),
style=0, value=u'')
self.txtNumDoc.SetToolTipString(u'N\xfamero de Documento')

self.lblDirec = wx.StaticText(id=wxID_FRAME1LBLDIREC,
label=u'Direcci\xf3n', name=u'lblDirec',
parent=self.panel1,
pos=wx.Point(4, 88), size=wx.Size(47, 12), style=0)

self.txtDirec = wx.TextCtrl(id=wxID_FRAME1TXTDIREC,
name=u'txtDirec',
parent=self.panel1, pos=wx.Point(58, 88),
size=wx.Size(200, 22),
style=0, value=u'')
self.txtDirec.SetToolTipString(u'Direcci\xf3n')

self.lblCP = wx.StaticText(id=wxID_FRAME1LBLCP,
label=u'Cod.Postal',
name=u'lblCP', parent=self.panel1, pos=wx.Point(4, 112),
size=wx.Size(52, 12), style=0)

self.txtPostal = wx.TextCtrl(id=wxID_FRAME1TXTPOSTAL,
name=u'txtPostal',
parent=self.panel1, pos=wx.Point(58, 112),
size=wx.Size(80, 24),
style=0, value=u'')
self.txtPostal.SetToolTipString(u'C\xf3digo Postal')

self.lblF1 = wx.StaticText(id=wxID_FRAME1LBLF1, label=u'Tel
\xe9fono',
name=u'lblF1', parent=self.panel1, pos=wx.Point(4, 138),
size=wx.Size(39, 12), style=0)

self.txtFono1 = wx.TextCtrl(id=wxID_FRAME1TXTFONO1,
name=u'txtFono1',
parent=self.panel1, pos=wx.Point(58, 138),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblF2 = wx.StaticText(id=wxID_FRAME1LBLF2, label=u'Tel
\xe9fono',
name=u'lblF2', parent=self.panel1, pos=wx.Point(4, 162),
size=wx.Size(39, 12), style=0)

self.txtFono2 = wx.TextCtrl(id=wxID_FRAME1TXTFONO2,
name=u'txtFono2',
parent=self.panel1, pos=wx.Point(58, 162),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblFax = wx.StaticText(id=wxID_FRAME1LBLFAX, label=u'Fax',
name=u'lblFax', parent=self.panel1, pos=wx.Point(4, 186),
size=wx.Size(16, 12), style=0)

self.txtFax = wx.TextCtrl(id=wxID_FRAME1TXTFAX, name=u'txtFax',
parent=self.panel1, pos=wx.Point(58, 186),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblEmail = wx.StaticText(id=wxID_FRAME1LBLEMAIL,
label=u'Email',
name=u'lblEmail', parent=self.panel1, pos=wx.Point(4,
210),
size=wx.Size(27, 12), style=0)

self.txtEmail = wx.TextCtrl(id=wxID_FRAME1TXTEMAIL,
name=u'txtEmail',
parent=self.panel1, pos=wx.Point(58, 210),
size=wx.Size(192, 22),
style=0, value=u'@')

self.lblWeb = wx.StaticText(id=wxID_FRAME1LBLWEB,
label=u'Website',
name=u'lblWeb', parent=self.panel1, pos=wx.Point(4, 234),
size=wx.Size(36, 12), style=0)

self.txtWeb = wx.TextCtrl(id=wxID_FRAME1TXTWEB, name=u'txtWeb',
parent=self.panel1, pos=wx.Point(58, 234),
size=wx.Size(192, 22),
style=0, value=u'http://')

self.lblCel = wx.StaticText(id=wxID_FRAME1LBLCEL,
label=u'Celular',
name=u'lblCel', parent=self.panel1, pos=wx.Point(4, 258),
size=wx.Size(35, 12), style=0)

self.txtCelu = wx.TextCtrl(id=wxID_FRAME1TXTCELU,
name=u'txtCelu',
parent=self.panel1, pos=wx.Point(58, 258),
size=wx.Size(80, 22),
style=0, value=u'9')

self.lblLin = wx.StaticText(id=wxID_FRAME1LBLLIN,
label=u'Lin.Cr\xe9dito', name=u'lblLin',
parent=self.panel1,
pos=wx.Point(4, 282), size=wx.Size(53, 12), style=0)

self.txtLinCre = wx.TextCtrl(id=wxID_FRAME1TXTLINCRE,
name=u'txtLinCre',
parent=self.panel1, pos=wx.Point(58, 282),
size=wx.Size(80, 22),
style=0, value=u'0')
self.txtLinCre.SetToolTipString(u'Linea de Cr\xe9dito')

self.btnOk = wx.Button(id=wxID_FRAME1BTNOK, label=u'Aceptar',
name=u'btnOk', parent=self.panel1, pos=wx.Point(41, 309),
size=wx.Size(85, 34), style=0)
self.btnOk.SetToolTipString(u'Acepta cambios')
self.btnOk.Bind(wx.EVT_BUTTON, self.OnBtnOkButton,
id=wxID_FRAME1BTNOK)

self.btnSalir = wx.Button(id=wxID_FRAME1BTNSALIR,
label=u'Salir',
name=u'btnSalir', parent=self.panel1, pos=wx.Point(136,
309),
size=wx.Size(85, 34), style=0)
self.btnSalir.SetToolTipString(u'Salir')
self.btnSalir.Bind(wx.EVT_BUTTON, self.OnBtnSalirButton,
id=wxID_FRAME1BTNSALIR)

self.lblCod = wx.StaticText(id=wxID_FRAME1LBLCOD, label=u'C
\xf3digo',
name=u'lblCod', parent=self.panel1, pos=wx.Point(4, 0),
size=wx.Size(34, 12), style=0)

self.lblCodigo = wx.StaticText(id=wxID_FRAME1LBLCODIGO,
label=u'',
name=u'lblCodigo', parent=self.panel1, pos=wx.Point(58,
0),
size=wx.Size(150, 12), style=0)
self.lblCodigo.SetToolTipString(u'C\xf3digo Cliente')
self.lblCodigo.SetAutoLayout(False)

self._init_sizers()

def __init__(self, parent, mTipo, mCodClte):
self._init_ctrls(parent)

self.__class__.TipoOper=mTipo
self.__class__.CodClte=mCodClte
#Setea tamaños minimos
self.fsClte.Fit(self)
self.fsClte.SetSizeHints(self)

self.oClte=D_Cltes()

#Estableve el Encoding
self.encode='utf8'

self.CargarCombo()
self.CargaForm()

#-------------------------------------------------------------------------------

def CargaForm(self):

if self.__class__.TipoOper=="E":
self.dat=self.oClte.BuscarClte(self.__class__.CodC lte)
self.CargarCtrls()

#-------------------------------------------------------------------------------

def CargarCtrls(self):

self.lblCodigo.SetLabel(self.dat[0][1])
self.txtClte.SetValue(self.dat[0][2])
self.cboTipoDoc.SetSelection(self.dat[0][3]-1)
self.txtNumDoc.SetValue(self.dat[0][4])
self.txtDirec.SetValue(self.dat[0][5])
self.txtPostal.SetValue(self.dat[0][6])
self.txtFono1.SetValue(self.dat[0][7])
self.txtFono2.SetValue(self.dat[0][8])
self.txtFax.SetValue(self.dat[0][9])
self.txtEmail.SetValue(self.dat[0][10])
self.txtCelu.SetValue(self.dat[0][11])
self.txtWeb.SetValue(self.dat[0][12])
self.txtLinCre.SetValue(str(self.dat[0][13]))

#-------------------------------------------------------------------------------
def CargarCombo(self):

rs=self.oClte.CargaTDoc()

self.cboTipoDoc.Clear()

i=0

for it in rs:
x=unicode(rs[i][1],self.encode)
self.cboTipoDoc.Append(x,rs[i][0])
i+=1

if self.__class__.TipoOper=="N":
#Vacia el 1er elemento mostrado para q el user se vea
obligado a escoger
self.cboTipoDoc.SetValue('')
elif self.__class__.TipoOper=="E":
#Pinta el registro seleccionado
pass

#-------------------------------------------------------------------------------
def ObtieneValores(self):
self.oClte.__class__.mNombre=self.txtClte.GetValue ()
self.oClte.__class__.mTipoDoc=int(self.kTipoDoc)
self.oClte.__class__.mNumDoc=self.txtNumDoc.GetVal ue()
self.oClte.__class__.mDireccion=self.txtDirec.GetV alue()
self.oClte.__class__.mPostal=self.txtPostal.GetVal ue()
self.oClte.__class__.mFono1=self.txtFono1.GetValue ()
self.oClte.__class__.mFono2=self.txtFono2.GetValue ()
self.oClte.__class__.mFax=self.txtFax.GetValue()
self.oClte.__class__.mEmail=self.txtEmail.GetValue ()
self.oClte.__class__.mCelular=self.txtCelu.GetValu e()
self.oClte.__class__.mWeb=self.txtWeb.GetValue()
self.oClte.__class__.mLinCredito=int(self.txtLinCr e.GetValue())

#-------------------------------------------------------------------------------

def BorrarCtrls(self):
self.txtClte.Clear()
self.txtNumDoc.Clear()
self.txtDirec.Clear()
self.cboTipoDoc.Clear()
self.txtPostal.Clear()
self.txtFono1.Clear()
self.txtFono2.Clear()
self.txtFax.Clear()
self.txtEmail.Clear()
self.txtCelu.Clear()
self.txtWeb.Clear()
self.txtLinCre.Clear()

#-------------------------------------------------------------------------------

def OnBtnOkButton(self, event):

self.ObtieneValores()

if self.__class__.TipoOper=="N":
if self.oClte.Graba()==True:
dlg=wx.MessageDialog(self,u'Se ingresó el nuevo
Cliente.', \
'PymeGestor',wx.OK | wx.ICON_EXCLAMATION)
dlg.ShowModal()
dlg.Destroy()
self.BorrarCtrls()
self.txtClte.SetFocus()

else:
dlg=wx.MessageDialog(self,u'Hubo un error al ingresar
los datos.\
Corrija y vuelva a intentarlo.','PymeGestor',wx.OK |
wx.ICON_ERROR)
dlg.ShowModal()
dlg.Destroy()
self.txtClte.SetFocus()

elif self.__class__.TipoOper=="E":
self.oClte.Edita()
else:
pass

#-------------------------------------------------------------------------------

def OnBtnSalirButton(self, event):
self.Close(True)

#-------------------------------------------------------------------------------

def OnCboTipoDocCombobox(self, event):
cb = event.GetEventObject()
#Obtengo el Key
self.kTipoDoc = cb.GetClientData(cb.GetSelection())

#-------------------------------------------------------------------------------

================================================== ===========================
================================================== ===========================

--
Mario Lacunza <ma***********@gmail.com>

Sep 9 '06 #1
1 1730
Hopefully this helps keep your post alive.. I looked all over the
internet for examples written with wxgrid and wxgrid with python and
haven't realy found out how to add the other functions to a
boa-constructor program there just isn't anything except the simple
example incuded with boa. This is as far as I got and I am not sure I
am very close (with my example trying to add the extra functions to the
class instead of inheriting it from grid)

#Boa:Frame:Frame3

import wx
import wx.grid

def create(parent):
return Frame3(parent)

[wxID_FRAME3, wxID_FRAME3BUTTON1, wxID_FRAME3GRID1,
wxID_FRAME3TEXTCTRL1,
] = [wx.NewId() for _init_ctrls in range(4)]

class Frame3(wx.Frame):
def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_FRAME3, name='', parent=prnt,
pos=wx.Point(401, 118), size=wx.Size(367, 585),
style=wx.DOUBLE_BORDER, title=u'')
self.SetClientSize(wx.Size(361, 579))

self.grid1 = wx.grid.Grid(id=wxID_FRAME3GRID1, name='grid1',
parent=self, pos=wx.Point(8, 16), size=wx.Size(80, 392),
style=wx.WANTS_CHARS | wx.TRANSPARENT_WINDOW |
wx.MINIMIZE_BOX | wx.DOUBLE_BORDER | wx.VSCROLL)

self.textCtrl1 = wx.TextCtrl(id=wxID_FRAME3TEXTCTRL1,
name='textCtrl1',
parent=self, pos=wx.Point(112, 16), size=wx.Size(232,
392),
style=wx.TE_LINEWRAP, value=u'')
self.textCtrl1.SetThemeEnabled(False)
self.textCtrl1.SetCursor(wx.CROSS_CURSOR)

self.button1 = wx.Button(id=wxID_FRAME3BUTTON1, label=u'exit',
name='button1', parent=self, pos=wx.Point(72, 440),
size=wx.Size(136, 23), style=0)
self.button1.Bind(wx.EVT_BUTTON, self.OnButton1Button,
id=wxID_FRAME3BUTTON1)

def __init__(self, parent):
self._init_ctrls(parent)
self.grid1.CreateGrid(0, 1)

def OnButton1Button(self, event):
self.Close()
def update_instument_list(csndname):
csdInstrumentList(csndname) #needs to have a file variable..
noinlist=0
for number in range(0,noinlist):
self.grid1.AppendRows(1)
self.grid1.SetCellValue(number,0,instrlist[number])

http://www.dexrow.com

Mario Lacunza wrote:
--------- Mensaje reenviado --------
De: Mario Lacunza <ma***********@gmail.com>
Para: Lista Python Ing <py*********@python.org>
Asunto: Problems with PyGridTableBase
Fecha: Sat, 09 Sep 2006 00:03:20 -0500

Hello,

I attach two files:frmClientes and frmClientesNE.

frmClientes charge a Grid with resume Costumers data: Name, Commercial
ID, address, etc. and edition options.

frmClientes in

Line 178
def OnBtnNuevoButton(self, event):

call to frmClientesNE. Its append a new record to the database and clear
all controls and when I close it, the grid in frmClientes: grClte must
be recharge with the new data, but that dont work. Only work when a
Delete some record.

I couldnt send yours a runable .py version, because both of them files
pickup data from a Firebird's database.

I try to implement the wxPython Demo model: Grid_MegaExample, follow
that my class Grilla must be:

Line 224:
class Grilla(Grid.Grid):

but for the Boa Constructors controls creation I couldnt inherit from
Grid.Grid, thats my problem, I need your help I try for two days and
nothing :-( ... some ideas??

Thanks in advance!!

================================================== ====================
FILE: FRMCLIENTES.PY
================================================== ====================

# -*- coding: utf8 -*-#
#Boa:Frame:frmClientes

__version__='0.5'
__autor__='Mario Lacunza Vasquez <ml******@gmail.com>'

import wx
import wx.grid
import modGlobals
from Conectar import Conectar
import errores

def create(parent):
return frmClientes(parent)

[wxID_FRMCLIENTES, wxID_FRMCLIENTESBRNSALIR, wxID_FRMCLIENTESBTNBORRAR,
wxID_FRMCLIENTESBTNEDIT, wxID_FRMCLIENTESBTNNUEVO,
wxID_FRMCLIENTESGRCLTE,
wxID_FRMCLIENTESLBLTITULO, wxID_FRMCLIENTESPANEL1,
] = [wx.NewId() for _init_ctrls in range(8)]

class frmClientes(wx.Frame):
def _init_coll_fsGrid_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)

def _init_coll_fsGrid_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.grClte, 0, border=2, flag=wx.EXPAND |
wx.ALL)

def _init_coll_fsBtn_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.btnNuevo, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.btnEdit, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.btnBorrar, 0, border=2, flag=wx.EXPAND |
wx.ALL)
parent.AddWindow(self.brnSalir, 0, border=2, flag=wx.EXPAND |
wx.ALL)

def _init_coll_fsTit_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.lblTitulo, 0, border=6, flag=wx.EXPAND)

def _init_coll_bsClte_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.panel1, 1, border=0, flag=wx.EXPAND)

def _init_coll_fsTit_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)

def _init_coll_fsClte_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)
parent.AddGrowableRow(1)
parent.AddGrowableRow(2)
parent.AddGrowableCol(0)

def _init_coll_fsClte_Items(self, parent):
# generated method, don't edit

parent.AddSizer(self.fsTit, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsGrid, 1, border=10,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsBtn, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)

def _init_sizers(self):
# generated method, don't edit
self.bsClte = wx.BoxSizer(orient=wx.VERTICAL)

self.fsClte = wx.FlexGridSizer(cols=1, hgap=0, rows=0, vgap=0)

self.fsTit = wx.FlexGridSizer(cols=1, hgap=0, rows=0, vgap=0)

self.fsGrid = wx.FlexGridSizer(cols=1, hgap=5, rows=0, vgap=5)

self.fsBtn = wx.FlexGridSizer(cols=4, hgap=0, rows=0, vgap=0)

self._init_coll_bsClte_Items(self.bsClte)
self._init_coll_fsClte_Growables(self.fsClte)
self._init_coll_fsClte_Items(self.fsClte)
self._init_coll_fsTit_Growables(self.fsTit)
self._init_coll_fsTit_Items(self.fsTit)
self._init_coll_fsGrid_Growables(self.fsGrid)
self._init_coll_fsGrid_Items(self.fsGrid)
self._init_coll_fsBtn_Items(self.fsBtn)

self.SetSizer(self.bsClte)
self.panel1.SetSizer(self.fsClte)

def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_FRMCLIENTES,
name=u'frmClientes',
parent=prnt, pos=wx.Point(352, 148), size=wx.Size(589,
514),
style=wx.DEFAULT_FRAME_STYLE, title=u'Clientes')
self.SetClientSize(wx.Size(589, 514))

self.panel1 = wx.Panel(id=wxID_FRMCLIENTESPANEL1, name='panel1',
parent=self, pos=wx.Point(0, 0), size=wx.Size(589, 514),
style=wx.TAB_TRAVERSAL)

self.lblTitulo = wx.StaticText(id=wxID_FRMCLIENTESLBLTITULO,
label=u'',
name=u'lblTitulo', parent=self.panel1, pos=wx.Point(258,
0),
size=wx.Size(72, 19), style=0)
self.lblTitulo.Center(wx.HORIZONTAL)
self.lblTitulo.SetFont(wx.Font(12, wx.SWISS, wx.NORMAL, wx.BOLD,
False,
u'Sans'))

self.grClte = wx.grid.Grid(id=wxID_FRMCLIENTESGRCLTE,
name=u'grClte',
parent=self.panel1, pos=wx.Point(10, 63),
size=wx.Size(568, 326),
style=0)
self.grClte.EnableEditing(False)
self.grClte.Bind(wx.grid.EVT_GRID_SELECT_CELL,
self.OnGrClteGridSelectCell)

self.btnNuevo = wx.Button(id=wxID_FRMCLIENTESBTNNUEVO,
label=u'Nuevo',
name=u'btnNuevo', parent=self.panel1, pos=wx.Point(118,
435),
size=wx.Size(85, 34), style=0)
self.btnNuevo.SetToolTipString(u'Nuevo Cliente')
self.btnNuevo.Bind(wx.EVT_BUTTON, self.OnBtnNuevoButton,
id=wxID_FRMCLIENTESBTNNUEVO)

self.btnEdit = wx.Button(id=wxID_FRMCLIENTESBTNEDIT,
label=u'Editar',
name=u'btnEdit', parent=self.panel1, pos=wx.Point(207,
435),
size=wx.Size(85, 34), style=0)
self.btnEdit.SetToolTipString(u'Editar Cliente')
self.btnEdit.Bind(wx.EVT_BUTTON, self.OnBtnEditButton,
id=wxID_FRMCLIENTESBTNEDIT)

self.btnBorrar = wx.Button(id=wxID_FRMCLIENTESBTNBORRAR,
label=u'Eliminar', name=u'btnBorrar', parent=self.panel1,
pos=wx.Point(296, 435), size=wx.Size(85, 34), style=0)
self.btnBorrar.SetToolTipString(u'Eliminar Cliente')
self.btnBorrar.Bind(wx.EVT_BUTTON, self.OnBtnBorrarButton,
id=wxID_FRMCLIENTESBTNBORRAR)

self.brnSalir = wx.Button(id=wxID_FRMCLIENTESBRNSALIR,
label=u'Salir',
name=u'brnSalir', parent=self.panel1, pos=wx.Point(385,
435),
size=wx.Size(85, 34), style=0)
self.brnSalir.SetToolTipString(u'Salir')
self.brnSalir.Bind(wx.EVT_BUTTON, self.OnBrnSalirButton,
id=wxID_FRMCLIENTESBRNSALIR)

self._init_sizers()

def __init__(self, parent):
self._init_ctrls(parent)

self.CrearGrid()

#-------------------------------------------------------------------------------
def CrearGrid(self):
#Setea la Tabla para el Grid
self.table = Tabla()
self.grClte.SetTable(self.table, True)

#Setea el ancho de las columnas del Grid
self.grClte.SetColSize(0,50)
self.grClte.SetColSize(2,150)
self.grClte.SetColSize(4,250)

#-------------------------------------------------------------------------------

def OnBtnNuevoButton(self, event):
#Nuevo
import frmClientesNE
x=frmClientesNE.create(None,"N")
x.Show()

def OnBtnEditButton(self, event):
#Editar
import frmClientesNE
x=frmClientesNE.create(None,"E",self.Valor)
x.Show()

def OnBtnBorrarButton(self, event):
self.oD=D_Cltes()

dlg=wx.MessageDialog(self,u'Est seguro de eliminar este
Cliente?', \
'PymeGestor',wx.YES_NO | wx.ICON_QUESTION)
rpta=dlg.ShowModal()
if (rpta==wx.ID_YES):
self.oD.Borrar(self.Valor)
dlg2=wx.MessageDialog(self,u'El Cliente fue el eliminado con
xito.', \
'PymeGestor',wx.OK | wx.ICON_INFORMATION)
dlg2.ShowModal()
dlg2.Destroy()
else:
pass

dlg.Destroy()

def OnBrnSalirButton(self, event):
self.Close(True)

def OnGrClteGridSelectCell(self, event):
#Obtiene el valor de la celda seleccionada.
self.R=event.GetRow()
#Fija como 0 la celda q contiene el campo ID.
self.C = 0

self.Valor=self.table.GetValue(self.R,self.C)

event.Skip()
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------
class Tabla(wx.grid.PyGridTableBase):
"""Clase que maneja la grilla de Datos."""

def __init__(self):
wx.grid.PyGridTableBase.__init__(self)

self.oCltes=D_Cltes()
self.data=self.oCltes.CargarClientes()

#Setea el Numero de Columnas a mostrar por el SQL
self.Columnas=7

#Setea los titulos del Grid
self.colLabels = ["ID", "CODIGO", "CLIENTE", "NRO.DOC.",
"DIRECCION", "TELEFONO","EMAIL"]

def GetNumberRows(self):
r=len(self.data)
return r

def GetNumberCols(self):
return self.Columnas

def IsEmptyCell(self, row, col):
return False

def GetValue(self, row, col):
#Muestra los datos devueltos por el Recordset
value=self.data[row][col]
if value is not None:
return value
else:
return ''

def SetValue(self, row, col, value):
try:
self.data[row][col] = value
except IndexError:
# add a new row
self.data.append([''] * self.GetNumberCols())
self.SetValue(row, col, value)
# tell the grid we've added a row
msg = wxGridTableMessage(self, # The table
wxGRIDTABLE_NOTIFY_ROWS_APPENDED, # what we did to
it
1 # how many
)
self.GetView().ProcessTableMessage(msg)

def GetColLabelValue(self, col):
return self.colLabels[col]

#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------

class O_Cltes:
"""Clase de Negocios para el manejo de los Clientes."""
def __init__(self):
""" Constructor."""
#-------------------------------------------------------------------------------
#-------------------------------------------------------------------------------

class D_Cltes:
"""Maneja las operaciones con clientes."""

mCodigo=None
mNombre=None
mTipoDoc=None
mNumDoc=None
mDireccion=None
mPostal=None
mFono1=None
mFono2=None
mFax=None
mEmail=None
mCelular=None
mWeb=None
mLinCredito=None

def __init__(self):
""" Constructor."""

#Instancia la Clase
self.cnn=Conectar()

#Obtiene cadena de Conexion
self.cnn.__class__.cnn=modGlobals.CNN

#-------------------------------------------------------------------------------

def CargarClientes(self):
"""Genera lista de Clientes."""

sql="Select ID, Codigo, Nombre, NumDoc, Direccion, Fono1, Email
from tblClientes"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
#-------------------------------------------------------------------------------
def Borrar(self, mCod):
"""Borra Cliente de la Bd."""

sql="Delete from tblClientes Where ID=%d"%(mCod)
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Delete')
return True

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
#-------------------------------------------------------------------------------

def CargaTDoc(self):

sql="Select ID, Detalle from tblTipoDoc"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#-------------------------------------------------------------------------------

def Graba(self):
"""Graba los datos."""

#Obtiene el codigo
self.__class__.mCodigo=self.GeneraCod()

sql="Insert into tblClientes(ID, CODIGO, NOMBRE, TIPODOC,
NUMDOC, DIRECCION, POSTAL,\
FONO1,FONO2,FAX, EMAIL, CELULAR, WEB, LINCREDITO)\
VALUES(GEN_ID(GEN_TBLCLIENTES_ID,1),\
'%s', '%s', %d, '%s', '%s','%s','%s','%s','%s','%s','%s','%s',%
d)"\
%(self.__class__.mCodigo, self.__class__.mNombre,
self.__class__.mTipoDoc, self.__class__.mNumDoc,\
self.__class__.mDireccion, self.__class__.mPostal,
self.__class__.mFono1,\
self.__class__.mFono2, self.__class__.mFax,
self.__class__.mEmail,\
self.__class__.mCelular, self.__class__.mWeb,
self.__class__.mLinCredito)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Insert')
if rs==False:
return False
else:
return True

except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

self.CargarClientes()
#-------------------------------------------------------------------------------

def GeneraCod(self):
"""Genera el Codigo Unico para este cliente."""

sql="Select MAX(Codigo) from tblClientes"
self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#Si es el primer registro en la Tabla
if rs[0][0]==None:
cod=modGlobals.CrearCodigo('', 'C',9)
else:
cod=modGlobals.CrearCodigo(rs[0][0],'C', 9)

return cod

#-------------------------------------------------------------------------------

def Edita(self, mCod):
"""Edita los datos."""

sql="Update Where ID=%d" %(mCod)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL('Update')
if rs==False:
return False
else:
return True
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec

#-------------------------------------------------------------------------------
def BuscarClte(self,mCod):

sql="Select * From tblClientes Where ID=%d" %(mCod)

self.cnn.__class__.SQL=sql

try:
rs=self.cnn.EjecutarSQL()
return rs
except errores.ConexionError, err:
print "Error:",err.mensaje
except errores.ConexionEjecucionError, err:
print "Error:",err.msgEjec
================================================== ====================
================================================== ====================
================================================== ====================
================================================== ====================
FILE: FRMCLIENTESNE.PY
================================================== ====================

# -*- coding: utf8 -*-#
#Boa:Frame:Frame1

import wx
import modGlobals
from Conectar import Conectar
import errores
from frmClientes import D_Cltes

def create(parent, mTipo, mCodClte=''):
return Frame1(parent, mTipo, mCodClte)

[wxID_FRAME1, wxID_FRAME1BTNOK, wxID_FRAME1BTNSALIR,
wxID_FRAME1CBOTIPODOC,
wxID_FRAME1LBLCEL, wxID_FRAME1LBLCOD, wxID_FRAME1LBLCODIGO,
wxID_FRAME1LBLCP,
wxID_FRAME1LBLCTE, wxID_FRAME1LBLDIREC, wxID_FRAME1LBLEMAIL,
wxID_FRAME1LBLF1, wxID_FRAME1LBLF2, wxID_FRAME1LBLFAX,
wxID_FRAME1LBLLIN,
wxID_FRAME1LBLNUM, wxID_FRAME1LBLTD, wxID_FRAME1LBLWEB,
wxID_FRAME1PANEL1,
wxID_FRAME1TXTCELU, wxID_FRAME1TXTCLTE, wxID_FRAME1TXTDIREC,
wxID_FRAME1TXTEMAIL, wxID_FRAME1TXTFAX, wxID_FRAME1TXTFONO1,
wxID_FRAME1TXTFONO2, wxID_FRAME1TXTLINCRE, wxID_FRAME1TXTNUMDOC,
wxID_FRAME1TXTPOSTAL, wxID_FRAME1TXTWEB,
] = [wx.NewId() for _init_ctrls in range(30)]

class Frame1(wx.Frame):
TipoOper=None
CodClte=None

def _init_coll_fsClte_Growables(self, parent):
# generated method, don't edit

parent.AddGrowableRow(0)
parent.AddGrowableRow(1)
parent.AddGrowableCol(0)

def _init_coll_fsCtrls_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.lblCod, 0, border=5, flag=0)
parent.AddWindow(self.lblCodigo, 0, border=5, flag=0)
parent.AddWindow(self.lblCte, 0, border=5, flag=0)
parent.AddWindow(self.txtClte, 0, border=5, flag=0)
parent.AddWindow(self.lblTD, 0, border=5, flag=0)
parent.AddWindow(self.cboTipoDoc, 0, border=5, flag=0)
parent.AddWindow(self.lblNum, 0, border=5, flag=0)
parent.AddWindow(self.txtNumDoc, 0, border=5, flag=0)
parent.AddWindow(self.lblDirec, 0, border=5, flag=0)
parent.AddWindow(self.txtDirec, 0, border=5, flag=0)
parent.AddWindow(self.lblCP, 0, border=5, flag=0)
parent.AddWindow(self.txtPostal, 0, border=5, flag=0)
parent.AddWindow(self.lblF1, 0, border=5, flag=0)
parent.AddWindow(self.txtFono1, 0, border=5, flag=0)
parent.AddWindow(self.lblF2, 0, border=5, flag=0)
parent.AddWindow(self.txtFono2, 0, border=5, flag=0)
parent.AddWindow(self.lblFax, 0, border=5, flag=0)
parent.AddWindow(self.txtFax, 0, border=5, flag=0)
parent.AddWindow(self.lblEmail, 0, border=5, flag=0)
parent.AddWindow(self.txtEmail, 0, border=5, flag=0)
parent.AddWindow(self.lblWeb, 0, border=5, flag=0)
parent.AddWindow(self.txtWeb, 0, border=5, flag=0)
parent.AddWindow(self.lblCel, 0, border=5, flag=0)
parent.AddWindow(self.txtCelu, 0, border=5, flag=0)
parent.AddWindow(self.lblLin, 0, border=5, flag=0)
parent.AddWindow(self.txtLinCre, 0, border=5, flag=0)

def _init_coll_fsClte_Items(self, parent):
# generated method, don't edit

parent.AddSizer(self.fsCtrls, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)
parent.AddSizer(self.fsBtn, 1, border=5,
flag=wx.ALIGN_CENTER_HORIZONTAL)

def _init_coll_fsBtn_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.btnOk, 0, border=5, flag=wx.ALL |
wx.EXPAND)
parent.AddWindow(self.btnSalir, 0, border=5, flag=wx.ALL |
wx.EXPAND)

def _init_coll_bsClte_Items(self, parent):
# generated method, don't edit

parent.AddWindow(self.panel1, 0, border=0, flag=wx.EXPAND)

def _init_sizers(self):
# generated method, don't edit
self.bsClte = wx.BoxSizer(orient=wx.VERTICAL)

self.fsClte = wx.FlexGridSizer(cols=0, hgap=0, rows=2, vgap=0)

self.fsCtrls = wx.FlexGridSizer(cols=2, hgap=1, rows=0, vgap=2)

self.fsBtn = wx.FlexGridSizer(cols=2, hgap=0, rows=0, vgap=0)

self._init_coll_bsClte_Items(self.bsClte)
self._init_coll_fsClte_Items(self.fsClte)
self._init_coll_fsClte_Growables(self.fsClte)
self._init_coll_fsCtrls_Items(self.fsCtrls)
self._init_coll_fsBtn_Items(self.fsBtn)

self.SetSizer(self.bsClte)
self.panel1.SetSizer(self.fsClte)

def _init_ctrls(self, prnt):
# generated method, don't edit
wx.Frame.__init__(self, id=wxID_FRAME1, name='', parent=prnt,
pos=wx.Point(629, 243), size=wx.Size(263, 353),
style=wx.DEFAULT_FRAME_STYLE, title=u'Clientes')
self.SetClientSize(wx.Size(263, 353))

self.panel1 = wx.Panel(id=wxID_FRAME1PANEL1, name='panel1',
parent=self,
pos=wx.Point(0, 0), size=wx.Size(263, 348),
style=wx.TAB_TRAVERSAL)

self.lblCte = wx.StaticText(id=wxID_FRAME1LBLCTE,
label=u'Cliente',
name=u'lblCte', parent=self.panel1, pos=wx.Point(4, 14),
size=wx.Size(35, 12), style=0)

self.txtClte = wx.TextCtrl(id=wxID_FRAME1TXTCLTE,
name=u'txtClte',
parent=self.panel1, pos=wx.Point(58, 14),
size=wx.Size(200, 22),
style=0, value=u'')
self.txtClte.SetToolTipString(u'Nombre o Raz\xf3n Social')

self.lblTD = wx.StaticText(id=wxID_FRAME1LBLTD, label=u'Tipo
Doc.',
name=u'lblTD', parent=self.panel1, pos=wx.Point(4, 38),
size=wx.Size(45, 12), style=0)

self.cboTipoDoc = wx.ComboBox(choices=[],
id=wxID_FRAME1CBOTIPODOC,
name=u'cboTipoDoc', parent=self.panel1, pos=wx.Point(58,
38),
size=wx.Size(198, 24), style=0, value=u'')
self.cboTipoDoc.SetLabel(u'')
self.cboTipoDoc.Bind(wx.EVT_COMBOBOX, self.OnCboTipoDocCombobox,
id=wxID_FRAME1CBOTIPODOC)

self.lblNum = wx.StaticText(id=wxID_FRAME1LBLNUM, label=u'N
\xfamero',
name=u'lblNum', parent=self.panel1, pos=wx.Point(4, 64),
size=wx.Size(38, 12), style=0)

self.txtNumDoc = wx.TextCtrl(id=wxID_FRAME1TXTNUMDOC,
name=u'txtNumDoc',
parent=self.panel1, pos=wx.Point(58, 64), size=wx.Size(80,
22),
style=0, value=u'')
self.txtNumDoc.SetToolTipString(u'N\xfamero de Documento')

self.lblDirec = wx.StaticText(id=wxID_FRAME1LBLDIREC,
label=u'Direcci\xf3n', name=u'lblDirec',
parent=self.panel1,
pos=wx.Point(4, 88), size=wx.Size(47, 12), style=0)

self.txtDirec = wx.TextCtrl(id=wxID_FRAME1TXTDIREC,
name=u'txtDirec',
parent=self.panel1, pos=wx.Point(58, 88),
size=wx.Size(200, 22),
style=0, value=u'')
self.txtDirec.SetToolTipString(u'Direcci\xf3n')

self.lblCP = wx.StaticText(id=wxID_FRAME1LBLCP,
label=u'Cod.Postal',
name=u'lblCP', parent=self.panel1, pos=wx.Point(4, 112),
size=wx.Size(52, 12), style=0)

self.txtPostal = wx.TextCtrl(id=wxID_FRAME1TXTPOSTAL,
name=u'txtPostal',
parent=self.panel1, pos=wx.Point(58, 112),
size=wx.Size(80, 24),
style=0, value=u'')
self.txtPostal.SetToolTipString(u'C\xf3digo Postal')

self.lblF1 = wx.StaticText(id=wxID_FRAME1LBLF1, label=u'Tel
\xe9fono',
name=u'lblF1', parent=self.panel1, pos=wx.Point(4, 138),
size=wx.Size(39, 12), style=0)

self.txtFono1 = wx.TextCtrl(id=wxID_FRAME1TXTFONO1,
name=u'txtFono1',
parent=self.panel1, pos=wx.Point(58, 138),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblF2 = wx.StaticText(id=wxID_FRAME1LBLF2, label=u'Tel
\xe9fono',
name=u'lblF2', parent=self.panel1, pos=wx.Point(4, 162),
size=wx.Size(39, 12), style=0)

self.txtFono2 = wx.TextCtrl(id=wxID_FRAME1TXTFONO2,
name=u'txtFono2',
parent=self.panel1, pos=wx.Point(58, 162),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblFax = wx.StaticText(id=wxID_FRAME1LBLFAX, label=u'Fax',
name=u'lblFax', parent=self.panel1, pos=wx.Point(4, 186),
size=wx.Size(16, 12), style=0)

self.txtFax = wx.TextCtrl(id=wxID_FRAME1TXTFAX, name=u'txtFax',
parent=self.panel1, pos=wx.Point(58, 186),
size=wx.Size(80, 22),
style=0, value=u'')

self.lblEmail = wx.StaticText(id=wxID_FRAME1LBLEMAIL,
label=u'Email',
name=u'lblEmail', parent=self.panel1, pos=wx.Point(4,
210),
size=wx.Size(27, 12), style=0)

self.txtEmail = wx.TextCtrl(id=wxID_FRAME1TXTEMAIL,
name=u'txtEmail',
parent=self.panel1, pos=wx.Point(58, 210),
size=wx.Size(192, 22),
style=0, value=u'@')

self.lblWeb = wx.StaticText(id=wxID_FRAME1LBLWEB,
label=u'Website',
name=u'lblWeb', parent=self.panel1, pos=wx.Point(4, 234),
size=wx.Size(36, 12), style=0)

self.txtWeb = wx.TextCtrl(id=wxID_FRAME1TXTWEB, name=u'txtWeb',
parent=self.panel1, pos=wx.Point(58, 234),
size=wx.Size(192, 22),
style=0, value=u'http://')

self.lblCel = wx.StaticText(id=wxID_FRAME1LBLCEL,
label=u'Celular',
name=u'lblCel', parent=self.panel1, pos=wx.Point(4, 258),
size=wx.Size(35, 12), style=0)

self.txtCelu = wx.TextCtrl(id=wxID_FRAME1TXTCELU,
name=u'txtCelu',
parent=self.panel1, pos=wx.Point(58, 258),
size=wx.Size(80, 22),
style=0, value=u'9')

self.lblLin = wx.StaticText(id=wxID_FRAME1LBLLIN,
label=u'Lin.Cr\xe9dito', name=u'lblLin',
parent=self.panel1,
pos=wx.Point(4, 282), size=wx.Size(53, 12), style=0)

self.txtLinCre = wx.TextCtrl(id=wxID_FRAME1TXTLINCRE,
name=u'txtLinCre',
parent=self.panel1, pos=wx.Point(58, 282),
size=wx.Size(80, 22),
style=0, value=u'0')
self.txtLinCre.SetToolTipString(u'Linea de Cr\xe9dito')

self.btnOk = wx.Button(id=wxID_FRAME1BTNOK, label=u'Aceptar',
name=u'btnOk', parent=self.panel1, pos=wx.Point(41, 309),
size=wx.Size(85, 34), style=0)
self.btnOk.SetToolTipString(u'Acepta cambios')
self.btnOk.Bind(wx.EVT_BUTTON, self.OnBtnOkButton,
id=wxID_FRAME1BTNOK)

self.btnSalir = wx.Button(id=wxID_FRAME1BTNSALIR,
label=u'Salir',
name=u'btnSalir', parent=self.panel1, pos=wx.Point(136,
309),
size=wx.Size(85, 34), style=0)
self.btnSalir.SetToolTipString(u'Salir')
self.btnSalir.Bind(wx.EVT_BUTTON, self.OnBtnSalirButton,
id=wxID_FRAME1BTNSALIR)

self.lblCod = wx.StaticText(id=wxID_FRAME1LBLCOD, label=u'C
\xf3digo',
name=u'lblCod', parent=self.panel1, pos=wx.Point(4, 0),
size=wx.Size(34, 12), style=0)

self.lblCodigo = wx.StaticText(id=wxID_FRAME1LBLCODIGO,
label=u'',
name=u'lblCodigo', parent=self.panel1, pos=wx.Point(58,
0),
size=wx.Size(150, 12), style=0)
self.lblCodigo.SetToolTipString(u'C\xf3digo Cliente')
self.lblCodigo.SetAutoLayout(False)

self._init_sizers()

def __init__(self, parent, mTipo, mCodClte):
self._init_ctrls(parent)

self.__class__.TipoOper=mTipo
self.__class__.CodClte=mCodClte
#Setea tamaos minimos
self.fsClte.Fit(self)
self.fsClte.SetSizeHints(self)

self.oClte=D_Cltes()

#Estableve el Encoding
self.encode='utf8'

self.CargarCombo()
self.CargaForm()

#-------------------------------------------------------------------------------

def CargaForm(self):

if self.__class__.TipoOper=="E":
self.dat=self.oClte.BuscarClte(self.__class__.CodC lte)
self.CargarCtrls()

#-------------------------------------------------------------------------------

def CargarCtrls(self):

self.lblCodigo.SetLabel(self.dat[0][1])
self.txtClte.SetValue(self.dat[0][2])
self.cboTipoDoc.SetSelection(self.dat[0][3]-1)
self.txtNumDoc.SetValue(self.dat[0][4])
self.txtDirec.SetValue(self.dat[0][5])
self.txtPostal.SetValue(self.dat[0][6])
self.txtFono1.SetValue(self.dat[0][7])
self.txtFono2.SetValue(self.dat[0][8])
self.txtFax.SetValue(self.dat[0][9])
self.txtEmail.SetValue(self.dat[0][10])
self.txtCelu.SetValue(self.dat[0][11])
self.txtWeb.SetValue(self.dat[0][12])
self.txtLinCre.SetValue(str(self.dat[0][13]))

#-------------------------------------------------------------------------------
def CargarCombo(self):

rs=self.oClte.CargaTDoc()

self.cboTipoDoc.Clear()

i=0

for it in rs:
x=unicode(rs[i][1],self.encode)
self.cboTipoDoc.Append(x,rs[i][0])
i+=1

if self.__class__.TipoOper=="N":
#Vacia el 1er elemento mostrado para q el user se vea
obligado a escoger
self.cboTipoDoc.SetValue('')
elif self.__class__.TipoOper=="E":
#Pinta el registro seleccionado
pass

#-------------------------------------------------------------------------------
def ObtieneValores(self):
self.oClte.__class__.mNombre=self.txtClte.GetValue ()
self.oClte.__class__.mTipoDoc=int(self.kTipoDoc)
self.oClte.__class__.mNumDoc=self.txtNumDoc.GetVal ue()
self.oClte.__class__.mDireccion=self.txtDirec.GetV alue()
self.oClte.__class__.mPostal=self.txtPostal.GetVal ue()
self.oClte.__class__.mFono1=self.txtFono1.GetValue ()
self.oClte.__class__.mFono2=self.txtFono2.GetValue ()
self.oClte.__class__.mFax=self.txtFax.GetValue()
self.oClte.__class__.mEmail=self.txtEmail.GetValue ()
self.oClte.__class__.mCelular=self.txtCelu.GetValu e()
self.oClte.__class__.mWeb=self.txtWeb.GetValue()
self.oClte.__class__.mLinCredito=int(self.txtLinCr e.GetValue())

#-------------------------------------------------------------------------------

def BorrarCtrls(self):
self.txtClte.Clear()
self.txtNumDoc.Clear()
self.txtDirec.Clear()
self.cboTipoDoc.Clear()
self.txtPostal.Clear()
self.txtFono1.Clear()
self.txtFono2.Clear()
self.txtFax.Clear()
self.txtEmail.Clear()
self.txtCelu.Clear()
self.txtWeb.Clear()
self.txtLinCre.Clear()

#-------------------------------------------------------------------------------

def OnBtnOkButton(self, event):

self.ObtieneValores()

if self.__class__.TipoOper=="N":
if self.oClte.Graba()==True:
dlg=wx.MessageDialog(self,u'Se ingres el nuevo
Cliente.', \
'PymeGestor',wx.OK | wx.ICON_EXCLAMATION)
dlg.ShowModal()
dlg.Destroy()
self.BorrarCtrls()
self.txtClte.SetFocus()

else:
dlg=wx.MessageDialog(self,u'Hubo un error al ingresar
los datos.\
Corrija y vuelva a intentarlo.','PymeGestor',wx.OK |
wx.ICON_ERROR)
dlg.ShowModal()
dlg.Destroy()
self.txtClte.SetFocus()

elif self.__class__.TipoOper=="E":
self.oClte.Edita()
else:
pass

#-------------------------------------------------------------------------------

def OnBtnSalirButton(self, event):
self.Close(True)

#-------------------------------------------------------------------------------

def OnCboTipoDocCombobox(self, event):
cb = event.GetEventObject()
#Obtengo el Key
self.kTipoDoc = cb.GetClientData(cb.GetSelection())

#-------------------------------------------------------------------------------

================================================== ===========================
================================================== ===========================

--
Mario Lacunza <ma***********@gmail.com>
Sep 10 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
by: Ralph Freshour | last post by:
Is it possible to inhibit the browser Back/Fwd buttons via PHP? Thanks...
9
by: Mayer | last post by:
Hello: I'm running python under cygwin and need to find the drive letter. Cygwin has a way of calling my drives by a name relative to the Cygwin directory, so I get things like /home/user rather...
0
by: Gijs Korremans | last post by:
Hi, I'm extending a Python application that uses several com objects and threads. The origional programmer set the main thread to multithreaded by doing this: * sys.coinit_flags = 0 * import...
0
by: Peter Childs | last post by:
Thought this might intrest any Postgres Users in the South East England area. The main talk at this meeting is on Postgres Vs MySql. Peter Childs -------- Original Message -------- Subject:...
3
by: Deepa K | last post by:
---------------------------- Original Message ---------------------------- Subject: Abrupt close of pgsql backend From: "Deepa K" <kdeepa@midascomm.com> Date: Mon, October 25, 2004 8:04 pm...
0
by: rrp83 | last post by:
Hi All Can anyone fwd me the code for converting a string to bytes similar to the GetBytes function in C# and viceversa?? Regards, RRP83
0
by: 2Barter.net | last post by:
Fwd: A Blessing found for Daytona Beach Florida Hello This is Craig Oral Somerford and I've been using Gmail and thought you might like to try it out. Here's an invitation to create an...
1
by: fckuen | last post by:
Dear all, the doc is missing, and i failed to find the solution on google search. anyone know how to override the function SetColLabel() inside the class PyGridTableBase or the class...
1
by: jake77.lucas | last post by:
I'm using 2005.Net C++ compiler. I have a base class in namespace A (call it Class1). I derive another class from it, (call it Class2) defined in namespace B. This derived class contains as a...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
0
tracyyun
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
2
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
4
NeoPa
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
3
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be using a very simple database which has Form (clsForm) & Report (clsReport) classes that simply handle making the calling Form invisible until the Form, or all...
0
NeoPa
by: NeoPa | last post by:
Introduction For this article I'll be focusing on the Report (clsReport) class. This simply handles making the calling Form invisible until all of the Reports opened by it have been closed, when it...
0
isladogs
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
2
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.