DDE functions
Connector DDE links use the same protocol to communicate with the Working Papers database in both Word and Excel, but the syntax of the DDE functions differ.
Function | Arguments | Example |
---|---|---|
act() |
balance_type account_number |
cwin32|Data!'CWEval|active|act("BR","101")|' { DDE CWIN32 Data CWEval|active|act(\"BR\",\"101\")| \* MERGEFORMAT } Returns the report balance for account 101. |
class() |
balance_type class_id client_file |
cwin32|Data!'CWEval|active|class("BR","TR")|' { DDE CWIN32 Data CWEval|active|class(\"BR\",\"TR\")| \* MERGEFORMAT } Returns the report balance for trade receivables in current assets. |
clp() |
clp_code client_file |
cwin32|Data!'CWEval|active|clp("CLP2")|' { DDE CWIN32 Data CWEval|active|clp2| \*Charformat \* MERGEFORMAT } Returns the operating name of the client. |
cvdata() |
group form id client_file |
cwin32|Data!'CWEval|active|cvdatal("GROUP2","FORM2","ID2")|' { DDE CWIN32 Data CWEval|active|cvdata|(\"GROUP2\",\"FORM2\",\"ID2\")| \*Charformat \* MERGEFORMAT } Returns information located in the CaseView Database. More information on use of the CV Database may be found in the CaseView help. |
desc() |
account_number client_file |
cwin32|Data!'CWEval|active|desc("101")|' { DDE CWIN32 Data CWEval|active|desc(\"101\")| \*Charformat \* MERGEFORMAT } Returns the selected description for account 101. |
entdesc() |
entity_id client_file |
cwin32|Data!'CWEval|active|entdesc("E1")|' { DDE CWIN32 Data CWEval|active|entdesc(\"E1\")| \*Charformat \* MERGEFORMAT } Returns the short description for the entity entered in the Entity Properties dialog of the consolidated file. |
field() |
database_identifier column_heading row_identifier client_file |
cwin32|Data!'CWEval|active|field("SH","A1","2.00")|' { DDE CWIN32 Data CWEval|active|field(\"SH\",\"A1\",\"2.00\")| \*Charformat \ * MERGEFORMAT } Returns the Signed off User (A1) for Document 2.00 from the Document Manager database (SH). |
grp() |
group_number balance_type group_id client_file |
cwin32|Data!'CWEval|active|grp("1","BR","AA")|' { DDE CWIN32 Data CWEval|active|grp(\"1\",\"BR\",\"AA\")| \* MERGEFORMAT } Returns the balance for a given group number/ID combination based on the specified balance type. The example would retrieve the report balance for Group 1's grouping AA. |
grpdesc() |
group_number group_id client_file |
cwin32|Data!'CWEval|active|grpdesc("1","AA")|' { DDE CWIN32 Data CWEval|active|grpdesc(\"1\",\"AA\") | \*Charformat \* MERGEFORMAT} Returns the group description for a specified group number/ID. |
map() |
balance_type map_number client_file |
cwin32|Data!'CWEval|active|map("BR","511")|' { DDE CWIN32 Data CWEval|active|map(\"BR\",\"511\")| \* MERGEFORMAT } Returns a balance for a given map number based on the specified balance type. |
mapdesc() |
map_number client_file |
cwin32|Data!'CWEval|active|mapdesc("511")|' { DDE CWIN32 Data CWEval|active|mapdesc(\"511\",\"0\")| \*Charformat \* MERGEFORMAT } Returns a description for a specified map number. |
sdate(field()) |
database_identifier column_heading row_identifier client_file |
cwin32|Data!'CWEval|active|sdate(field("SH","AD1","7. 2"))|' { DDE CWIN32 Data CWEval|active|sdate(field(\"SH\",\"AD1\",\"7.\2\"))| \* MERGEFORMAT } Returns a date value from a specific field in a database. The example would search the Document Manager (SH) database to retrieve the Role 1 Sign Off Date (AD1) for the document numbered 7.2. |
tax() |
balance_type tax_export_code client_file |
cwin32|Data!'CWEval|active|tax("BR","10.D")|' { DDE CWIN32 Data CWEval|active|tax(\"BR\",\"10.D\") | \* MERGEFORMAT } Returns a balance for a given tax code based on the specified balance type. |
taxdesc() |
tax_export_code client_file |
cwin32|Data!'CWEval|active|taxdesc("06")|' { DDE CWIN32 Data CWEval|active|taxdesc(\"06\") | \*Charformat \* MERGEFORMAT } Returns tax code description for a specified tax code. |
ud() |
user_defined client_file |
cwin32|Data!'CWEval|active|ud("UD1")|' { DDE CWIN32 Data CWEval|active|ud1| \*Charformat \* MERGEFORMAT } Returns the value associated with a user defined data code. Values are entered under Tools | User Defined Data in CaseView. |