[Firebird-net-provider] System.Guid

[Norbert Saint Georges]

Hello

I have a problem with GUIDs below, describe

 

CREATE TABLE RM_CUSTOMERS_LINK_GUID (

    GUID    CHAR(16) CHARACTER SET OCTETS,

    GUID36  VARCHAR(36),

    UUID    COMPUTED BY (uuid_to_char(guid))

);

 

method MainForm.insert_RM_CUSTOMERS_LINK_GUID( GUID: System.Guid    ; GUID36: 
System.String  ):System.Int32;

Begin

   var sqlCommand: StringBuilder := new StringBuilder;

   sqlCommand.Append('INSERT INTO RM_CUSTOMERS_LINK_GUID ( GUID, GUID36)');

   sqlCommand.Append('  VALUES ( @GUID, @GUID36)');

   sqlCommand.Append(' ;');

   var arParams: array of FbParameter := new FbParameter[2];

   arParams[0] := new FbParameter('@GUID',FbDbType.Guid);

   arParams[0].Direction := ParameterDirection.Input;

   arParams[0].Charset := FbCharset.Octets ;

   arParams[0].Value := GUID;

   arParams[1] := new FbParameter('@GUID36',FbDbType.VarChar, 36);

   arParams[1].Direction := ParameterDirection.Input;

   arParams[1].Charset := FbCharset.Iso8859_1 ;

   arParams[1].Value := GUID36;

   var rowsAffected: System.Int32 := 
FBSqlHelper.ExecuteNonQuery(getdestination, sqlCommand.ToString(), arParams);

   exit rowsAffected;

end;

 

 

var UserGuid : System.Guid := System.Guid.NewGuid;

 

insert_RM_CUSTOMERS_LINK_GUID(UserGuid,UserGuid.ToString);

 

result :

GUID

GUID36

UUID

ê„þET +Mƒ $T•— È

45fe84ea-0b54-4d2b-83a0-2454959713c8

EA84FE45-540B-2B4D-83A0-2454959713C8

 

 

Why ?

 

 

 

 

   Norbert Saint Georges

 

   TetraSys Oy

   Bergantie 69, FI-02540 Kylmälä

   Tel. : +358 (0) 400 27 25 18

   E- mail : n...@tetrasys.fi <mailto:taru.kaukova...@tetrasys.eu> 

 


------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider