TypeConverter Oracle Guid

Posts   
 
    
railsberto
User
Posts: 2
Joined: 09-Nov-2006
# Posted on: 09-Nov-2006 05:18:23   

Hello All,

We are using llblgen to a new project but in the middle of the development almost 2 weeks before put in test our boss want to change the database, we are using SqlServer but now we must use Oracle 9.

Well we create the tables and everythiong, i understand the Type Convertor to Bool but i can't figure out how to create a type converter to guid? Somebody can help us?

Thank's Alot

bob

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 09-Nov-2006 06:42:21   

GUID can be stored in any string oracle data type. And then you can convert it to GUID as follows:

Dim  myGuid  As new Guid(guidSringFromTheDatabase)
railsberto
User
Posts: 2
Joined: 09-Nov-2006
# Posted on: 10-Nov-2006 02:36:54   

Very thanks for your help, but i don't think if i can be expressive.

Let me explain, we are using Adapter to CRUD, the Guid fields is our PK when i put adapter.saveentity, it will be created a new guid into the field?

Thank you, bob

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 10-Nov-2006 08:01:26   

I'm not sure I understand your question.

But you should create a new GUID in the code and use it when Inserting a New Entity into the database.