[SOLVED]lookup in grid don't work !!!

Scriptcase 7 Bugs
#1

After the last update .26 I cant’n use lookup in grids, always obtain this error message

Error
Se produjo un error al acceder a la base de datos
[Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresi?n de consulta ‘tipodoc = &nbsp’.
SELECT nombre FROM tipos_doc WHERE tipodoc = ORDER BY nombre

Script: C:Program FilesNetMakev6wwwrootscriptcaseappconstructoragrid_informes_det_1grid_informes_det_1_lookup.class.php (49)

the sql sentence is “select nombre from tipos_doc where tipodoc = {tipo} order by nombre”
but now always tipo have only &nbsp ???

in other lookup, with proveedores tablle, the same error :
SELECT nombre
FROM proveedores
WHERE id = {Proveedor}
ORDER BY nombre

the error is :
Error
Se produjo un error al acceder a la base de datos
[Microsoft][Controlador ODBC Microsoft Access] Error de sintaxis (falta operador) en la expresi?n de consulta ‘id = &nbsp’.
SELECT nombre FROM proveedores WHERE id = ORDER BY nombre

Script: C:Program FilesNetMakev6wwwrootscriptcaseappconstructoragrid_informes_det_1grid_informes_det_1_lookup.class.php (49)

please fix this bug I’am stoped !!!

Thanks,
Aquiles

#2

Re: lookup in grid don’t work !!!

Hello aquiles,

Have you tried to generate the application without the lookup and then set it again to see if the problem continues?

regards,
Bernhard Bernsmann

#3

Re: lookup in grid don’t work !!!

the only solution was:

make a view (a query in access) with all the fields filled by joins and make a grid application using this view as datasource

Aquiles

#4

Re: lookup in grid don’t work !!!

In SC 6.026 with Mysql There was No Problem make a grid that lookup value from another table.

See my attachment please.

Suyono

Presentation1.jpg

#5

Re: lookup in grid don’t work !!!

Hello,

Was the lookup made on an existing field or a virtual field?

regards,
Bernhard Bernsmann

#6

Re: lookup in grid don’t work !!!

Existing Field Bernhard.

#7

Re: lookup in grid don’t work !!!

Hello,

On the onScriptInit set some value to the field and you will be able to do a lookup regardless if it is a virtual or aan existing field.

e.j.

onScriptInit

{myLookupField} = “something”;

regards,
Bernhard Bernsmann