Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Manisha Sathe
  Where is Manisha Sathe?
 
 Singapore
 Manisha Sathe
 Tags
Subject: RE: Grid with SQL Statement ?
Thread ID: 33405 Message ID: 33601 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Forms
Date: Sunday, November 30, 2003 12:27:48 AM         
   


Then you need to:
include two (or more) fields in the SQL statement,
set combo.columncount=2 somewhere in the combo.properties or in the code of appropriate event, and
set the initial combo.value to sqlresult_cursor_name.cust_no.

> Thanks, it works, but one more small query
>
> suppose i want to display cust no + cust desc both in combo box but want only cust no as a return value then how shall i modify it ?
>
> manisha


ENTIRE THREAD

Grid with SQL Statement ? Posted by Manisha Sathe @ 11/26/2003 10:40:14 AM
RE: Grid with SQL Statement ? Posted by Yuri Rubinov @ 11/26/2003 4:59:02 PM
RE: Grid with SQL Statement ? Posted by Manisha Sathe @ 11/28/2003 12:36:46 PM
RE: Grid with SQL Statement ? Posted by Jez Enefer-Mills @ 11/28/2003 12:55:53 PM
RE: Grid with SQL Statement ? Posted by Manisha Sathe @ 11/29/2003 7:39:47 AM
RE: Grid with SQL Statement ? Posted by Yuri Rubinov @ 11/30/2003 12:27:48 AM
Thanks Posted by Manisha Sathe @ 11/30/2003 7:04:40 AM