C/ODBC can't concatenate fields????????

jonykalavera

im trying to query navision from php using the c/odbc driver. simple selects work slow but fine. but i can't concatenate 2 fields in one column how can i do this? PLEASE URGENT!!!

i've tried:

select field1 + field2 as alias from table;


PLEASE HELP ME!!! ](*,)

ara3n

c/odbc drivers are buggy and are not full implementation of ODBC protocol. If you are using sql as backend, connect direct to SQL. The other option is to use the newer odbc drivers N/odbc. For that you have to upgrade the executables.
You can also use C/Front.

jonykalavera

how can i use c/front from php ??? or perhaps where can i find documentation about it

ara3n

I believe it comes on installation CD. There should be a folder for cfront. As well as example code on how to use Cfront.

jonykalavera

where can i get N/ODBC? if it comes with the CD please specify which version.

ara3n

N/ODBC was released for version 4.0. It comes on CD for version 4.0