Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

12-03-2009

Just sent you the samples that I have

Avatar

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
_nickarmstrong_
Level 1

13-03-2009

Paul,



I'm looking at them right now. Thank you very much. This seems to be far more simple than another example i was trying to learn. I will work to adapt this to my database, and i'll get back to you if i need more help....which i probably will.



Nick

Avatar

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
_nickarmstrong_
Level 1

13-03-2009

Paul,



I am about to try the PDF on my database, we'll see if I've adapted the script the right way.



You sent me 2 XDP files, is the difference that one is written in Java, and the other in Formcalc?



Thank you,

Nick

Avatar

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
_nickarmstrong_
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
View profile
_nickarmstrong_
Level 1

13-03-2009

Paul,



Adobe gives me this error: Couldn't post data ".



I modified the javascript to fit my data connection and table names, but i'm not sure if it is correct:



form1.#subform[0].Button5::click - (JavaScript, server)

//xfa.sourceSet.ftmServiceCalls.close();



//set up sql call to DB to get specifics about employee



xfa.sourceSet.ftmServiceCalls.nodes.item(1).query.setAttribute("text", "commandType");

xfa.sourceSet.ftmServiceCalls.nodes.item(1).query.select.nodes.item(0).value = "Select * from servicecalls where ServiceId = '" + ServiceId.rawValue + "'";

//app.alert(xfa.sourceSet.ftmServiceCalls.nodes.item(1).query.select.nodes.item(0).value);



//now connect to DB and get a record

xfa.sourceSet.ftmServiceCalls.open()



Also, for some reason, the "Service Id" box populates with a number right away, is there a way to have it be blank when i start up?



Thank you,

Nick

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

16-03-2009

In the Data Connection wizard on the last panel there is a checkbox for delayed open. make sure it is chcked. This will cause the database connection to be delayed until you issue an open() statement. If you do not the data connection is established when the form loads and as such the 1st record is returned and bound to your form.

Avatar

17-03-2009

Hi Paul,



could you send me the data view sample files as well?



Thanks in advance!



uli_svw (at) gmx.net

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

17-03-2009

Just sent it

Avatar

17-03-2009

Can I have a sample too?

Probably I can modify it to solve my newest problem... 😕

diefeuerolke@web.de

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

17-03-2009

Just sent it

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

17-03-2009

Your email address just came back as invalid ..is there a typo?