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

jonykalavera
jonykalavera Member Posts: 4
edited 2006-02-09 in NAV/Navision Classic Client
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!!! ](*,)

Comments

  • ara3n
    ara3n Member Posts: 9,258
    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.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • jonykalavera
    jonykalavera Member Posts: 4
    how can i use c/front from php ??? or perhaps where can i find documentation about it
  • ara3n
    ara3n Member Posts: 9,258
    I believe it comes on installation CD. There should be a folder for cfront. As well as example code on how to use Cfront.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • jonykalavera
    jonykalavera Member Posts: 4
    where can i get N/ODBC? if it comes with the CD please specify which version.
  • ara3n
    ara3n Member Posts: 9,258
    N/ODBC was released for version 4.0. It comes on CD for version 4.0
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n

Categories