Liveware Publishing Support Forum

I hope this will give a little more information in regards to my current problem:____I have a total of 3 joins to the master table. I am using the SQL Server driver on ODBC. the sorting is taking a little over 30 minutes before I get the error message, it goes thru 2425754 Records Read and 40701 Rec...

I am using Windows 2000 Professional service pack 2 with R&R for windows, SQL Edition Ver. 8.1 Build 8.1.025____I have created a report that takes a while to run due to a big database I am using. When the report is running/sorting it has stoped working close to getting the results, I have seen t...

I don^t know if this function is available in the SQL version but:____substr( mystring, 4)____will extract everything starting in position 4 of the string.____Randal Ferguson

Does anyone know how to create or derive how many characters are in a field? We have a procedure where we add an "S/A" to the beginning of name field, the field has a total of 38 characters. I have a calculated field where it checks for an "S/A" using LEFT(VS_BUS_NM,3), I want to...