For the first time I am trying to utilise GUID datatype via RemObjects and DataAbstract. I have a column containing SQL (2008 R2) uniqueidentifier. DA Schema Modeler sees this as GUID.
All seems find until posting updates from the client (.NET CF) in which case an error occurs :
Dashes are in the wrong position for GUID parsing
I seem to be having a whole bunch of troubles with GUIDs via RO/DA… could you tell me if there are known issues and/or if there are workarounds (other than using String throughout) to resolve this?
no known issues we are aware of. we have a huge internal DA project (our website) that is built in GUID primary keys, and we have no problems.
do you have a full callstack for the error? DA should transfer and process GUIDs and binary, not strings, so i can’t think off the top of my head where there could be any parsing of guids from strings (not to mention why the string would be wrong).
It looks to me as though the error is surfacing SQL server side, when the GUID is submitted to SQL server itself. I may be wrong, but that’s how it looks.
In fact in this case the GUID is a column of the table we are inserting to, but it is not the primary key.
I will try to build up a little more information around this, and do some other simple table testing to see what conclusions can be reached.
thanx. can you do two things? (a) post the complete error message and call stack, if available and (b) hook into the appropriate event (i don’t have the library before me) and log the SQL code that is being generated?