-
Well,
It looks like I have solved my own problem.
I changed the ID field in SQL server to be an 'identity' field. This meant that both primary and foreign keys were optional_int type. It now works fine. Seems that the import from Access to SQL server is not as effective as it could be.
-- Jay Whittaker --
-
Hi Agni,
Good post but I don't understand one things:
quote:4. Get the node in which you want to insert this new node
IXMLDOMNode oParentNode = getParentNode();
What is this method getParentNode() ?
VS say that : getParentNode() the name doesn't exist in the class or in the namespace of the form!
So what I have to do for that work?
In the ...
-
Hi all!
What's up!? Here's my question: I have a button in a Form which clears the fields in it and I'd like that this button, which is at the bottom of the view, after clearing, makes the user see the top of the same view...I don't know if you understand becouse it's difficult to explain!
-
me too!
Every moment hesitated is a moment gone for life!!! Think about it
-
Another update,
I created an entirely new form linked to the database. It seemed to work when adding a totally new item (ID field is auto-generated), however when adding a new item to a list of items that already exist, the ID field remains blank. I checked this on the SQL server and the ID field does not auto generate. I cannot change the ...
-
I am having the exact same problem, even when I re-designed the form from scratch. I would be happy to send you the original form template, can you tell me where or how to send it to you?
Thanks,
Pablo O. Monasterio
-
I am not sure what you mean by roundtrip. But it is mentioned in the Microsoft developer network that Infopath has a limitation. It only likes text (char) field up to 255 characters. Nothing more. It didn't seem access specific.
-- Jay Whittaker --
-
I have now changed my source database and remade the database connection, however the field attributes still show as Optional_int. I would think that this is ok, but its worth a try. I find it strange that two microsoft products are so different. SQL server changes the data types of the original access database and infopath needs its own rules and ...
-
I tried that (go to next error) to get more detail. It tells me that in the ID fields (the fields that I use to link the tables) that only integers are allowed. The data type in the connection is recorded as optional_int, the type in the database source is int (length 4). This should work. I am not sure where this is coming from. I had it working ...
-
Sorry for the multiple post I did'nt know where to post.
your assumsion was correct. The database is connected to sharepoint,
the form is then connected to the user data table, it allows me to filter and retrieve all document names from all doc libs in a shrepoint site.
the trick is the get that assigned number into the user data table and ...