Liveware Publishing Support Forum

Hi.__If I have a query which retuens zero rows, is there any way to always print something ?__e.g. Blank Line, Blank report header or even a page with something in the header__

Using R&R version 10__Run time ALWAYS gives an eror____Using R&R itself:____Following works ok:__Open Report__Print Preview__Selct button to print Current Page or All Pages____Following gives an "Xbase Edition...has encountered an error...bombs out^ for the exact same report____Open the...

In VFP table, thsi error message comes up.__Any way round it__

Or you can have a Config.fpw file with the following:____RESOURCE = off__(tHIS IS A Foxpro setting which suppresses this message in Fox apps)__

Kathleen,__Yes, both types are the same --> 1____I created a calculated Field called One and put a Value of 1 here.__Next I sspecified to relate from The One Field__Then I have FlexLink clicked and Eneterd the Key as : 1____It still gives the same error....what am I doing wrong ?____Regards,____Gera...

Kathleen, I tried as you suggested setting up a linkinf field of 1 but when I tried to save I get an error message:____Linking & Index Key Fields are different types____

Is the SQL version different to the Xbase Version 8 or 9____How do I simulate a Left Outer Join in the xBase Version.______To recap.__I have Filea with say 100 records__I hvae fileb with 3 records__There is no field linking them____I want a record set with 100 x 3 records (300)____(I thought I could...

Kathleen,____If I go into File... it brings up a screen with Report wizzards,Blank report,Templates etc..____I cant find Sql option anywhere, even in Version 9.____

Kathleen,__I dont follow how you do a Sql statement in R&R (Version 8 or 9)

Can I join two files, using a Left Outer Join,____I do not have a linking Field to link the tables and want all the records in File A linked to all the recors in File B____So if I have 10 records in File A , and 3 records in File B, I want to end up with 30 records.____I^ve tried this in Version 8 a...