Hello,
I am working on connection from PHP to Informix, which is back-end database for our Baan IV c4. I don't have problems with connection to Informix database from PHP. My problem is to use indexes of Baan, what is type integer. Informix has column 'hash' which is type char. But hash column is filled in non-printing characters (string can content every value of char more than 0x00).
I tried to create sql query in PHP
$sql = "SELECT * FROM ttdpur040130 WHERE hash1=".chr(129).chr(1).chr(12).chr(02).chr(79);
which hash1 is compare with non-printing chars,
Result of this operation is:
// echo $sql;
SELECT * FROM ttdpur040130 WHERE hash1=
O

End result of whole query is:
Warning: Prepare fails (E [SQLSTATE=IX 000 SQLCODE=-202]) in d:\ag\apache\htdocs\informix\informix1.php on line 26

Do you know such a way how to get these data from Informix through hash?

thx ....

I am not sure that what you are trying to do is possible.

Firstly, obviously you are using a level 1 database driver which means that Baan is responsible for maintaining the indexes (the hash colums) rather than using the RDBMS index structures. This makes it impossible for 3rd party software to manipulate the data.

Secondly, I don't really understand your SELECT statement. Should the WHERE clause not reference any proper data table fields than hash columns?

e.g.:


select * from ttpur040120 where t$orno = "47";