Retrive data from Tquery Select statement.Please help

Thread View: borland.public.cppbuilder.database.ado

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Jonathan Sun, 17 Dec 2000 13:37

#5859

Author: Jonathan
Date: Sun, 17 Dec 2000 13:37

17 lines
1826 bytes

Hello all.
Please describe how I can retrive data from Tquery select statement
after I did:

Querry ->Close();
Querry ->SQL ->Clear();
Querry ->SQL ->Add("select FIELDNAME from TABLE where NAME = '"
                                 + Name + "'");

 Querry ->Open();

  if ( Querry ->IsEmpty() )
    Application ->MessageBox(" The FIELDNAME doesn't exist ", NULL, MB_OK);
 else
    Retrive FIELDNAME ??????????????????????

Thanks a lot

Re: Retrive data from Tquery Select statement.Please help

#5858

Author: Jeff Overcash (TeamB)
Date: Sun, 17 Dec 2000 17:38

34 lines
2451 bytes

Querry->FieldByName("")->AsXxxxx

Do not multi post in the future.  This goes against the rules of use for these
newsgroups (www.borland.com\newsgroups) and can get your posts canceled.  Your
question had absolutely nothing to do with ADO, InterbaseExpress or Multi-tier
work.  Pick the single most appropiate group and ask it there.

Followups set to database.desktop.

Jonathan wrote:
> 
> Hello all.
> Please describe how I can retrive data from Tquery select statement
> after I did:
> 
> Querry ->Close();
> Querry ->SQL ->Clear();
> Querry ->SQL ->Add("select FIELDNAME from TABLE where NAME = '"
>                                  + Name + "'");
> 
>  Querry ->Open();
> 
>   if ( Querry ->IsEmpty() )
>     Application ->MessageBox(" The FIELDNAME doesn't exist ", NULL, MB_OK);
>  else
>     Retrive FIELDNAME ??????????????????????
> 
> Thanks a lot

-- 
Jeff Overcash (TeamB)   | Talk about failure
(Please do not email    | To fall is not to fail
 me directly unless     | Failure isn't about falling down
 asked.  Thank You)     | Failure is staying down (Marillion)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads