Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Upsizer and uniqueidentifiers
Message
De
09/09/2013 17:58:15
 
 
À
09/09/2013 12:21:01
Information générale
Forum:
Visual FoxPro
Catégorie:
VFPX/Sedna
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01582231
Message ID:
01582637
Vues:
42
>H Charles.
>
>>I am going to try hacking the width of that column and see if there isn't any other place it gets truncated
>
>The problem is the column isn't sized wide enough in the CreateWZTable method in Wizusz.prg. Find the second CREATE TABLE statement in that method and change RmtType C(13) to RmtType C(20).
>
>>the error using bulkxmlload by the way is that the character expression is invalid for the cast to uid - which means something is getting lost in the Xml rendering
>
>Maybe it wants (or doesn't want, depending on what you have) the curly braces delimiting the GUID value.
>
>Doug

No curly braces in the GUIDs - just 32 digits and four dashes.

In any case, the wizard works so well without tweaking (love the way it adds time stamps) I just use it as is, including using bulk inserts and then wrote tsql scripts that convert the c(36) to UID and set the PKs

Have all the views in another DB with no tables (as one should <g> ) so haven't found any way to work Sedna Upsizer magic on them. Suggestions?


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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform