Error when update to 1.5

QuestionsError when update to 1.5
Samsun asked 6 years ago

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

3 Answers
Abu Ghufran answered 6 years ago

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,

Samsun answered 6 years ago

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

Abu Ghufran answered 6 years ago

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.

Your Answer

14 + 2 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?