Previous | Next | (P-PDF) Forms & FDF

Topic: No Topic
Conf: (P-PDF) Forms & FDF, Msg: 28093
From: IMSAK
Date: 10/4/2001 12:11 PM

Thanks to those who e-mailed me on the importTextData()problem. It seems that there are numerous data format issues that make the use of this method impractical for any large amounts of data.

Going on to my next problem. I am now using the ADBC data connection method. The following works fine for connecting to the data, and by using a populateForm() function, the connection statement connects and the fields in the form fill in with nill.

***********
function getConnected()
{ Mapsoft = ADBC.newConnection("Mapsoft");
statement = Mapsoft.newStatement();
statement.execute('Select * from "DATAMAST"');
statement.nextRow
row = statement.getRow();
populateForm()
}
**********
By adding the following to a next button, I am able to cycle through the records one at a time.
**********
var e;
try {
statement.nextRow();
}catch(e) {
getConnected();
}
var row = statement.getRow();
populateForm(row);
***********
I would like to select a particular record from the database without having to cycle through the records. If I add a where statement to the statement.execute above, Acrobat errors by saying uncaught exception in statement.execute.

Here is what I change the statement.execute to:
*********
statement.execute('Select * from "DATAMAST" where "A2" = "47894"');
**********

If I change the * to a particular Field name, even without the "where" clause, I still get the same error. It's like any type of query instructions cause the error to occur. I can see the data, I just can't query it. I have tried several types of query formats and still get the same error.

I am hoping this is something simple.
Any suggestions.

Thanks,
Bob