Qdabra Database Accelerator

Re: What is the envisaged use of DocID and RefID compared with the SQL table identity ?,

Jim Cantwell — Tue, 24 Jun 2008 21:13:15 GMT

NOTE: The only supported url format for DBXL v2.1 and earlier is using the DocID as stated by Ernesto. The RefID usage is a new feature coming in DBXL v2.2.

Re: What is the envisaged use of DocID and RefID compared with the SQL table identity ?,

ErnestoM — Tue, 24 Jun 2008 21:04:49 GMT

In order to use the RefID, use URLs with the following format:
http://<servername>/QdabraWebService/Documents/<DocTypeName>/<RefID>.xml

For DocID, use:
http://<servername>/QdabraWebService/Documents/<DocID>/<DocID>.xml

As Clay said, DocID will be unique for each document in your installation of DBXL, while RefID is unique only within each Document Type.

Re: What is the envisaged use of DocID and RefID compared with the SQL table identity ?,

Clay Fox — Thu, 19 Jun 2008 15:31:47 GMT

DocId is a sequential, unique ID which is global, essentiall the PK for the document table.

RefID is a sequential and unique ID for each document type or template.

Typically these would be used instead of an identity column for parent data but then repeating child tables would use an identity column.

Using the DBXL ID accomplishes the same need but also provides a link to the actual document as well.

Hope that helps.

What is the envisaged use of DocID and RefID compared with the SQL table identity ?,

Catharine — Thu, 19 Jun 2008 14:37:28 GMT

What is the envisaged use of DocID and RefID compared with the SQL table identity ?, which should be used for what ?

Thanks

Catharine