Problem displaying data in a table.
Hi, I have a query and it works ok, its very similar to this example http://developers.sun.com/prodtech/javatools/jscreator/learning/tutorials/2/ins erts_updates_deletes.html . I have a drop down where I select a company, and in the table bellow it shows me the users of a company.
The problem is that when I display it using output text it works fine and when I change the company, the fields are updated without problem. The thing is when I use input text field, than when I change the company the fields get fuzzy and all messed up. I don't know what's happening. I think im leaving trash in some place, but I don't know how to clean it.
Message was edited by:
Lucas_Conde
Message was edited by:
Lucas_Conde
# 1
When VirtualForms are not defined, it is likely that the input textfields aren't updated right for the changed value in Company DropDown.
In the above referenced tutorial, Please check out checkout :
1. Creating the Project > Configuring the DropDownList> Step 8
2. "Configuring the Virtual Form for Table" section
HTH,
Sakthi
# 2
Hi, i resolved some part off the problem, now im seeing the right information in the input, what was missing was an execute method in the prerender.
I can updated without problems, but I can't delete the rows. Im using two selects and a UNION. I get an SyncProviderException. Any ideas?
Here is the query
SELECT ALL dbo.Usuario.CodUsuario,
dbo.Usuario.NomeUsuario,
dbo.Usuario.Perfil,
dbo.Usuario.Email
FROM dbo.Usuario
INNER JOIN dbo.UsuarioTecnico ON dbo.UsuarioTecnico.CodUsuario = dbo.Usuario.CodUsuario
INNER JOIN dbo.EspecTecnica ON dbo.UsuarioTecnico.CodEspec = dbo.EspecTecnica.CodEspec
INNER JOIN dbo.Empresa ON dbo.EspecTecnica.CodEmpresa = dbo.Empresa.CodEmpresa
WHERE dbo.EspecTecnica.CodEmpresa = ?
UNION ALL
SELECT ALL dbo.Usuario.CodUsuario,
dbo.Usuario.NomeUsuario,
dbo.Usuario.Perfil,
dbo.Usuario.Email
FROM dbo.Usuario
INNER JOIN dbo.UsuarioCliente ON dbo.UsuarioCliente.CodUsuario = dbo.Usuario.CodUsuario
INNER JOIN dbo.Cliente ON dbo.UsuarioCliente.CodCliente = dbo.Cliente.CodCliente
INNER JOIN dbo.Empresa ON dbo.Cliente.CodEmpresa = dbo.Empresa.CodEmpresa
WHERE dbo.Cliente.CodEmpresa = ?
Another thing, is this Virtual Form important or there is no real use if you have only one form in a page?
Thanks.
