Search - InfoPath Dev Sign in | Join | Help InfoPath Dev InfoPath Dev is dedicated to bringing you the information and tools you need to be successful in your Microsoft Office InfoPath development projects. Home Blogs Forums Photos Downloads Search More Search Options Page 1 of 1 (9 items) QueryDB Problems Hello - I followed these instructions to the letter http://www.infopathdev.com/files/folders/web_methods/entry32474.aspx yet I am getting an error. I am trying a dynamic query here is the sample query: <query database='#CORLOG#' table='vendor-tbl' maxrows='2'><columns><column ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-22-2010 Re: data conversion It appears to be the trigger on the table. If I disable the trigger then the shred is successful. Thanks for you help! Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 Re: data conversion Yes, on the SQL server I have a trigger, however, the data is never inserted into the table for the trigger to fire. Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 Re: Form Services Enrty It still gives me a duplicate form in sharepoint. For example, my user creates a purchase request, it goes through the work flow and at the end when it is shredded I get a form called 32 with the same data as the purchase request. The 32 came from qdabra, I don't need that form to added to my sharepoint site I just need the data ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 Re: data conversion Yes, I am sure it is the CCN field. I removed it from the mapping and the shredding/reshredding works fine. If I remove the Ledger field the shred/reshred fails. I changed the ledger from an int to a string and it still fails. I deleted the field and added a new field with a new name, remapped it and it still ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 data conversion I have a field in a form that is setup as a string type. In my database the field is an nvarchar(max). When the field is shredded to the database and contains numbers like 123457890 it works fine. When I submit the numbers 7430500002 I get the message: The conversion of the nvarchar value '7430500002' overflowed an int ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 Re: Form Services Enrty Hillary - Yes, if I open the original document and resubmit it will duplicate. I have not tried to edit and submit the document that is created by qdabra. I think the real issue here is that I am not using qdabra as my initial submit. Ernesto - This is a purchase approval document and needs to go through an approval process ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-19-2010 Re: Form Services Enrty It is really two issues and I wrote it out as three. 1 - Documents don't delete in Qdabra when deleted from sharepoint. 2- When I resubmit a document to Qdabra it is created as a new document in qdabra and on the sharepoint site. Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-18-2010 Form Services Enrty Hello - My forms go through a workflow process and at the end I want them to be submitted to Qdabra. The issues I have is when they are submitted to Qdabra 1. A new IP form is created with the Doc. ID as the name. 2. Since the form is really an update to the database (I have a trigger setup on a table to update to another table.) there ... Posted to Qdabra Database Accelerator (Forum) by brandon.gill on 03-18-2010 Page 1 of 1 (9 items) Copyright © 2003-2019 Qdabra Software. All rights reserved.View our Terms of Use.