Liveware Publishing Support Forum

Because I also need to look at a SQL table. Is there a way to do it?

I^m trying to run R&R SQL v 12.5, and would like it to read from some DBF files. When I create an ODBC Data source using the Microsoft dBase VFP driver, I get the below message when I try to connect. ____"No table names were found for this data source"____The Directory is G:JNBDB3 (a n...

Thanks

Is there a way to specify in RI_WPTR that I want R&R to use the default Windows printer?____Thanks

I remade the report and that took care of it.

Here^s another wrinkle: It does appear to read and select all 85000+ records, but all but the last 21832 show as blanks for character & date fields, zeros for numeric fields. So I^m getting some 63000+ blank lines.

Strange. It has "Entire Result Set" selected. If I change it to "Maximum Row" and enter 999999999 as the number, it displays a WHOLE LOT more, but still not everything.____It does have a sort and filter, but only shows records processed when I have it set to "Maximum Row&quo...

Found out a bit more. I can get everything by querying for a specific date range as long as I don^t query for too much. I can get the earlier numbered customers by specifically querying for a portion of the whole. ____It would appear that R&R SQL has a limit on the amount of data it can process.

I have a report that we have been using successfully for some time now, reading from an Oracle database. Last week, it only displayed transactions from customers #4931 and up. This week, it^s only displaying from #4949 and up, some 21000 records. It would appear that somehow there is a limitation th...