dbTalk Databases Forums  

UUID field in .NET API

sybase.public.sqlanywhere.ultralite sybase.public.sqlanywhere.ultralite


Discuss UUID field in .NET API in the sybase.public.sqlanywhere.ultralite forum.

Reply
 
Thread Tools Display Modes
  #21  
Old   
PGP
 
Posts: n/a

Default Re: UUID field in .NET API - 09-30-2008 , 08:10 PM






"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote

Quote:
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write conversion
functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh





Reply With Quote
  #22  
Old   
PGP
 
Posts: n/a

Default Re: UUID field in .NET API - 09-30-2008 , 08:10 PM






"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote

Quote:
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write conversion
functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh



Reply With Quote
  #23  
Old   
PGP
 
Posts: n/a

Default Re: UUID field in .NET API - 09-30-2008 , 08:10 PM



"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote

Quote:
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write conversion
functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh



Reply With Quote
  #24  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #25  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #26  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #27  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #28  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #29  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM



Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
  #30  
Old   
Mike Vander Ploeg
 
Posts: n/a

Default Re: UUID field in .NET API - 10-01-2008 , 09:58 AM






Priyesh, I have a couple of questions.

1. How is your UUID column declared? Is it a uniqueidentifier, a binary,
or a varchar?

2. How were the UUIDs originally added to the database?

Mike Vander Ploeg
Sybase iAnywhere

"PGP" <priyesh@do_not_reply> wrote

Quote:
"David Fishburn" <fishburn_spam_off (AT) ianywhere (DOT) com> wrote in message
news:Xns9B25D197DD4C9fishburnsybasecom (AT) 10 (DOT) 22.241.106...
"PGP" <priyesh@do_not_reply> wrote in news:48dd4c0f$1@forums-1-dub of
sybase.public.sqlanywhere.ultralite:

P> Ultralite v 10.0.1.3579
...
P> {12e81951-7d66-0a45-906d-33a622e04996}, where the actual uuid was
P> {5119E812-667d-450a-906d-33a622e04996}
P
P> notice the reversal in the first 16 bytes.

That is interesting.
Two things to consider to help identify where the problem might be.

1. Copy the UDB to your desktop.
- Fire up dbisql and select the same value to see how it is shown.

2. Write a very simple .Net app that selects from that table on your
desktop to see what value is displayed.

Can you show us the output from the 2 above.

David,

1. The application is on a tablet. I did a query using dbisql before and
here is the copied result
0x5119e812667d450a906d33a622e04996 (select guid1 from table)

2. The code i posted first was the code from a simple .NET app i wrote to
test this
after my colleague pointed it out and told me how he had to write
conversion functions to
get around this behavior.
The .NET output string or watch string -
{12e81951-7d66-0a45-906d-33a622e04996}

Priyesh




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.