Hello to all
I have a consultation with parameters that only leave the lines of a code in expecifico and this good, the problem is that in the line there is one in which I keep the photos. field image of type image and I only want the lines that have image and not all.

As I indicate in the consultation this to him?



Hola a todos
Tengo una consulta con un parametros que solo salgan las lineas de un codigo en expecifico y esta bien, el problema es que en la lineas hay una en la cual guardo las fotos. campo imagen de tipo imagen y solo quiero las lineas que tienen imagen y no todas.

Como le indico en la consulta esto ???


SELECT
Facte.CODIGO AS CODIGO,
Facte.FACTURA AS FACTURA,
Factd.FACTURA AS FACTURA_Fa,
Factd.CODIGO1 AS CODIGO1,
Factd.ORDEN AS ORDEN,
Factd.NOMBRE AS NOMBRE,
Factd.FECHAO AS FECHAO,
Factd.imagen AS imagen
FROM
Factd,
Facte
WHERE
Factd.FACTURA = Facte.FACTURA
AND
(
Facte.CODIGO = Param1
)


Thanks

Manuel

As i understand (with difficulty) you want to get only the record that
contain images.
I see that your query use a parameter ( Facte.CODIGO = Param1) But if a
parameter is set to Null , the condition associated is no longer evaluated.
to evaluate a Null value (for binary data or others field) and use a
parameter to (de)activate it use something like that (Facte.CODIGO =
Null AND 1 = Param1). Then just set the Param1 to 1 to activate the test
every others value will deactivate the null test.

An other solution is to have a boolean field in the original file that
indicate that an image is present.
Then just query on that boolean and the work is done.

Bye

Goof

PS : auto translation help but some words were not translated.


Manuel a écrit :
Read next »

Thanks to answer

I am using a translator. Spanish to English

That is what I had to do so that the consultation worked

now the consultation loads a table. but the field imagene only leaves a sign and not a small image as if this in the consultation

Thanks

Manuel

Manuel a écrit :
Read next »You should make sure that the Field in the table is typed as picture (in
the window).
Then verify that the table row that contain the binary data is a binary
picture memo (in the analysis).
I have done such a thing in a application and it work very well.

Bye
Goof

PS : I use the translator in the reverse way. I write in english, then I
translate in french, then I corrects the english version, then I
translate in french again,......
It work pretty well this way.

gracias

Manuel