hi,
i'm using php runner with a db2 iseries database
i'm using the odbc checkbox.
it is working well except two things :
the wizard inserts [] everytime he needs to access a table or a field (so i've modified the leftFieldWrap and rightFieldWrap in dbconnection.php)
but when i use a lookup field in visual editor, the wizard still uses [] to construct the SQL lookup statement
so everytime i modify my project i need to modify a lot of php files
i've seen in the phpr file (with notepad) that there is a place to tell him what is the left wrapper and what is the right wrapper. but when i modifiy it , it doesn't have any effect
the second thing is , on the addTop function it adds a "TOP 20" to the select statement. this syntax is not accepted by iseries DB2. so i need to modify also all the _list.php and _print.php , etc , ...
i know i am using odbc that was first targeted to MS Access database. but do you have some workaround for these two problems ??
thanks in advance
David