Problems executing RDO Statement

[campbere]

I am having troubles executing an rdo resultset.

It is buried in if then else statements. Previous rdo statements work before it however when the program reaches this rdo it doesn't execute.

I have confirmed that the If statement is true, and that that the program does evaluate it. I did this by replacing the rdo statement with a statement that would display the current date on a form in a lable field.

I have also ran the sql statement in SQLPLUS, (I am using Oracle 8).

But I still can't figure out why the rdo statement won't fire. Any suggestions on what may be happening or on how to determine what is going on?



IF (statement is here it is true) THEN

sqlCAP = "select title, issn, volume, issue, "_
& "date, " _
& "Replace(issue, '-', '.') hissue " _
& "FROM journal_issue_tracker " _
& "WHERE issn = '" & RSMaxTest!Issn "' " _
& "order by volume DESC, to_number(hissue)DESC "

Set RSCAP = DB.OpenResultset(sqlCAP, rdOpenKeyset, rdConcurRowver)

Any ideas?

 

[Psychpt]

what data type is issn and did you debug print RSMaxTest!Issn ?

 

[campbere]

I solved my problem. It had to do with do loops in the program. I had one do loop that was missing an ending loop and another that was actually missing the do part. So things were all screwed up causing the problem. Once I found that and corrected it, the RDO executes perfectly.

Thanks Everyone.