error: this operation violates your permissions configuration

[Former Community Member]

Hello: I have a form with a dropdown list and 4 text fields.



The dropdown list has 3 values (Committee 1, Committee 2, and committee 3)



In access 2007 I have a database with the names of the people on each committee.



The following code is on the exit button of the dropdown list:



$sourceSet.TIMSTEST.#command.query.commandType = "text"

$sourceSet.TIMSTEST.#command.query.select.nodes.item(0).value = Concat("Select * from Tmp_Committee where Description = '", this.rawValue, "'")

$sourceSet.TIMSTEST.open()

//xfa.host.messageBox("TIMSTEST opened")



$sourceSet.TIMSTEST.close()

//xfa.host.messageBox("TIMSTEST closed")



When I open the form I automatically get the first record in the database.

When I choose another value in the dropdown I get this error:



error: this operation violates your permissions configuration



Please help.



Thank you

[Former Community Member]

Stefan Cameron has a good blog on this topic:

http://forms.stefcameron.com/2006/12/18/databases-inserting-updating-and-deleting-records/

http://forms.stefcameron.com/2006/09/29/selecting-specific-database-records/

The second one is more specific to your need.

Paul

[MsPatil]

Paul,

Could you tell me how to do below

Reader Extend the form using LiveCycle Server

Thanks

Shobha

[Former Community Member]

You will need a server class machine (at least 2 Gigs of memory) and then you can download a trial version of LiveCycle Server. The turnkey install will install a database and an application server as well as any LiveCycle components you want ....you only need Reader Extensions. Once you get that far there is a web page you can load that will allow you to choose the rights you want to add to your form.

Paul

[MsPatil]

Hi Paul,

Good news is I was able to fix the permission issue by using cloning techniq

Thanks for your support. I am able to view my form in acrobat reader.

Thank you

[MsPatil]

Is there any way to make text fields look like text

When I print the form..i see the borders..it prints as text box

How can I make the form print as plain text

[Former Community Member]

Yes you can programmatically hide the borders .....you will have t write intricate javascript code to cycle through all objects on the form and if you have a field turn off the border, then turn them back on after the print is done. Why not just turn them off in the form design to begin with?

Paul

[MsPatil]

Hi Paul,

If I need to connect to DB in Designer 8 then do I have to always use

cloning technique? Also to use cloning do I always need to create custom

drop down ?

Thanks

Shobha

[Former Community Member]

I do not understand your question ...can you elaborate?

Paul

[MsPatil]

I tried creating another small form and added below code in the click event

(formCalc language) of a text box

var oDC = Ref($sourceSet.CatalogConnection.clone(1))

oDC.#command.query.commandType = "text"

And form errored(same permission error).

Then I added drop down box using Insert =>custom=>drop down list. (This adds

predefind code in Initialize event)

After doing this my form was working fine

So my question is, do I always need to have this pre defined code (by adding

drop down list) on my form?

Please let me know if still not clear

[Former Community Member]

The error message is coming from the call to manipulate the sourceSet. This is protected by Acrobat from being changed (for security reasons). The code that you added has a line:

var

oDB = xfa.sourceSet.nodes.item(nIndex).clone(1);

The cloning creates a new series of nodes which you are allowed to manipulate. If you do the same thing in your code then it shoudl work.

Paul

[MsPatil]

Yup..this works!!

Thanks

[MsPatil]

Hi Paul,

I was able to create forms using Microsoft OLE DV Provider for ODBC driver

and using DSN created on that m/c. But if I deploy this for across netwrok

then do I need to create DSN on every m/c?

And if I use "Microsoft OLE DB Provider for SQL server" provider and connect

to SQL server DB (not DSN) then I get "Trusted connetion" error.

Any idea why?

[Former Community Member]

You will have to create a DSN on each machine that will load the form and access the DB. That message you are getting is not an error but a warning indicating that your machine is trying to access information from another machine. I believe that there is a setting in IE that will allow access to other trusted domains without warning you ....so you must get the other server as a trusted domain.

Paul

[MsPatil]

Hi Paul,

How can I add new line/carriage return?

For ex: textfield1 = concat(textfield2,"<br/>",textfield3)

I want textfield 3 to display on next line

Thanks

[Former Community Member]

In javascript a newline is a /n

Paul

[MsPatil]

Do not work in FormCalc script

[MsPatil]

Found it..no worries

[MsPatil]

Hi Paul,

I want to print my form on 6 X 4 paper. How can I do this?

Am using datamax I-4208 printer

Thanks

[Former Community Member]

In the Master Page you can define the size of your paper. That will adjust the content area accordingly.

Paul

[MsPatil]

Thank you. Will try that

Alos, I used "#xD","U+000D" to add carriage return but did not work

Textfield1=concat(textfields2,"#xD",textfields3)--I tried different wys but

still couldn’t make it work

What am doing wrong?

Any help would be appriciated

Thanks

Shobha

[MsPatil]

Please ignore my previos post...was able to fix it

thanks