I tried using the class browser to modify the mapper grid to give more room to the remotetype, but I think the width is either getting overridedon the the parent form or the data source is determining the width. I do see the full name int the dropdown but it is truncated after picking. May fiddle with it again ( grids are one of the things I don't miss about VFP )
If there isn't a good way to have all the c(36) nocptrans default to uniqueidentifer, I think I'll ulimately use plan B ( see my exchange on this thread iwth Kevin about changing the date type on the server side with t-sql ) but still would be cool if uniqueidentifier was an option (with the caveat that I think there is still a problem if the user chooses bulkxlmload )
REAL football started tonight <g> Any chance Tebow is going to find a home north of the border ??
>Hi Charles.
>
>>uniqueidentifier is not an option on the dropdown. I thought I might get it on there by fiddling the typemap table to make uniqueidentifier one of the choices for character (in place of text)
>>but when I rebuild the app I get an operator/operand type mismatch ( which it is technically as only a very specific string would be seen by SQL as a uniqueidentifier.
>
>I looked into this. It's a goofy error caused by the TYPEMAP table already being open (likely because you added the uniqueidentifier record to it). I've fixed that but in the meantime, you should be able to CLOSE DATA ALL before running the Upsizing Wizard and it should work.
>
>A couple of other things:
>
>- I added several missing data types: uniqueidentifier, ntext, nchar, nvarchar, etc.
>- There's a weird versioning thing in the TYPEMAP table and associated code. I've taken care of that too, but in the meantime, you probably have to put "SQL Server4x" into the SERVER column of the new record in TYPEMAP.
>
>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.