-
If the trigger fails, then the whole transaction will be rolled back and the insert will fail as a result. Is the trigger attempting to use the CCN field value as an int in some way?
-
Yes, on the SQL server I have a trigger, however, the data is never inserted into the table for the trigger to fire.
-
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 ...
-
Do you have a trigger on the CCN field that writes the data to another table?
-
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 ...
-
Are you entirely sure that it's not the ledger column that's causing the overflow? Is its value in any way related to the CCN field?
The maximum value for an int is 2147483647, which explains why 1234567890 works and 7430500002 doesn't.
-
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 ...
-
Unfortunately Sharepoint workflow forces you to store the XML in Sharepoint, but DBXL needs to own/store the XML to handle the propagate delete and the database mapping and even the submit (because DBXL creates and injects processing instructions into every XML).
But as Jimmy says, you can accomplish all of this with conditional mapping in DBXL ...
-
Thanks Jimmy. So I took your advice and added the controls to my ProjectForm form and then tried submitting in my other form. When I tried to open the ProjectForm that was submitted I got a helpful error. The problem was that the new fields in which I added in the ProjectForm had the first letter capitalized. When I updated ...
-
"Where is the data that you want to query?"
Its a Local DB(my PC) :)
"What sort of data connection have you created for it?"
SQL Server Connection, ADO Database Connection
"Does that data connection have the capability of querying partials?"
Yes
here is the Query i use for the partials - select ...