Qdabra Database Accelerator

Re: Adding Created/Modified person and Date to Infopath form

Jimmy — Wed, 02 Dec 2009 02:01:46 GMT

Another option would be to create a view that joins your database table with the DBXL Document table on the DocId key value and query that. Doing so would be in keeping with the 2nf principle.

Re: Adding Created/Modified person and Date to Infopath form

Jim Cantwell — Wed, 02 Dec 2009 02:01:13 GMT

Although they aren't all shown in DAT for DBXL v2.3, the following should all work in mapping:

DBXL::Link

DBXL::DocId

DBXL::DocType

DBXL::RefId

DBXL::VerNo

DBXL::CreatedBy

DBXL::DateCreated

DBXL::ModifiedBy

DBXL::DateModified

Re: Adding Created/Modified person and Date to Infopath form

Hilary Stoupa — Wed, 02 Dec 2009 01:53:22 GMT

Hi, Jeff:

That's a great feature request for future versions -- I'll be sure to log it!

Currently, I suppose you could write a trigger for your target table (that you are shredding to), and on Insert get the data from the DBXL Document table based on the DocId....

Adding Created/Modified person and Date to Infopath form

JeffTangen — Tue, 01 Dec 2009 23:23:28 GMT

I noticed in DBXL that their are 4 column's called DateCreated, DateModified, Createdby, and Modifiedby.

I already have DocID being added. I don't see these 4 as Mapping Tokens in the Database Mapping in DBXL. Is it possible?