Hi to All,
I need to work with legacy table, even knowing it's not so recomended.
One of my tables has a String for primarykey.
I have built a SQLFORM.grid
When editing *only numbers* record code (key) - all works fine.
[image: Imagem inline 1]
all works fine
[image: Imagem inline 2]
------------------------------------------------------------
------------------------------------------------------------
------------------
*but*, when choosing a key which *contains a letter*
(alphanumeric charachter ), -in bellow case, the 'Y'
[image: Imagem inline 3]
I *get the following error:*:
[image: Imagem inline 4]
even ticket I do not get.
------------------------------------------------------------------------------------------------------------------------------------------
Even when I type the URL , it returns to me *Object not found*:
[image: Imagem inline 6]
the *Model for * *Artigos* table:
Artigos = db_prodmal.define_table('ARTIGOS',
Field('COD_ARTIGO','string'),
Field('NOME', 'string'),
Field('COMPOSICAO', 'string'),
.........
primarykey=['COD_ARTIGO'],
format='%(NOME)s',
migrate=False)
the *Controller **:*
*def *artigo_editar():
# Armazena o ID do artigo
id_artigo = request.args(0)
buttons = [TAG.button('Salvar',_type="submit",_class = "btn-success")]
# Form edição do colaborador
*if *id_artigo == '0':
form_artigo_editar = SQLFORM(db_prodmal.ARTIGOS,
buttons =buttons,
submit_button='Incluir',
field_id='COD_ARTIGO',
_id='form_colaborador_editar')
*else*:
form_artigo_editar = SQLFORM(db_prodmal.ARTIGOS,id_artigo,
buttons =buttons,
submit_button='Alterar',
_id='form_colaborador_editar',
field_id='COD_ARTIGO')
*...more code here...*
*
*
*
*
* **return *dict(form_artigo_editar=form_artigo_editar, [...other
returns....])
thanks!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
