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?
if you can post the SQL query OR email me grid code file, it would help.
Currently, it's difficult to diagnose the issue.
$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
There must SQL query along with error message, kindly share that query as it will have actual issue.
Your select_command looks fine.
We are sorry that this post was not useful for you!
Let us improve this post!
Tell us how we can improve this post?