General

Re: Multiple and different data sources

cappsie — Thu, 01 Mar 2012 14:13:12 GMT

Hiya, The web service option is the way forward. I haven't actually coded a form yet, but so long as I can link or bind each button to each form, that should suffice. I would very much like to see your demo. I'm not sure I can afford the Qdabra's DBXL at present. If I can do it without that, I would prefer that option. Let me know. Thanks Adam

Re: Multiple and different data sources

Patrick Halstead — Wed, 29 Feb 2012 18:14:02 GMT

Hi Adam,

You can definitely have separate Web service calls in one form. For SQL, the best practice is to not have a direct connection, but rather to use a Submit connection to a Web service. This may require redoing your form and writing a Web service or installing a generic one, like Qdabra's DBXL (an inexpensive option).

We do this kind of query and submit all the time and it is totally possible. I'd be happy to show you a quick demo if you're interested.

Just email me.

Thanks,

Multiple and different data sources

cappsie — Wed, 29 Feb 2012 14:52:34 GMT

Hi I'm not entirely sure where to post this question so here's a good start. I work for a healthcare provider and I'm building forms to replace paper in an attempt to save the organisation money. I have a patient administration system and a SQL server. My plan is to build a form which can retrieve patient demographics via a web service into the form, populating its fields, and then save that data to a SQL server. I have to call perhaps two web services, which I can do when each is on an individual form; the same can be said of the SQL server form: I am able to both retrieve data from and submit data to a database - this I can also do successfully. What I cannot do is all of it on one form. I need a way to section off the patient/web service search from a different web service search. Currently one button runs all queries, which is quite annoying. So any pointers to pertinent documentation and thoughts are welcome. Thanks Adam