Qdabra Database Accelerator

Re: Set PK for Form to not be DocId

RobSil1976 — Wed, 03 Apr 2013 20:33:40 GMT

Thanks Ernesto, I'll give that a try. :) My form is an electronic purchase order and my Database has a Stored Proc that generates a unique PO number with a string prefix (e.g. PO34421) every time a new form is created so I'll see if I can use that string.

R.

Re: Set PK for Form to not be DocId

ErnestoM — Wed, 03 Apr 2013 12:53:21 GMT

As long as you have a unique key, it can be anything. It does not need to be the DocID.

The DocID, in fact, does not need to be mapped at all if you have some unique key in your form's data.

Hope this helps!

Set PK for Form to not be DocId

RobSil1976 — Tue, 02 Apr 2013 22:59:55 GMT

Is it possible to use a DocID for SQL/SP integration that is not the DBXL:DocId field? I have an electronic purchase order that has an already established PK (the PO Number). I'd like to use this as my PK for the form if possible but the instructions in Module #2 - Map Your Form Data into SQL seem pretty specific to use DocId.

Is it possible or does it have to be the DocId?

Thx,

Rob