Search results

I have an older progress database that I am trying to write Crystal Reports against. The ODBC connection tests well, I can see the tables and fields available in Crystal Reports, I can pull records when I run wide open queries against a single table (no conditions or joins) but as soon as I set...

I am trying to connect Crystal Reports v8 to a progress 9.1b database using the following ODBC settings: The connection tests sucessfully, Crystal sees the Database, Tables and Fields but when I try to browse fields (see the data) or preview the report I get the following error messages...

Never mind - had an "update" command in another part of the code that needed to be moved around a little. All good now.

I am getting the subject error related to the following segment of my code: “Assign iAbsToday = ((Year(today) * 365.242199 + Month(today) * (365.242199 / 12) + Day(today) + 1)). If iWeekday = 6 then do: Assign iAbsToday = ((Year(today) * 365.242199 + Month(today) * (365.242199 / 12) +...

D'oh! Of course your code works fine... Your the best, Tom! I had tried something like: "Find Each... If available then do:..." But that wouldn't pass validation. Your solution works great. Thanks again, NB

Business Case: I need to send an email to the Approver of Purchase Orders whenever a PO needing their approval is generated. Problem: Each Approver can have one or many Authorized Users. How do I get my code to loop through all the possible Authorized User records for a PO Approver? I...

Got it - I guess it's just a space that seperates the list...

Greg, I think this should be the final push. The following syntax is producing the desired results: define variable differences as logical no-undo. Set differences = Yes. For each ttPart, each Part where ttPart.Company = Part.Company and ttPart.PartNum = Part.PartNum no-lock...

Tom and Greg, Here is where I'm at as of this morning: Business Case: Users are allowed to update Part.PurComment and Part.MfgComment but no other fields on Part. Approach: define variable differences as logical no-undo. For each ttPart, each Part where ttPart.Company =...

Tom, This sounds like it will be the answer but I am struggling to the get syntax correct. You supplied: BUFFER-COMPARE source [ { EXCEPT | USING } field ... ] TO target [ CASE-SENSITIVE | BINARY ] [ SAVE [ RESULT IN ] result-field ] [ [ EXPLICIT ] COMPARES ]: [ WHEN field compare-operator...

I am doing an evaluation of a current line in a table against a potential change to that line coming from a Temporary Table through a Business Object Update Method. I only want users to be able to change the Comment fields on the table (Part.MfgComment and Part.PurComment) and no other fields...

Tom, Worked great - thanks for the help. NB

I am building a query against a database table. One of the fields is a character-separated list of Sales Rep Codes (e.g. 2673~5524~1911). In Crystal Reports I would use Split(OrderHed.SalesRepList,'~')[0] to get "2673", Split(OrderHed.SalesRepList,'~')[1] to get "5524" and...

Greg, Where do I do this? When I try: wkhandle:buffer-create(ttQSalesRP). I get: "The following application error was encountered: ** Unknown Field or Variable name - ttQSalesRP. (201) ** Could not understand line 47. (196)" When I try: wkhandle:buffer-create(ttQSalesRP.Company). I...

Hi, This is my first post to ProgressTalk. I am a mechanical engineer recently turned novice-developer out of necessity and need some help with a software-specific problem. Business Case: My company has both inside and outside sales reps assigned to most customer accounts and stored on the...