End of Statement Error 1

[Bkster]

I am getting this error when I try and view the page in my browser.

Error Type:
Microsoft VBScript compilation (0x800A0401)
Expected end of statement
/crystal/TMPu34xisvlw2.asp, line 6, column 44

When I insert the SQl statement into the advanced recordset window and select test I get the desired results.
Here is the SQL that I am inserting.

SELECT
PV_STUD_THST."STUD_ID", PV_STUD_THST."CPNT_ID", PV_STUD_THST."COMPL_DTE", PV_STUD_THST."PCT_GRADE",
PA_STUDENT."LNAME", PA_STUDENT."FNAME"
FROM
"PLATEAU"."PV_STUD_THST" PV_STUD_THST,
"PLATEAU"."PA_STUDENT" PA_STUDENT
WHERE
PV_STUD_THST."STUD_ID" = PA_STUDENT."STUD_ID" AND
PV_STUD_THST."CPNT_ID" = 'FAQN-0001'
ORDER BY
PV_STUD_THST."PCT_GRADE" DESC,
PA_STUDENT."LNAME" ASC

FYI I am copying the script from a report I designed in Crystal.

Thanks for the help

Brian Russell

 

[schase]

Hey Brian,

hope all's going good for ya.

What happens in my experience - is usually when you create a display of data - then repeat it. And later if you have to modify UD4 does not recognize it's own code of WEND

I always always have to undo - then manually erase the code - and re-do it.

But this is standard UD4 in my experience, not the Crystal reports. - although they may be the same.

 

[Bkster]

Thanks for the reponse. So I need to find the WEND and change it in the code?

Thanks

Brian

 

[schase]

From the way it looks,

you'll need to erase that code - and create a new one with UD4 -

can you explain how the report structure is laid out?

 

[Bkster]

I will look at it tommorrow I am heading home for the night. Thanks

Brian

 

[Bkster]

OK I am back at it. The thing that is throwing me is when I test the SQL Statement (I got from my Crystal Report) when I am building my recordset it works fine. When I click done it builds the record set and I am able to drag the fields onto the table. When I try and run the page I get the above mentioned End of Statement Error.

I printed out the SQL Statement and tried to build it with the UD4 advanced side of the record set builder. This did not work. I keep getting an oracle error, something about and ambiguous field. Am I thinking right by trying to rebuild the SQL statement with UD4.

Thanks

Brian

 

[schase]

Are you using Access or SQL or Oracle?

 

[Bkster]

Oracle Database

 

[schase]

ouch, outta my territory - sorry Brian.

anybody?

Might want to look for an oracle forum here at Tek-Tips too.

 

[Bkster]

Thanks for the help. I will look for and Oracle board