Recent content by Vorort

  1. V

    Resolved Getting primary binary key?

    I resolved the problem by: SELECT CONVERT(VARCHAR(max), GGUID ) FROM dbo.xxxxx WHERE KEYWORD LIKE 'Avast' Now I get the right guid . Thanx for reading and / or replieing Cheers
  2. V

    Resolved Getting primary binary key?

    I'll try to explain what I happens: in the table on the server is a primary key declared gguid binary(16) From this table I need to get some information and then alter another table linked to this table using the primary key from the first. When I select one row using a keyword and reading the...
  3. V

    Resolved Getting primary binary key?

    Sorry, I'm a newbie
  4. V

    Resolved Getting primary binary key?

    Thank you for your reply. I tried to do so but when I want to update a record with the returned guid it will fail because the returned guid is not existing in the table
  5. V

    Resolved Getting primary binary key?

    Sorry i wasn't clear enough. The field I'm trying to read is a guid. When I read the field tape in vb (like idx = reader.GetDataTypeName(0)) it returns binary. Then when I read the contents of that field like (retval = reader.GetSqlBinary(0).ToSqlGuid) the returned value diffiers from the value...
  6. V

    Resolved Getting primary binary key?

    Hello there, I've to get a primary key from ms sql database table. Unfortunate th keys are declared as binary length 16. My query recognizes the field as system.binary and I don't know how to use this field further to insert data or modify another table which is linked using this key. Does...
Top Bottom