Liveware Publishing Support Forum

I use R&R 10+ with SQL 2000 and use complex Ansi Sql queries.__I.e. Left outer joins ,(Nolock) Hints etc. ____To stop the error you mention just add an: Exec(^^);__at the top of the script and add all your SQL script below as normal.____It seems to change the way the sql is parsed and works with...

Yes Our version is 10.0.012 SQL running on MSSQL 2000 and 7 fully svpk^d and MDAC 2.7 Svpk^d.____I have had memory problems with the dbase version also (v10+)______Andrew Bessey____

I have applied the new patch (10.0.012) and I am still getting the ^Out of memory message during preview on my more busy reports and having to re-start R&R .__I am using windows 2000 wks , 1 gig memory __,using (MSSql server 7 and 2000),( NTserver 4 and Novel 3.2) Reports And database stored on ...

I have had this problem with multiple left outer joins and have found a way to do very complex sql (Microsoft sql 7 and 2000) with R&R. ____When I cannot get R&R to recognize my Local syntax I wrap the whole statement in an EXEC ____ie__Exec(^select __a.au_id,au_lname,au_fname,phone,address,...

I Have Just Installed Version R&R 10 and have found that Delphi 7 forms with version 9 sql ocx embedded in them will not load propererly. (and will not display the form) I fixed one application by removing the control from the palette and loading the form (causing a control missing error ), the ...

I am Using Windows 2000 with an HP laserjet 8000N and R&R 9.09__Files are stored on a Novell Network____Also____I Just Bought Version 10 of R&R SQL/Xbase and am disapointed (to say the least) that it still does not support Multiple datasources using Microsoft SQL ODBC drivers. We have over 1...

>Is there a way to change the format for the time parameter. __>I like to change it to hh:mm:ss am/pm. I know you change it __>for the time part of a datetime field. Thanks for any help.____Unless I am mistaken simply right click the datetime field__and select Properties you will see a dialog with s...