Liveware Publishing Support Forum

Set @SelectStatement = ^<<(Select tb_job.jobid from tb_job where upper (TB_Job.Reference) >= upper(^^SL027018^^)__And upper (TB_Job.Reference) <= upper(^^SL027068^^) )>>^____changed to:____Set @SelectStatement = ^<<(Select tb_job.jobid from tb_job where upper (TB_Job.Reference) >= upper(^^SL027018^^...

Yes, I have full access rights on the RL dir.____Sequence of events is as follows:__R&Rv10 - report designer____- open existing report____- select report____- enter login details____- Menu - Database/sql select:_____change values in sql where clause____- OK____ERROR - "Must specify addition...

Do you have an /RL folder below the R&R folder and does it have DATADICT.EXE in that folder?____Yes. Both are present.__Regards__Ewan

I am trying to use R&R with a SQL server database. I have installed it on XP with the options :__Workstation/typical/ODBC Core Files AND SQL Server. This seems to be OK apart from the fact that I cannot get access to the data dictionary which it says does not exist or is invalid with this versio...