Qdabra Database Accelerator

Re: DBXL Training Documentation

Patrick Halstead — Mon, 30 Apr 2007 22:59:31 GMT

Hi Tolansp,

Thanks for the reminder. We'll post this to the site this week. Stay tuned.

Re: DBXL Training Documentation

Matt Faus — Mon, 30 Apr 2007 22:57:17 GMT

Hi snyderjd,

I'm not terribly fluent in VB, but I don't see any loops in your web service code. You will have to either call that method multiple times, or loop through each of the rows within the method itself. If you are calling the method several times, you might want to check the key constraints in SQL. Sometimes you will overwrite your previous entry if you're not careful.

Regardless, this seems like a perfect situation for DBXL. Why write this huge custom web service for shredding XML into SQL when we have already done it? Plus, ours comes with a myriad of additional features.

Re: DBXL Training Documentation

snyderjd — Thu, 26 Apr 2007 22:45:27 GMT

I too am having the same problem. I have a web service that has been created allowing me to insert to SQL 2005 database. However, I am only able to insert the first row of a repeating section. I was hoping Qdabra would be the solution, but the documenation only really discusses the sample ExpenseReport Is it possible to use a different form?

If not, here is a copy of the WebService I am using for the insert statement... this is very simplified version of what I am trying accomplish... (for testing purposes only)

The infopath form is a single repeating section with two fields [txtAppName] & [intAppType]

Here is the sample Web Service I am using... again it only inserts 1 row regardless of how many repeating sections I have...

<%@ WebService language="VB" class="TestClass" %>

Imports System
Imports System.Web.Services
Imports System.Xml.Serialization

Public Class TestClass

<WebMethod> Public Function Add(a As Integer, b As Integer) As Integer
Return a + b
End Function

<WebMethod> Function InsertApplication(ByVal appName As String, ByVal appType As Integer) As System.Data.Dataset
Dim connectionString As String = "server='server1\application'; trusted_connection=true; database='Application"& _
"Type"
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlConnection(connectionString)
Dim queryString As String = "INSERT INTO [tblApplication] ([AppName], [AppType]) VALUES (@AppName, @AppType)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlCommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection

Dim dbParam_appName As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_appName.ParameterName = "@AppName"
dbParam_appName.Value = appName
dbParam_appName.DbType = System.Data.DbType.[String]
dbCommand.Parameters.Add(dbParam_appName)
Dim dbParam_appType As System.Data.IDataParameter = New System.Data.SqlClient.SqlParameter
dbParam_appType.ParameterName = "@AppType"
dbParam_appType.Value = appType
dbParam_appType.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(dbParam_appType)

Dim rowsAffected As Integer = 0
dbConnection.Open
Try
rowsAffected = dbCommand.ExecuteNonQuery
Finally
dbConnection.Close
End Try

End Function
End Class

Re: DBXL Training Docuementation

tolansp — Thu, 26 Apr 2007 22:16:45 GMT

Was the advanced Topic Document ever designed? The new Getting Started still does not really address the all the functions that are available. It's more of an appendage to what a products document would be. We're really trying to see how we can point the service to another one of our databases within SQL and use the webservice to tie our Infopath form in. This is a new Submit Only form and our only need for the webservice is that we have a few large data type fields. We've successfully designed a webservice to insert items into the document, but have had difficulty with the Repeating Tables and Repeating sections inserting into the db.

Re: DBXL Training Documentation

Kaoru Okumura — Wed, 07 Mar 2007 06:50:24 GMT

Here is updated "getting started" for DBXL Version 2: http://www.qdabra.com/Content/ProdInfo/DBXLv2/GettingStarted.htm thank you!

Re: DBXL Training Docuementation

Patrick Halstead — Tue, 06 Mar 2007 07:20:52 GMT

Hi TolanSP and welcome to the forum,
We are finishing the documentation for V2. The Getting Started document has been revised recently. We also have an Exploring Advanced Topic document that we will be releasing shortly. Thank you for your patience.

DBXL Training Documentation

tolansp — Mon, 05 Mar 2007 23:35:03 GMT

Are there any other training docs or software instructions for the DBXL suite? All I've seen is the 'Getting Started' documents which aren't very detailed, have missing images, and aren't really comprehensive of the suite product.