Prepared statement needs to be re-prepared ?

Ranorex Spy, Recorder, and Studio.
qa-auto
Posts: 60
Joined: Mon Aug 05, 2019 10:46 pm

Prepared statement needs to be re-prepared ?

Post by qa-auto » Wed Jan 27, 2021 8:43 pm

Hi,

Has anyone seen this error after defining a data source?

All my other data sources use selects without joins just fine.

SQL
SELECT distinct ld.loan_id,
th.effective_due_date
FROM trans_hdr th
INNER JOIN vw_loan_data ld ON th.id=ld.hdr_id
INNER JOIN customer c ON th.customer_id=c.id
WHERE th.status_id in (1)
and th.loan_model_id = 459
and th.store_id = '171' order by rand() limit 1;
image (48).png
image (48).png (8.81 KiB) Viewed 45 times