Liveware Publishing Support Forum

Your method worked great - thanks so much for your quick response.

I have a ITEM DESCRIPTION character field that is 30 characters in length. If the description is "GUMMI BEARS", I would like to be able to count that there is 11 characters there. Basically - I have 9,000 items and I need to build a list of items where the description exceeds 25 characters...

Not seeing your data, it is possible that your join needs to have more than one rule.____If you have table A with 5 million records and table B with 5 million records and you join on a single field, you are asking for a possibility of 2.5 x 10 to the 13th power results. However if you join on more t...

Using the SQL 12.5 Builder__When I go to create a report, the first thing to do is select a table from the Master Table List. __A few specific tables do not show in the list even though they are in the data source.____I don^t know if this is due to a weird naming convention that our software mfg use...

[updated:LAST EDITED ON May-14-09 AT 11:20 AM (EST)]I have a certain bunch of data that is stored in strings where the data spills from one record to another with no spaces. The data example below is actually six independent records but as you can see, the data at the end of record 3 (0000133) ...

[updated:LAST EDITED ON Apr-15-09 AT 12:34 PM (EST)]If my database only uses dates in the format CCYYMMDD and it stores these as a numeric, what is the best way to convert this to a normal mm/dd/yy or mm/dd//yyyy format?____I would like the output to be a usable true date/time field as opposed ...

I have a query in an AS400 database which I need to only select data between dates.____Our system uses the century form of dates (January 1, 2009 = 1090101)__If I write the query using invoice date is "in the range" 1090101 and 1090201 - the query works fine__But if I make a parameter fiel...

In the past (several years ago) I used to print reports out of R and R which included bar code fonts which could be scanned on the production floor. They were standard 3 of 9 font and worked fine. Now in a different venue, I will be needing to print interleaved 2 of 5 codes. I am suspecting that thi...

Can you show an example of where these flags go?____Do you place it in the TARGET field of the shortcut?____Thanks in advance!____Chris