🚀 go-pugleaf

Baris YURTCU wrote:
>>>I also tried "SELECT Uniqf, Field2, Field3 FROM dbo.myTable". But the
>>>
> result
> 
>>>is same.
>>>
>>
>>I also noticed that in your first post you had:
>>
>>   Edit1->Text=DataModule1->DataSource1->DataSet->FieldValues["Uniqf"];
>>
>>but you mentioned the field name is UniqueIdentifier, is that correct?
>>
> 
> No, not field NAME. I mentioned the field TYPE is uniqueidentifier. (for
> example, Field2's type is varchar. Like that, Uniqf field's type is
> uniqueidentifier)
> 
> 
>>Another suggestion I would make is to be sure your connection is
>>becomming active. If it is not then you would also get the Field Not
>>Found error.
>>
> 
> I am sure connection is active. At design time, I put a DBEdit onto my form
> and set it's DataSource property to 'DataSource1'. Then I click it's
> combobox of DataField property, a list appears and all fields of myTable are
> there (for example Field2, Field3). But the field Uniqf is not.
> 
> 
>>If that doesn't help let me know, I will try to throw out some more
>>ideas. :)
>>
>>
> 
> :) Thanks for your interest David.
> Baris.
> 
> 
> 

May it be that uniqueidentifyer fields identify the row with a 'Uniqe' 
value wich wouldnt be transmitted to an Normal user? These Fields are 
usaly the sole property of the Database, so they dont get transmitted to 
an Application. Perhaps you get the Field by logging on as 'sa'.