🚀 go-pugleaf

Serra wrote:
> IB 6,02
> 
> I'm created a LookUp form
> with   SqlQuery,DSP,CDS ,  i want to
> get  first two fields of releated tables( Parts,Customers,Vendors.)
> 
> for example :
> MyQuery:='SELECT FIRST 2 FIELDS FROM '+ ComboBox1.Text
> SqlQuery.Sql.Add(MyQuery);
> Cds1.Open;
> if combobox.text='Parts then
> i want to get PartNo, PartName
> if combobox.text='Customers then
> i want to get CustNo, CustName
> ....
> Is it Possible to select just first 2 fields of a table ?
> 
> Thank you. 
> 
> 

Right from the help...


I presume you have a "TSQLConnection" --> To a Query, To DSP (Provider) 
to a CDS (Client Data Set) --> DataSource.

The use the Fields[i] method to pick off the first two fields...


CustTable->Fields->Fields[0]->AsString;

Bot that you can't do this directly from the SQL Component from the Dataset

Pull them up in help and look at the Hierarchy -- that should provide 
all the clues you need.

It's not SQL -- but then MSQuery is effectively a client app as well --- 
and that ain't SQL anyway.

Hope that helps.



-- 
Will R
PMC Consulting