>Hi Charles.
>
>>Thanks a lot Doug, I will give all this a try. Since I have about 400 columns that are c(36) nocptrans can you think of a good way to set the default for those to uniqueid rather than changing the mapping by hand on each one?
>
>You could temporarily set TYPEMAP.DEFAULT to .T. for the uniqueidentifier record and .F. for the other records with LOCALTYPE = 'C', but then you'd have the same issue with your other non-ID character fields: having to manually change the default.
>
>>And do you know anything about the data type mismatch that I get just trying to use bulkxmlload into a table with uniqueidentifiers when the VFP cursor column is c(36) nocptrans (I'm assuming I'll get the same problem if the upsizer creates a UID column and I have bulk insert checked in the wizard)
>
>I suggest tracing the code in BulkXMLLoad.PRG to see what's going on.
I think the part of code that eats it is in the component that gets instantiated SQLXMLBulkload.SQLXMLBulkload.4.0
I should probably run it again, though and really check the param that get passed to it to see what the lcdata looks like.
Will report back.
>Doug
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.