Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Fri Oct 19, 2018 12:58 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: How to know the field is Foreign key or not
PostPosted: Thu Sep 13, 2012 1:56 am 
Offline

Joined: Mon Jan 16, 2012 8:08 am
Posts: 161
Location: India
Hi All,
I am using RealSqlDatabase in my application. After getting the database i am trying to access the all the table after that i am accessing the field of a table. I am accessing the Field Schema of a table like this

Dim TableFieldRecordset as Recordset
TableFieldRecordset = Tablename.FieldSchema()

Dim IsPrimary as Boolean = TableFieldRecordset.IdxField(3).stringvalue

By this code i am able to Know this corresponding field is primary key or not . But my problem is that how to know that this field/column is foreign key or not. Please some help.

Thanks
Bimal


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group