Write back in Cr 8.5 ?? 1

[petrovlis]

I need to update a field in a --Goldmine 6.7 dbase-- table with a value
after I have sent a CR-report to that company.

I now run CR 8.5 with VisualCut and Postcast Pro, outside Goldmine, to do our mailings.

Thanks for any help.
William

 

[Madawc]

I don't think Crystal allows database updates. What you could do is use Save As to make a duplicate of the report which selects the same data in a form suitable for export as text / extract file. Then maybe use the extract file to do the updates using some other software.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[synapsevampire]

Crystal is a report writer, consider writing to an Access table, and then using an Access query to do the update (Access has wizards to assist with this, it's simple fare).

-k

 

[IdoMillet]

You can write a User Function Library (UFL) or use a 3rd-party UFL that allow a Crystal formula to execute an SQL statement. For a list of 3rd-party tools see:

http://www.kenhamady.com/bookmarks.html

My "CUT Light" UFL provides two functions for executing SQL statements against ODBC data sources. One function allows you to execute stetements with no return values (e.g., Update or Insert statements). The other function allows you to execute a SQL statement that returns a single value.

- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[dgillz]

Ido,

Won't Visual Cut update the databse for him?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

 

[IdoMillet]

No, Visual CUT can't update a given field, which was the original question.

However, now that you made me think about it, Visual CUT can not only take care of the process of sending the report to each company (bursting), if you turn on the option of logging processing to an ODBC target, a record would be created in a log table for each company that was processed. That record would include the Group Value (e.g., "Company_ID"). It would then be easy to create an update statement that takes that information and updates the desired field in another table.

The advantage of that approach is that the log table contains a status field that shows whether the exporting and emailing was successful. This means the update of the target field would occur only if a failure (e.g., email address was missing) didn't occur.

Cheers,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com