Mr Abu, i have command like this:
When i use old version (1.4.8), my command is no problem.But when i use new version 1.5, the command error with warning Couldn't execute query. ORA-00920: invalid relational operator –
How i solve the problem?
Regards,
Samsun
Hello,
if you can post the SQL query OR email me grid code file, it would help.
Currently, it's difficult to diagnose the issue.
Regards,
MY command:
$g2->select_command = "SELECT ID_PEGAWAI, NIP_LAMA, NIP_BARU, NIK, NO_KK, NAMA,REF_KABLAHIR.NM_KABLAHIR as KD_KABLAHIR, TGL_LAHIR, ROUND((TRUNC(sysdate) – TGL_LAHIR)/365) as UMUR, REF_JENIS_KELAMIN.NM_JENIS_KELAMIN as KD_JENIS_KELAMIN, REF_GOLONGAN.NM_GOLONGAN as KD_GOLONGAN, TMT_GOLONGAN, MASTER_PEGAWAI.KD_JABATAN, REF_JABATAN.NAMA_JABATAN as KD_JABATAN_ID, KD_AGAMA, KD_STSPERKAWINAN, REF_UNIT_KERJA.NM_UNITKERJA as KD_UNITKERJA, NPWP, TASPEN, KARIS, ASKES, KARPEG, STATUS_PENSIUN, PHOTO, GELAR_DEPAN, GELAR_BELAKANG FROM MASTER_PEGAWAI LEFT JOIN REF_KABLAHIR on REF_KABLAHIR.KD_KABLAHIR = MASTER_PEGAWAI.KD_KABLAHIR LEFT JOIN REF_JENIS_KELAMIN on REF_JENIS_KELAMIN.KD_JENIS_KELAMIN = MASTER_PEGAWAI.KD_JENIS_KELAMIN LEFT JOIN REF_JABATAN on REF_JABATAN.KD_JABATAN = MASTER_PEGAWAI.KD_JABATAN LEFT JOIN REF_GOLONGAN on REF_GOLONGAN.KD_GOLONGAN = MASTER_PEGAWAI.KD_GOLONGAN LEFT JOIN REF_UNIT_KERJA on REF_UNIT_KERJA.KD_UNITKERJA = MASTER_PEGAWAI.KD_UNITKERJA";
When i execute in sql command working very well and in v 1.4.8 to.
I guest the problem in limit
http://www.dba-oracle.com/t_ora_00920_invalid_relational_operator.htm
There must SQL query along with error message, kindly share that query as it will have actual issue.
Your select_command looks fine.