I am trying this example using an Oracle 10.2g database, and when the ExecSql script gets to the oDC.open(); statement I get a “GeneralError” exception. Any ideas on what I am doing wrong?

Thanks, Willie

Willie,

That certainly is strange behaviour. Unfortunately, I’ve never encountered this before. I have heard of problems when not using the Microsoft OLE DB provider but that’s the one you say you’re using so I’m at a loss for suggestions.

Are you trying this with Acrobat 8.0 (Pro or Standard) or an older version?

Willie,

I would encourage you to have a look at Oracle’s ODBC FAQ to see if there might be an answer there.

If not, then you could post a message to the Acrobat Forums or report the bug.

Jim,

The first thing to check for in this case is if there are any syntax errors in your script. Based on what you wrote,

Error:accessor’xfa.sourceset.dataconnections.update()’

I see a syntax error in the “sourceset” object’s name. It should be “sourceSet”, with a capital “S” in “Set”.

The problem could also be the “s” in the “dataconnections” object name. Are you certain its plural?

Hi Guys,
Situation:
*-Database connection
*-prepopulated filed

I want to build a script where a user can select e.g.Actor and a subform should dynamically prepopulate the related movies in textfield. The user should be able to add or delete movies.

Me code is based on the following examples:DisplayAllDBRecords.pdf
and
SelectSpecificDBRecords.pdf

therefore I tried to combine them, without any success 🙁 It seems that the filter doesn’t work, and I don’t know how to call customized function in formcalc

Problem:
Does anybody have an example for this typical example?

Hope anybody can help me
Thanks in advance
Carsten

Carsten,

I’m confused: Based on the description you gave of your problem, it seems that my tutorial on selecting specific database records is exactly what you’re wanting to do.

There must be something more specific that that tutorial isn’t covering which is part of your list of requirements. Let me know and we’ll take it from there.

Doug,

I’m thinking the sample form in my tutorial on selecting specific database records is almost exactly what you need, given the large number of records in your database.

I would suggest using that sample and coming-up with a more extensive way to specify information about the record(s) sought so that the query can return one specific record or a small subset of them.

If the query only returns a single record, you could always disable the “next”, “previous”, etc. (i.e. the buttons that don’t apply).

To determine if the query returned zero, one or more records, you can use the “isEOF” function of the Data Connection object which returns true if you’ve reached the end of the recordset.

The following FormCalc script is a modification to the original script that’s in my “selecting specific database records” sample, in the drop down list’s Change event:

var sOriginalBOF = oDataConn.#command.query.recordSet.bofAction
var sOriginalEOF = oDataConn.#command.query.recordSet.eofAction

oDataConn.#command.query.recordSet.bofAction = “stayBOF”
oDataConn.#command.query.recordSet.eofAction = “stayEOF”

var nRecordCount = 0

oDataConn.open()

if (oDataConn.isEOF()) then
    xfa.host.messageBox(“no records returned”)
else
    oDataConn.first()
    nRecordCount = 1

    oDataConn.next() // move past the first record to see if we reach EOF

    if (oDataConn.isEOF()) then
        xfa.host.messageBox(“one record only”)
        oDataConn.previous() // move back to the one and only record
    else
        nRecordCount = 2
    endif
endif

oDataConn.close()

oDataConn.#command.query.recordSet.bofAction = sOriginalBOF
oDataConn.#command.query.recordSet.eofAction = sOriginalEOF

oDataConn.open()

if (nRecordCount > 0) then
    oDataConn.first()

    // Set the category name in the movieData subform and make it visible.
    movieData.presence = “visible”
    movieData.movieCategory = sCategoryName
else
    movieData.presence = “invisible”
endif

This script changes the “BOF” and “EOF” Actions (what happens when the record pointer goes beyond the first record in reverse order or past the last record in forward order) such that the record pointer remains in that position (the default is to loop around to the last or first record, respectively). It then moves beyond the first record and checks for “EOF” status. If we’ve reached EOF, then there’s a single record, otherwise, there are more records.

As for disabling buttons, you can do that by setting their “access” attribute to “readOnly”:

dbNext.access = “readOnly”;

To re-enable them, you simply set their access property to “open”.

your answers are quite satisfactory thus continue posting. my request is idea on how to code for a command button in access form which will help do some calculation based on available records. please help

Duncan,

I’m afraid I’ll need a little more context in order to provide you with a good answer.

Generally speaking, once the data from one or more records has been imported into fields on your form, you can then script simple or complex calculations based on the values of those fields (which are the values of the records).

For instance, if you had three fields and you wanted to show their sum in a fourth field, you could use the following FormCalc script on the fourth field’s Calculate event:

Field1 + Field2 + Field3

Kristin,

Unfortunately, I don’t have any specific information on that.

Since this affects your form when it’s running (being filled) in Acrobat, I think your question would be better-suited for the Acrobat Forums

Robert,

It’s not quite clear to me how you’re expecting the data from those fields to be inserted into your database.

Are you using script from this tutorial to execute an SQL “insert” statement on the data connection you’ve defined in order to insert a record with the field data into your database?

If not, the only other alternative is to use the “addNew” and “update” methods of the data connection object and bind your data fields to nodes in the data connection itself (by dragging and dropping data nodes from the Data View palette onto the appropriate data fields on your form):

In the Initialize event of your “Submit” button, put the following statement (in JavaScript):

xfa.sourceSet.DataConnection.addNew();

where “DataConnection” is the name you gave to your data connection when you defined it.

This will cause a new record to be created (but not inserted) and all the bound data fields will be emptied (rather than being populated with data from the first record).

Then, in your “Submit” button’s Click event, put the following JavaScript statement:

xfa.sourceSet.DataConnection.update();

This will update the new record with the data entered into the data fields and insert it into the database.

Darko,

There are a couple of ways you could go about doing this:

1. You could write a script in the root subform’s (usually named after the root data node in your schema and found at the top of the hierarchy tree in the Hierarchy palette) Initialize event which gathers data from the fields and submits it to a database using an ODBC data connection that you would define. The trouble with this approach is that the Initialize event gets called twice: A first time when the form is loaded and a second time after data merge. You would need to define a variable (either a Form Variable via the Form Properties dialog or a variable in a script object) which you could use to trigger your script to execute only on the second call to the Initialize event (i.e. every time the event is triggered, increase the counter variable and when it’s value is exactly 2, the data should be merged-in and you can let the remainder of your script execute).
2. You could use a script similar to option #1 except you would associate it with the Click event of a button which you could call “Save to database”. When clicked, the data would be gathered and inserted/saved to the database.

In either case, I think you would find it much easier to use an SQL statement.

Kristin,

Unfortunately, there’s no way for you to change the default value of an XFA field in the way you’re asking to do it. You can certainly specify default values for fields but you can’t specify a default of the SQL “NULL” value — although I can certainly see how this would be handy.

I’m afraid that in this case, you’ll have to do the work in script behind the scenes and I can think of a couple of ways to do that:

The first is basically what you didn’t want me to suggest so I won’t elaborate on it.

The second is to use a Stored Procedure in your SQL database. The advantage of this solution is that you could write a little bit of SQL to substitute string values that come across as “null” for the real NULL value, prior to the value being inserted into the database via an INSERT statement in your stored procedure, rather than putting the script directly in the form and building a special SQL statement. Furthermore, you could use the same Stored Procedure in other forms without having to re-write the “null to NULL” code.

I can’t say that I’ve tried the Stored Procedure option myself but it’s definitely possible to use them in data connections so this might be worth a try.

Ernest Brown,

Since Acrobat doesn’t maintain a live connection to the database table, you’ll need a way to reload the data from the database if you know that it changed. Data connections simply contain the information that Acrobat needs in order to connect to the database and extract the information required or write the information specified via field bindings or the SQL statement when required (i.e. the user must do something to prompt Acrobat to access the database, such as opening the form, clicking on a button to move to the next record, etc.).

For example, if your form is loading records into a table similarly to the way in which the script in my displaying all records from an ODBC data connection is displaying all the records in a database, then you would simply extract the script in the root subform’s (named “form1”) Initialize event and put it in a script object function. (You can insert a script object by right-clicking the root subform at the top of the Hierarchy palette and choosing the “Insert Script Object” command. Then give it a name by selecting it in the Hierarchy palette. Finally, open the Script Editor palette and paste the script into a function.) Then you call the function from the root subform’s Initialize event so that the records are loaded when the form is opened and then you could add a button to the form which would also call the same function. The last step would be to add a call to “_MovieSF.setInstances(0);” at the beginning of the function so that any existing instances are removed prior to being re-added.

Stefan,

Thank you for your expertise. I do need some focus though. I have developed a form that I want to extract the data from. The data comes from the various fields that are filled out. I want to export to an access database. I am very novice with scripting, but have managed, using some of your examples, to build a data connection that “pulls” data from a database. Can you provide me some guidance on how to take data that I enter on a form and export that to a database? I see several options, but get lost in the details, “update”, append, EOF, etc”. Which to use and how? Any guidance you can provide will be most appreciated.

Thanks,

Stan

Thank you for your response. Actually I chose not to create a new dsn. I used the resident MS Access Database to avoid setting up a dsn on the users machines. My connection string is Provider=MSDASQL;Extended Properties=”DSN=MS Access Database;DBQ=\\Wlsfiles\Srv01\WILSON PUBLIC FOLDER\FORMS\SALES FORMS\Pricing Environment\Pricing Environment.mdb;DefaultDir=\\Wlsfiles\Srv01\WILSON PUBLIC FOLDER\FORMS\SALES FORMS\Pricing Environment;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;”
I checked one of the machines is wasn’t working on and she does have the MS Access Database DSN on her machine. Is there a connection string I could set up on the server side? There will be to many users to change their computers.

Stefan,

I have a form that I created in Adobe Professional 8 (LiveCycle Designer). I have used your other examples and created the form using subforms that will add an additional subform when a button is clicked. This form is based on 10 different subforms. (One for each table that I have in a database)

I am connecting this form to an Acces 07 database. In other examples, you said to create multiple data connections for each table using an SQL statement if your table has an autonumber, which mine does. I have created a few sample connections for each of my table. (I have 10 tables in the database). I know that I can do this process, but because of the number of tables and fields, it will take some time to complete.

What I need this form to accomplish is:
1. Have the customer complete the form.
2. When I have played around with the form, I get a message that the form is trying to connect to the database, and I have to click yes to allow or no to not allow the connection. I do not want the customer to see this message. However when I receive the form, I need to use this connection. How can this be done?
3. When the form is received by me via email, I need to have the information put into the database. (I have tried importing the form using the dataset export with Adobe Professiona 8, but since there are 10 tables, the export function produces 10 NEW tables. It will not update the already existing tables, even though that choice is seletected. Needless to say this makes a mess out of the database.) It would be much cleaner to be able to take the form and put it directly into the database using a submit button that only I would be able to see when I receive the e-mail back.

So this brings me to this blog. I have tried using the sql example connection that you have given, but I really don’t understand it. (i am not a programmer, html programmer, and database person) I tried using the tutorial on creating an sql data connection, and have been very unsuccessful. I simply do not understand it. Is there a simple way to do this that I may be able to do without using the sql data connection?

In an earlier post, you had given an example of a javascript

xfa.sourceSet.DataConnection.addNew();

where “DataConnection” is the name you gave to your data connection when you defined it.

This will cause a new record to be created (but not inserted) and all the bound data fields will be emptied (rather than being populated with data from the first record).

Then, in your “Submit” button’s Click event, put the following JavaScript statement:

xfa.sourceSet.DataConnection.update();

This will update the new record with the data entered into the data fields and insert it into the database.

I tried inserting this into the form, and LiveCycle will not allow it, because the subforms were created in formcalc. Is there a way to make this script work in formcalc?

In simple language, what is the difference between using this script and using a my sql connection? From what I have read, it just means that you have to bind the data of each field, is this correct?

I really need help with this, I have worked for weeks trying to do this connection and getting it to work, and have become very frustrated!!!!

For those having the same problem as Nener, where you are able to connect to the Datasource but get the error:
“Error:accessor xfa.sourceSet.dataconnections.update()” it is most likely that you are using Adobe Reader to connect to preview your PDF form. Adobe Reader is unable to connect to datasources you need Acrobat Professional for this.

One way to get around this (sort of), if you have the Reader Extensions component is to extend the document to enable “Database and web service connectivity”. Then open the document with Adobe Reader and test, it should work. This would be as a last resource since you’d have to extend the document every time you modify it, which is not cool at all.

Hope this helps.

Warren Worth,

I’m glad to hear you got your form to work!

Unfortunately, the system using the form (visiting the site) will need to have the DSN configured on it in order for Acrobat/Reader to communicate with the database.

An alternative (which would also be more secure) would be to create a web service that interfaces with the database and connect the form to the web service. This way, the system using the form wouldn’t need any configuration.

Before you go to far down this road, however, you should note that Reader cannot import data from databases or web services without the form being extended using LiveCycle Reader Extensions to enable that PDF, when used in Reader, to communicate with databases/web services. Another way of importing data is by using LiveCycle Forms and obtaining the data on the server and merging it into the form prior to it being served to Reader on the client.

Warren Worth,

How about posting the form data to a web page which then connects to the database and inserts the data? If you needed this to be secure, you could connect to the web page using HTTPS (assuming you have a certificate)…

parwez,

I believe this is caused by the fact that you cannot import data in the free Reader without first extending the PDF to enable data import capabilities using LiveCycle Reader Extensions. Another option is to use LiveCycle Forms to render the PDF to the client (e.g. browser) since the data import will be handled on the server rather than on the client (in Reader).

Tan Tran,

You’ll need to connect your form to your Oracle database using an ODBC data connection, at the very least. Depending on your security requirements, you may have to connect it to a web service which then communicates with the database on the server (which is a much more secure solution than exposing your database on the Internet).

Have a look at the database-related articles in my blog’s Data Binding category. You’ll find examples there.

Dear Stefan,
first I’d like to thank you for your enthusiasm with which you’re helping us, it’s a great resource of knowledge. I have been going through your posts on connecting to a database and selecting a single item from a database, and encountered two basic problem.
1. When I tried to connect to the Movie database you created, I couldn’t find the MySQL Driver among the possible drivers offered by LiveCycle, although I had installed it, and created the DSN.
2. I tried to connect to an Access database that did not have auto incrementing fields, used the script to retrieve data, but all I could achieve was the displaying of the first record.
What did I do wrong. Also, I could use a general description of the idea of Data Drop-down Lists, and the script that is shipped with it, because I guess it would make things much easier. Is there a basic readout out there about connecting to a database?
Thanks in advance:
Martin

Stefan,
thanks again, actually I did create a System DSN, still the MySQL Driver wouldn’t show among the drivers in LiveCycle.
On the other issue, I think I put it in a wrong way: of course the form should display the first record. The problem was the Data Drop Down List simply didn’t drop down (maybe I shouldn’t bind it to the ID-field?).
Let me have another question: is there a way to retrieve data from a database and populate fields with the results simply by typing a value in a field, using the field’s exit event. Like, for example, when you have a database containing several thousand subscribers (in which case a drop down list wouldn’t be a very good way to access data), each having an account number, and you only need to type in the account number to the appropriate field to have the other fields automatically filled with the clients name, address, etc. I’d be very happy to hear yes 🙂
Thanks for the link.
Bye:
Martin

Hi Stefan

Just wondering if you know in script how I can retrieve the default value of a textbox?

For example i have in a textbox a default value which contains instructions of what to fill in that textbox.
Then what i want it to do is that on enter it compares the value of the textbox and the default value and if the same blank the textbox ready for entry from the user.
Also on exit i want it to see if the textbox is blank then if it is put back the default value.

Thanks in advance

Hi Thanks for the reply

So are you saying I need to set a variable to the defaulted text?
Is there no way to call the defaulted text from the properties you get in javascript Textbox1.SetToDefault for example?

The problem i’m finding with the variable method is the way javascript handles multiple lines and how you compare that with the text in the textbox.

Thanks stefan thats exactly what i wanted.

So i have now on enter a check with the currentvalue with the template value and if the same empty the field and set the focus. And on exit i have if the field is empty put back the template value.

Can’t see any problems.

I think this way of using the template is great, also makes the code look a lot neater.

Just one quick question, will there be any problem if a user saves the form with some text but then at later date deletes that text and with the script i’ve put in put back the template value? I presume the template is in the pdf form so its always there.

Thanks again stefan this website has been a great source of information on pdf forms.

Hi all,

I am getting this error “GeneralError: Operation failed.” when executing oDC.open();

Up to this line, the script clones my sql DataConnection without problems.

Any ideas on how to fix this?

Thanks you,
Chris.

Hi Stefan,

Thanks for your reply. I ended up using a DSN and it works fine. I am using LiveCycle designer and Acrobat pro 9. My form works fine in either. But when I wanted to test it on Acrobat Reader, after installing it i get this error message:

oDCNode has no properties
41:Doc:Init

I am printing out nCount = oDataConnList.length and it is 0.

Do you have any idea what could be wrong here? If I uninstall the Reader it works fine again.

Thanks in advance,
Chris.

Christian Gaulea,

Unfortunately, you can’t import data into the free Reader without first extending the PDF to enable data import rights using LiveCycle Reader Extensions. That’s one of the drawbacks of using a data connection to a database. Without this extension, your data connection will not function in Reader.

Hi Stefan,

I think I figured it out why I have that error. I have to change the query to select all the column exclude the id instead of select * from that table.

Thanks again,
Han Dao

Hi Stefan,
I have a problem with my pdf document. This doc reads some information from Oracle database and at the end of filling in this should write on the same database but I receive this error:

Warning: JavaScript Window
GeneralError: Operation failed

and it doesn’t write anything.
Can you help me???
Thanks a lot.
Bye
Monia

Stefan,

I am using LiveCycle Designer ES8.2 to create forms/reports that connect to a Microsoft SQL Server Database. These forms are going to be accessed by field/office employees and also by clients via a website that is currently under construction.

Question #1:
After reading this forum and its threads it seems as though there would need to be Adobe Professional installed on each computer that accesses the forms. And/or there would also need to be a local DSN for every user that will use the forms to connect/retrieve/and update data on our Microsoft SQL Server. Is this true? Because this will pose a problem for us; in that they might not want Adobe Professional, nor do we have access to clients’ computers to install DSNs.

Question #2:
Assuming we can work around the problem above. The second issue we have is creating a special script. We have several current Jobs running and many future jobs to follow. In all of our SQL Tables, we have a column specified for ProjectID so we can write a SQL statement to call up all information regarding the specific Jobs.

We need to make a ‘log in’ that will allow the user to select the job they are working on, enter their password and submit! When they submit they will be transported to a navigation page where they can find whichever forms/reports they need. In order to reduce the amount of duplicate forms, I will need an initialize script that will call up the projectID for whoever is logged in. This way I will have not have to duplicate the myriad of forms and update their queries for each new job we take on in the future. I want one universal set of forms and reports that will call up the information specific to the user who is logged in. Do you have any ideas on how to make this happen?

Any light you can shed on this is very much appreciated!

I pretty much have your example working on my computer but I’m experiencing problems trying to translate the principles to my own project. I created a button to submit the contents of a few fields to an Access database. Here is the script:

Database.ExecSQL(“INSERT INTO equipment_list (equipment_number, description, serial_number) VALUES (‘TextField5.rawValue’, ‘TextField6.rawValue’, ‘TextField8.rawValue’);”);

It keeps dumping in “TextField5.rawValue” into the database instead of the contents of that field. I’m sure this is just some silly mistake but I can’t see it for the life of me.

I don’t want to use the xfa.setsource method because I want to be able to create more than one entry simultaneously with the form (there’s a table in the form).

Stu Dotson,

Glad you figured it out. Thanks for letting me know!

I have read all your tutorials and it definitely helped me. I have already know how to connect into a database, deleting, updating, adding new etc. But, now i want to have a filter for it. I have already read your “displaying specific data records” and it help me to filter the data, but whenever im saving it, im having problems. It just, that the field that i want to be in the data drop down list box is the name field, and at the same time. i also have another textbox which this name field is also bind, so whenever i click the update button, it says something about “duplicate fields” or something. Can you please help me.

@Arron Javal,

I’m guessing the error is occurring because you have more than one field bound to the same column (node) in the data connection.

Are you using the techniques I describe in this tutorial? If so, just make sure the update statement you build for the query doesn’t include the name column twice…

And is this even right?

Database.ExecSQL(“UPDATE TblTest SET Fname = “+Fname.rawValue+”, Lname = “+Lname.rawValue+”, SurName = “+Surname.rawValue+” WHERE Fname = “+SelectField.rawValue+”;”)

What im trying is, Updating the field where the first name is the same as the value of the present value of the drop down list.

This works great! I do have one question though. Is there a way to check that a record exists before running an update query?

Hi Stefan Cameron,
I have been following your post and I’m new to livecycle currently using designer es2 version 9. I do have acrobat 9 standard as well.

I’m trying to create a form that has few field for testing I’m only test with two fields. Emname and Empno.
I have the table named Performview in sql and I have aslready created a odbc connector in dsn.
I also created a dataconnection in livecycle form with default name “dataconnection”

I have made binding to the two fields empno and emname in the forms to the respective fields in performview table.
I have a dropdownlist back named selectfield.
I want to be able to drop down(on the selectfield list) and select the empno and populate the two fields empno and emname.
I have a button and I want the populating of the fields to happen when that’s pressed.
When I open the form, I see the form filled with the first record from the table so the two fields in the form emname and empno have the first record.
I have two issue, first the dropdown list does not have any data when I view the form.
2nd when i hit the button when there is no data in dropdown list I get error accessor selectfield.rawvalue unknown.

I event tried to use a textfield(which I prefer to use instead of dropdown as the form user can just put the empno and hit the button, but I wasn’t sure how to do intialize for textfield. I still had the same issue. so I stuck with the dropdown as I saw example for it on how to set up itialize.
so here is the code for both dropdown intialize and button click
I’ll really appreciate if you can tell me why the drop box is not having any data and why I’m getting the error
.I do see the 1st record from the table on the form when I open the form so I know the connector is work and the fields binding is working
Please see code below.

form1.#subform[0].Selectfield::initialize – (JavaScript, client)

var sDataConnectionName = “DataConnection”;
var sColHiddenValue = “Empno”;
var sColDisplayText = “Emname”;

var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex);
oDB.open();
oDB.first();
// Search node with the class name “command”
nIndex = 0;
while(oDB.nodes.item(nIndex).className != “command”)
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayBOF”, “bofAction”);
oDB.nodes.item(nIndex).query.recordSet.setAttribute(“stayEOF”, “eofAction”);

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex < oRecord.nodes.length; nColIndex++)
{
if(oRecord.nodes.item(nColIndex).name == sColHiddenValue)
{
oValueNode = oRecord.nodes.item(nColIndex);
}
else if(oRecord.nodes.item(nColIndex).name == sColDisplayText)
{
oTextNode = oRecord.nodes.item(nColIndex);
}
}
while(!oDB.isEOF())
{
this.addItem(oValueNode.value, oValueNode.value);
//IDList.addItem(oValueNode.value, oTextNode.value);
oDB.next();
}
// Close connection
oDB.close();

form1.#subform[0].Selectfield::click – (JavaScript, client)

var sDataConnectionName = "DataConnection";
var sColHiddenValue = "Empno";
var sColDisplayText = "Emname";

var nIndex = 0;
while(xfa.sourceSet.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oDB = xfa.sourceSet.nodes.item(nIndex);
oDB.open();
oDB.first();
// Search node with the class name "command"
nIndex = 0;
while(oDB.nodes.item(nIndex).className != "command")
{
nIndex++;
}
// Need to set BOF and EOF to stay
oDB.nodes.item(nIndex).query.recordSet.setAttribute("stayBOF", "bofAction");
oDB.nodes.item(nIndex).query.recordSet.setAttribute("stayEOF", "eofAction");

// Search for the record node with the matching Data Connection name
nIndex = 0;
while(xfa.record.nodes.item(nIndex).name != sDataConnectionName)
{
nIndex++;
}
var oRecord = xfa.record.nodes.item(nIndex);
// Find the value node
var oValueNode = null;
var oTextNode = null;
for(var nColIndex = 0; nColIndex 0) then
$sourceSet.DataConnection.#command.query.commandType = “text”
$sourceSet.DataConnection.#command.query.select.nodes.item(0).value = Concat(“Select * from performview Where empno = “, selectfield.rawvalue ,””)
//Reopen the Dataconnection
$sourceSet.DataConnection.open()
endif

Hi Stefan,

We have a problem with tab order.
I want the tab to stop on a text field.

We are designing forms in Designer 8.2.

Thanks, Anders

@Anders,

By “text field”, do you mean an actual text field that you can type into, or static text like a label that cannot be modified by the user?

What seems to be preventing you from including this “text field” in the tab order?