Create Database Table with SQL Keywords in Form

Hi there,I've tried creating a database table from a form that has SQL keywords as the name of the form's attribute. I've attached the screen shots.Seems that Livelink can't create databases with SQL keywords as attributes. I've tried changing the attribute name so that it will not be the same as SQL keyword and retried creating the database.unfortunately, the problem persists.Is there any other workaround for this situation?

Find more posts tagged with

Comments

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Try deleting the fields from the form and recreating them (only the ones that are problematic).- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Thursday, January 14, 2010 10:15 PM
To: eLink Recipient
Subject: Create Database Table with SQL Keywords in Form

Create Database Table with SQL Keywords in Form

Posted by faizal@edms.com.my (Halim, Faizal) on 2010/01/14 22:11

Hi there,

I've tried creating a database table from a form that has SQL keywords as the name of the form's attribute. I've attached the screen shots.

Seems that Livelink can't create databases with SQL keywords as attributes. I've tried changing the attribute name so that it will not be the same as SQL keyword and retried creating the database.
unfortunately, the problem persists.

Is there any other workaround for this situation?

Faizal_Halim

hi Bhupinder,thanks for your post.it worked, but I'm concerned about data that have been saved in the form.let's say I've been using the form for quite some time. now the requirement is to generate LiveReport from the form.Is it possible to get data from the deleted attribute names (which use SQL keywords previously)?Let me clarify again my situation here. I just need to generate LiveReports from a form.The simplest way to do so that I can think of is to create relational database so that I can get the values from the table.Unfortunately, I've created the form with SQL keywords in it. As a result, the SQL table can't be generated.Is there any other workaround to generate the LiveReport? If I delete and re-create the attributes (without using the SQL keywords), how can I retrieve the previously entered data?Thanks.-Faizal

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

What revision and submission mechanism was defined for the form when it was in use with the SQL keyword attribute names?

- Bhupinder

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Monday, January 18, 2010 5:01 AM
To: eLink Recipient
Subject: it works, but...

it works, but...		Posted by faizal@edms.com.my (Halim, Faizal) on 2010/01/18 04:58
In reply to: RE Create Database Table with SQL Keywords in Form		Posted by bsingh (Singh, Bhupinder) on 2010/01/15 08:52

hi Bhupinder,

thanks for your post.

it worked, but I'm concerned about data that have been saved in the form.
let's say I've been using the form for quite some time. now the requirement is to generate LiveReport from the form.

Is it possible to get data from the deleted attribute names (which use SQL keywords previously)?

Let me clarify again my situation here. I just need to generate LiveReports from a form.
The simplest way to do so that I can think of is to create relational database so that I can get the values from the table.
Unfortunately, I've created the form with SQL keywords in it. As a result, the SQL table can't be generated.

Is there any other workaround to generate the LiveReport? If I delete and re-create the attributes (without using the SQL keywords), how can I retrieve the previously entered data?

Thanks.

-Faizal

Faizal_Halim

There are 2 forms:Form 1: Revision Mechanism: Livelink VersionsSubmission Mechanism: Form 2:Revision Mechanism: Submission Mechanism: Initiate WorkflowThanks!-Faizal

Bhupinder_Singh

Message from Bhupinder Singh <bsingh@opentext.com> via eLink

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">eLink

Form 1:

It's been a while since I worked in the area of form data storage, but this is what I recall:

Livelink Versions: The form data will be saved in data files (i.e. versions) and these will be referenced in the DVersData table, with the DVersData.DocID corresponding to the DataID of the form itself. You can check the function menu, Properties, Versions tab of the form to see references to the physical files in which the form data resides. If the form values are edited on the form itself, Livelink will store a new version of that form. Form data can be searched using Livelink Search (however, you need Administer permission for the form to see form data on the Search Result page). Writing reports on this form data is not really possible, as far as I'm aware, because of the way the form data is stored in physical files versus the database.

Form 2:

The answer here depends on what further storage mechanism you've defined for the form within the workflow itself, i.e. Livelink Workflow or SQL Table.

Assuming Livelink Workflow (if you had not yet defined a SQL table for the form template itself), then the form data would be stored in the WFForms

and WFFormsVersions tables. For additional details on how the form data is stored in this case, please see a posting I made here:

https://knowledge.opentext.com/go/7449026

Let me know if that helps...

- Bhupinder
----------------------------------------------
Bhupinder Singh, B.Math, B.Ed.
Senior Systems Analyst, Information Technology
Open Text, Waterloo, Ontario, Canada
----------------------------------------------

From: eLink Discussion: Open Text Live Reports Discussion [mailto:livereportsdiscussion@elinkkc.opentext.com]
Sent: Tuesday, January 26, 2010 8:50 PM
To: eLink Recipient
Subject: RE it works, but...

RE it works, but...		Posted by faizal@edms.com.my (Halim, Faizal) on 2010/01/26 20:45
In reply to: RE it works, but...		Posted by bsingh (Singh, Bhupinder) on 2010/01/21 09:31

There are 2 forms:

Form 1:
Revision Mechanism: Livelink Versions
Submission Mechanism: <None>

Form 2:
Revision Mechanism: <None>
Submission Mechanism: Initiate Workflow

Thanks!

-Faizal