Are you trim the values for Search fields? Not good
Hi,
I've build a query in the designer with some search fields. One of my search
values is a string: ' M 3127/FN'. The first character is a blank. If I look
at the SQL code it looks like you trim the value; the blank is gone. Why
that? Now I don't find my data
I'm using RB 7.04 on Delphi 5.
--
Mit freundlichen Gr??en
Sven Langenkamp
Tel.: +49 (0) 50 21 / 97 24 -15
Email: langenkamp@ctdatentechnik.de
===============================
CT Datentechnik Gesellschaft
f?r Prozessrechentechnik mbH
Eschenstr. 2 - 31582 Nienburg
Tel.: +49 (0) 50 21 / 97 24 -0
Fax: +49 (0) 50 21 / 97 24 -18
Email: info@ctdatentechnik.de
Internet: www.ctdatentechnik.de
===============================
I've build a query in the designer with some search fields. One of my search
values is a string: ' M 3127/FN'. The first character is a blank. If I look
at the SQL code it looks like you trim the value; the blank is gone. Why
that? Now I don't find my data
I'm using RB 7.04 on Delphi 5.
--
Mit freundlichen Gr??en
Sven Langenkamp
Tel.: +49 (0) 50 21 / 97 24 -15
Email: langenkamp@ctdatentechnik.de
===============================
CT Datentechnik Gesellschaft
f?r Prozessrechentechnik mbH
Eschenstr. 2 - 31582 Nienburg
Tel.: +49 (0) 50 21 / 97 24 -0
Fax: +49 (0) 50 21 / 97 24 -18
Email: info@ctdatentechnik.de
Internet: www.ctdatentechnik.de
===============================
This discussion has been closed.