var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Can you use inner joins in Oracle select statement?
This is the statement I am using and I get 'SQL command not ended properly error'
"SELECT DISTINCT ct.CASENUM, ct.TOSERVICEDATE, ct.SUBMITTEDAMOUNT, ct.CHECKDATE, ct.CHECKNUM FROM CLAIMTRAN ct INNER JOIN CLAIMTRANH ch ON ct.CASENUM = ch.CASENUM WHERE ct.TOSERVICEDATE = to_date('" & Me.txtDateofService.Text & "','dd/mm/yyyy') AND ch.PATIENTREF = '" & Me.txtAccountNo.Text & "'"
This is what I have as my code before it fills in the variables in debug mode. What am I doing incorrectly?
Looks ok to me, & yes, ANSI 92 join syntax is supported. What string do you finally end up with, after the values are inserted.
Maybe you still need a semi-colon at the end? That's the only thing I can think of
...Me.txtAccountNo.Text & "';"