Is it possible to draw a table in vfp8?

Hi All,

I think this question sounds stupid!

Anyway, here it goes...

Is it possible to draw a table with rows and colums like in MS Word? I did
think of using a grid. But, I won't be populating the grid with multiple
record from a table/s. The contents to be displayed on the table would be a
result of a join of several tables which fetches exactly, one entity's data
from all the tables in the database. But I would be displaying the whole lot
of information in a several rows and columns.

Can anybody suggest me how to do this?

Thanks.

tom
Mon Feb 07 02:30:59 CST 2005

Hi,

If i understand you correctly, I would gather the result into a cursor and
use office automation to transfer the data into an excelsheet.
If the appearance always looks the same , insert it into an existing sheet.
If not : format the sheet.

HTH
Tom


"kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> Hi All,
>
> I think this question sounds stupid!
>
> Anyway, here it goes...
>
> Is it possible to draw a table with rows and colums like in MS Word? I did
> think of using a grid. But, I won't be populating the grid with multiple
> record from a table/s. The contents to be displayed on the table would be
a
> result of a join of several tables which fetches exactly, one entity's
data
> from all the tables in the database. But I would be displaying the whole
lot
> of information in a several rows and columns.
>
> Can anybody suggest me how to do this?
>
> Thanks.

kd
Mon Feb 07 02:55:02 CST 2005

Hello Tom,

I think you got me wrong!

The table that I mentioned would be on a foxprop form. I require the table
only to display details in rows on columns in a foxpro application without
using a grid.

Thanks.

"tom knauf" wrote:

> Hi,
>
> If i understand you correctly, I would gather the result into a cursor and
> use office automation to transfer the data into an excelsheet.
> If the appearance always looks the same , insert it into an existing sheet.
> If not : format the sheet.
>
> HTH
> Tom
>
>
> "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> > Hi All,
> >
> > I think this question sounds stupid!
> >
> > Anyway, here it goes...
> >
> > Is it possible to draw a table with rows and colums like in MS Word? I did
> > think of using a grid. But, I won't be populating the grid with multiple
> > record from a table/s. The contents to be displayed on the table would be
> a
> > result of a join of several tables which fetches exactly, one entity's
> data
> > from all the tables in the database. But I would be displaying the whole
> lot
> > of information in a several rows and columns.
> >
> > Can anybody suggest me how to do this?
> >
> > Thanks.
>
>
>

tom
Mon Feb 07 08:55:34 CST 2005

Hi,

mhh,

I thought of generating a cursor where each row/column reflects the values
you want (sums, join,..), then you may use a grid on that cursor (not on the
origin tables). We do so for presenting something like a "report in a form"
with some of our apps. The grid has an underlying cursor reflecting sums,
variance, user remarks, ... of multiple tables.

2. Maybe you can put the resulting ms-excelsheet (see below) as object (ole)
on the form.

3. Otherwise you could setup the form with manual calls of addobj(textbox)
with the size and values you need. I think that maybe a very boring job to
do.

HTH
Tom



"kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
> Hello Tom,
>
> I think you got me wrong!
>
> The table that I mentioned would be on a foxprop form. I require the table
> only to display details in rows on columns in a foxpro application without
> using a grid.
>
> Thanks.
>
> "tom knauf" wrote:
>
> > Hi,
> >
> > If i understand you correctly, I would gather the result into a cursor
and
> > use office automation to transfer the data into an excelsheet.
> > If the appearance always looks the same , insert it into an existing
sheet.
> > If not : format the sheet.
> >
> > HTH
> > Tom
> >
> >
> > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> > > Hi All,
> > >
> > > I think this question sounds stupid!
> > >
> > > Anyway, here it goes...
> > >
> > > Is it possible to draw a table with rows and colums like in MS Word? I
did
> > > think of using a grid. But, I won't be populating the grid with
multiple
> > > record from a table/s. The contents to be displayed on the table would
be
> > a
> > > result of a join of several tables which fetches exactly, one entity's
> > data
> > > from all the tables in the database. But I would be displaying the
whole
> > lot
> > > of information in a several rows and columns.
> > >
> > > Can anybody suggest me how to do this?
> > >
> > > Thanks.
> >
> >
> >

Jan
Mon Feb 07 16:25:14 CST 2005

Tom,

With regard to your third option, remember however boring it might be to the
programmer, it is the result and on going benefit to the end user that
matters.

Rgds
Jan

"tom knauf" <tom.knauf@itds.de> wrote in message
news:cu7vh7$llc$05$1@news.t-online.com...
> Hi,
>
> mhh,
>
> I thought of generating a cursor where each row/column reflects the values
> you want (sums, join,..), then you may use a grid on that cursor (not on
> the
> origin tables). We do so for presenting something like a "report in a
> form"
> with some of our apps. The grid has an underlying cursor reflecting sums,
> variance, user remarks, ... of multiple tables.
>
> 2. Maybe you can put the resulting ms-excelsheet (see below) as object
> (ole)
> on the form.
>
> 3. Otherwise you could setup the form with manual calls of addobj(textbox)
> with the size and values you need. I think that maybe a very boring job to
> do.
>
> HTH
> Tom
>
>
>
> "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
>> Hello Tom,
>>
>> I think you got me wrong!
>>
>> The table that I mentioned would be on a foxprop form. I require the
>> table
>> only to display details in rows on columns in a foxpro application
>> without
>> using a grid.
>>
>> Thanks.
>>
>> "tom knauf" wrote:
>>
>> > Hi,
>> >
>> > If i understand you correctly, I would gather the result into a cursor
> and
>> > use office automation to transfer the data into an excelsheet.
>> > If the appearance always looks the same , insert it into an existing
> sheet.
>> > If not : format the sheet.
>> >
>> > HTH
>> > Tom
>> >
>> >
>> > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
>> > news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
>> > > Hi All,
>> > >
>> > > I think this question sounds stupid!
>> > >
>> > > Anyway, here it goes...
>> > >
>> > > Is it possible to draw a table with rows and colums like in MS Word?
>> > > I
> did
>> > > think of using a grid. But, I won't be populating the grid with
> multiple
>> > > record from a table/s. The contents to be displayed on the table
>> > > would
> be
>> > a
>> > > result of a join of several tables which fetches exactly, one
>> > > entity's
>> > data
>> > > from all the tables in the database. But I would be displaying the
> whole
>> > lot
>> > > of information in a several rows and columns.
>> > >
>> > > Can anybody suggest me how to do this?
>> > >
>> > > Thanks.
>> >
>> >
>> >
>
>

kd
Mon Feb 07 23:55:04 CST 2005

Hi Tom,

Thanks for your response.

In my case, though I have a join on several tables, the result would always
be one record. Since it is a join of several tables the data fetched from the
database is large enough to be displayed in several rows. The rows of the
table does not represent the rows the cursor. The cursor has just one row. I
hope I am successful in making the scenario clear this time.

I have used lines to create rows and columns on the form. Would like to know
if there is something like a table like the one MS word provides, in vfp8
which can be used as is by specifying the number of rows and columns, instead
of having to literally create rows and columns using lines.

Regards.
kd

"tom knauf" wrote:

> Hi,
>
> mhh,
>
> I thought of generating a cursor where each row/column reflects the values
> you want (sums, join,..), then you may use a grid on that cursor (not on the
> origin tables). We do so for presenting something like a "report in a form"
> with some of our apps. The grid has an underlying cursor reflecting sums,
> variance, user remarks, ... of multiple tables.
>
> 2. Maybe you can put the resulting ms-excelsheet (see below) as object (ole)
> on the form.
>
> 3. Otherwise you could setup the form with manual calls of addobj(textbox)
> with the size and values you need. I think that maybe a very boring job to
> do.
>
> HTH
> Tom
>
>
>
> "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
> > Hello Tom,
> >
> > I think you got me wrong!
> >
> > The table that I mentioned would be on a foxprop form. I require the table
> > only to display details in rows on columns in a foxpro application without
> > using a grid.
> >
> > Thanks.
> >
> > "tom knauf" wrote:
> >
> > > Hi,
> > >
> > > If i understand you correctly, I would gather the result into a cursor
> and
> > > use office automation to transfer the data into an excelsheet.
> > > If the appearance always looks the same , insert it into an existing
> sheet.
> > > If not : format the sheet.
> > >
> > > HTH
> > > Tom
> > >
> > >
> > > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > > news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> > > > Hi All,
> > > >
> > > > I think this question sounds stupid!
> > > >
> > > > Anyway, here it goes...
> > > >
> > > > Is it possible to draw a table with rows and colums like in MS Word? I
> did
> > > > think of using a grid. But, I won't be populating the grid with
> multiple
> > > > record from a table/s. The contents to be displayed on the table would
> be
> > > a
> > > > result of a join of several tables which fetches exactly, one entity's
> > > data
> > > > from all the tables in the database. But I would be displaying the
> whole
> > > lot
> > > > of information in a several rows and columns.
> > > >
> > > > Can anybody suggest me how to do this?
> > > >
> > > > Thanks.
> > >
> > >
> > >
>
>
>

David
Tue Feb 08 09:52:08 CST 2005

kd,

I'd use a webbrowser ActiveX instance on your form and render your cursor
into an HTML <TABLE> however you need to build the cells. You can look at
the genhtml.prg for some example code. But it's going to just put each
row/column of your cursor into a single cell. But you can put several
columns into a single cell with your own code:

set textmerge to temp.html
set textmerge on noshow

\\<html><body>
\<table>

scan
\<tr>
\\<td>Item1 <<column1>><br>
\\Item 2 <<column2>
\\</td>
\\<tr>
endscan

\</table>
\</body></html>

set textmerge off
set textmerge to



"kd" <kd@discussions.microsoft.com> wrote in message
news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> Hi All,
>
> I think this question sounds stupid!
>
> Anyway, here it goes...
>
> Is it possible to draw a table with rows and colums like in MS Word? I did
> think of using a grid. But, I won't be populating the grid with multiple
> record from a table/s. The contents to be displayed on the table would be
> a
> result of a join of several tables which fetches exactly, one entity's
> data
> from all the tables in the database. But I would be displaying the whole
> lot
> of information in a several rows and columns.
>
> Can anybody suggest me how to do this?
>
> Thanks.

Anders
Tue Feb 08 09:16:06 CST 2005

A bunch of textboxes in a container.
-Anders

"kd" <kd@discussions.microsoft.com> wrote in message
news:5A63F7C6-A8C1-4F9A-950C-8B75BD1EA6E1@microsoft.com...
> Hi Tom,
>
> Thanks for your response.
>
> In my case, though I have a join on several tables, the result would
always
> be one record. Since it is a join of several tables the data fetched from
the
> database is large enough to be displayed in several rows. The rows of the
> table does not represent the rows the cursor. The cursor has just one row.
I
> hope I am successful in making the scenario clear this time.
>
> I have used lines to create rows and columns on the form. Would like to
know
> if there is something like a table like the one MS word provides, in vfp8
> which can be used as is by specifying the number of rows and columns,
instead
> of having to literally create rows and columns using lines.
>
> Regards.
> kd
>
> "tom knauf" wrote:
>
> > Hi,
> >
> > mhh,
> >
> > I thought of generating a cursor where each row/column reflects the
values
> > you want (sums, join,..), then you may use a grid on that cursor (not on
the
> > origin tables). We do so for presenting something like a "report in a
form"
> > with some of our apps. The grid has an underlying cursor reflecting
sums,
> > variance, user remarks, ... of multiple tables.
> >
> > 2. Maybe you can put the resulting ms-excelsheet (see below) as object
(ole)
> > on the form.
> >
> > 3. Otherwise you could setup the form with manual calls of
addobj(textbox)
> > with the size and values you need. I think that maybe a very boring job
to
> > do.
> >
> > HTH
> > Tom
> >
> >
> >
> > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
> > > Hello Tom,
> > >
> > > I think you got me wrong!
> > >
> > > The table that I mentioned would be on a foxprop form. I require the
table
> > > only to display details in rows on columns in a foxpro application
without
> > > using a grid.
> > >
> > > Thanks.
> > >
> > > "tom knauf" wrote:
> > >
> > > > Hi,
> > > >
> > > > If i understand you correctly, I would gather the result into a
cursor
> > and
> > > > use office automation to transfer the data into an excelsheet.
> > > > If the appearance always looks the same , insert it into an
existing
> > sheet.
> > > > If not : format the sheet.
> > > >
> > > > HTH
> > > > Tom
> > > >
> > > >
> > > > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > > > news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> > > > > Hi All,
> > > > >
> > > > > I think this question sounds stupid!
> > > > >
> > > > > Anyway, here it goes...
> > > > >
> > > > > Is it possible to draw a table with rows and colums like in MS
Word? I
> > did
> > > > > think of using a grid. But, I won't be populating the grid with
> > multiple
> > > > > record from a table/s. The contents to be displayed on the table
would
> > be
> > > > a
> > > > > result of a join of several tables which fetches exactly, one
entity's
> > > > data
> > > > > from all the tables in the database. But I would be displaying the
> > whole
> > > > lot
> > > > > of information in a several rows and columns.
> > > > >
> > > > > Can anybody suggest me how to do this?
> > > > >
> > > > > Thanks.
> > > >
> > > >
> > > >
> >
> >
> >

Paul
Tue Feb 08 16:27:23 CST 2005

Put your result set in a cursor, then use a grid.

Or just use a bunch of textboxes.


"kd" <kd@discussions.microsoft.com> wrote in message
news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> Hi All,
>
> I think this question sounds stupid!
>
> Anyway, here it goes...
>
> Is it possible to draw a table with rows and colums like in MS Word? I did
> think of using a grid. But, I won't be populating the grid with multiple
> record from a table/s. The contents to be displayed on the table would be
> a
> result of a join of several tables which fetches exactly, one entity's
> data
> from all the tables in the database. But I would be displaying the whole
> lot
> of information in a several rows and columns.
>
> Can anybody suggest me how to do this?
>
> Thanks.

KL
Thu Feb 10 11:54:23 CST 2005

I had to do something similar in an early report many years ago. Here's
one easy way of doing it:

Sum all your records into an array, which will have one row and x number
of columns

Create a loop and parse through the array, writing the results of the
single row array into a multirow array or cursor, then display the
results in a listbox with lines, or in a grid. If the data is for
viewing only, turn off the scroll bars and make it readonly.

This may sound cludgy, but it works great and is very fast. It keeps
you from having to worry about drawing lines, etc.

kd wrote:
> Hi Tom,
>
> Thanks for your response.
>
> In my case, though I have a join on several tables, the result would always
> be one record. Since it is a join of several tables the data fetched from the
> database is large enough to be displayed in several rows. The rows of the
> table does not represent the rows the cursor. The cursor has just one row. I
> hope I am successful in making the scenario clear this time.
>
> I have used lines to create rows and columns on the form. Would like to know
> if there is something like a table like the one MS word provides, in vfp8
> which can be used as is by specifying the number of rows and columns, instead
> of having to literally create rows and columns using lines.
>
> Regards.
> kd
>
> "tom knauf" wrote:
>
>
>>Hi,
>>
>>mhh,
>>
>>I thought of generating a cursor where each row/column reflects the values
>>you want (sums, join,..), then you may use a grid on that cursor (not on the
>>origin tables). We do so for presenting something like a "report in a form"
>>with some of our apps. The grid has an underlying cursor reflecting sums,
>>variance, user remarks, ... of multiple tables.
>>
>>2. Maybe you can put the resulting ms-excelsheet (see below) as object (ole)
>>on the form.
>>
>>3. Otherwise you could setup the form with manual calls of addobj(textbox)
>>with the size and values you need. I think that maybe a very boring job to
>>do.
>>
>>HTH
>>Tom
>>
>>
>>
>>"kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
>>news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
>>
>>>Hello Tom,
>>>
>>>I think you got me wrong!
>>>
>>>The table that I mentioned would be on a foxprop form. I require the table
>>>only to display details in rows on columns in a foxpro application without
>>>using a grid.
>>>
>>>Thanks.
>>>
>>>"tom knauf" wrote:
>>>
>>>
>>>>Hi,
>>>>
>>>>If i understand you correctly, I would gather the result into a cursor
>>
>>and
>>
>>>>use office automation to transfer the data into an excelsheet.
>>>>If the appearance always looks the same , insert it into an existing
>>
>>sheet.
>>
>>>>If not : format the sheet.
>>>>
>>>>HTH
>>>>Tom
>>>>
>>>>
>>>>"kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
>>>>news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
>>>>
>>>>>Hi All,
>>>>>
>>>>>I think this question sounds stupid!
>>>>>
>>>>>Anyway, here it goes...
>>>>>
>>>>>Is it possible to draw a table with rows and colums like in MS Word? I
>>
>>did
>>
>>>>>think of using a grid. But, I won't be populating the grid with
>>
>>multiple
>>
>>>>>record from a table/s. The contents to be displayed on the table would
>>
>>be
>>
>>>>a
>>>>
>>>>>result of a join of several tables which fetches exactly, one entity's
>>>>
>>>>data
>>>>
>>>>>from all the tables in the database. But I would be displaying the
>>
>>whole
>>
>>>>lot
>>>>
>>>>>of information in a several rows and columns.
>>>>>
>>>>>Can anybody suggest me how to do this?
>>>>>
>>>>>Thanks.
>>>>
>>>>
>>>>
>>
>>

KL
Thu Feb 10 12:01:33 CST 2005

One other suggestion:

When parsing your values into a multirow array (or cursor) you can also
populate the row above a set of values with the "Title" of the value.
Then, when displaying the grid, you can change the backcolor of every
other row, so the the Titles above each value will be highlighted. This
can make the grid much easier to read and makes the values easier to
read as well.

KL wrote:

> I had to do something similar in an early report many years ago. Here's
> one easy way of doing it:
>
> Sum all your records into an array, which will have one row and x number
> of columns
>
> Create a loop and parse through the array, writing the results of the
> single row array into a multirow array or cursor, then display the
> results in a listbox with lines, or in a grid. If the data is for
> viewing only, turn off the scroll bars and make it readonly.
>
> This may sound cludgy, but it works great and is very fast. It keeps
> you from having to worry about drawing lines, etc.
>
> kd wrote:
>
>> Hi Tom,
>>
>> Thanks for your response.
>>
>> In my case, though I have a join on several tables, the result would
>> always be one record. Since it is a join of several tables the data
>> fetched from the database is large enough to be displayed in several
>> rows. The rows of the table does not represent the rows the cursor.
>> The cursor has just one row. I hope I am successful in making the
>> scenario clear this time.
>>
>> I have used lines to create rows and columns on the form. Would like
>> to know if there is something like a table like the one MS word
>> provides, in vfp8 which can be used as is by specifying the number of
>> rows and columns, instead of having to literally create rows and
>> columns using lines.
>>
>> Regards.
>> kd
>>
>> "tom knauf" wrote:
>>
>>
>>> Hi,
>>>
>>> mhh,
>>>
>>> I thought of generating a cursor where each row/column reflects the
>>> values
>>> you want (sums, join,..), then you may use a grid on that cursor (not
>>> on the
>>> origin tables). We do so for presenting something like a "report in a
>>> form"
>>> with some of our apps. The grid has an underlying cursor reflecting
>>> sums,
>>> variance, user remarks, ... of multiple tables.
>>>
>>> 2. Maybe you can put the resulting ms-excelsheet (see below) as
>>> object (ole)
>>> on the form.
>>>
>>> 3. Otherwise you could setup the form with manual calls of
>>> addobj(textbox)
>>> with the size and values you need. I think that maybe a very boring
>>> job to
>>> do.
>>>
>>> HTH
>>> Tom
>>>
>>>
>>>
>>> "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
>>> news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
>>>
>>>> Hello Tom,
>>>>
>>>> I think you got me wrong!
>>>>
>>>> The table that I mentioned would be on a foxprop form. I require the
>>>> table
>>>> only to display details in rows on columns in a foxpro application
>>>> without
>>>> using a grid.
>>>>
>>>> Thanks.
>>>>
>>>> "tom knauf" wrote:
>>>>
>>>>
>>>>> Hi,
>>>>>
>>>>> If i understand you correctly, I would gather the result into a cursor
>>>
>>>
>>> and
>>>
>>>>> use office automation to transfer the data into an excelsheet.
>>>>> If the appearance always looks the same , insert it into an existing
>>>
>>>
>>> sheet.
>>>
>>>>> If not : format the sheet.
>>>>>
>>>>> HTH
>>>>> Tom
>>>>>
>>>>>
>>>>> "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
>>>>> news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
>>>>>
>>>>>> Hi All,
>>>>>>
>>>>>> I think this question sounds stupid!
>>>>>>
>>>>>> Anyway, here it goes...
>>>>>>
>>>>>> Is it possible to draw a table with rows and colums like in MS
>>>>>> Word? I
>>>
>>>
>>> did
>>>
>>>>>> think of using a grid. But, I won't be populating the grid with
>>>
>>>
>>> multiple
>>>
>>>>>> record from a table/s. The contents to be displayed on the table
>>>>>> would
>>>
>>>
>>> be
>>>
>>>>> a
>>>>>
>>>>>> result of a join of several tables which fetches exactly, one
>>>>>> entity's
>>>>>
>>>>>
>>>>> data
>>>>>
>>>>>> from all the tables in the database. But I would be displaying the
>>>
>>>
>>> whole
>>>
>>>>> lot
>>>>>
>>>>>> of information in a several rows and columns.
>>>>>>
>>>>>> Can anybody suggest me how to do this?
>>>>>>
>>>>>> Thanks.
>>>>>
>>>>>
>>>>>
>>>>>
>>>
>>>

tom
Fri Feb 11 02:22:04 CST 2005

Hi kd,

may be you misunderstand me :

Join and sum your data which "normally" would result in one record.
But do not create a cursor with one record and as many rows as you have
data.
Create a cursor with for example 5 columns and 4 rows (if you have 20
values) or 20 columns and 40 rows for 800 values,...
So every LINE of the presentation grid is one RECORD in the cursor. You may
even write "fake headers" into your cursor to make the lines better
readable.
Thats the way we did it. The advantage is, that by creating different
cursors and maybe manipulating the grid programmatically we can setup
totally different presentations. Of course, grid is readonly and has no
scrollbars.

HTH
Tom


"kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
news:5A63F7C6-A8C1-4F9A-950C-8B75BD1EA6E1@microsoft.com...
> Hi Tom,
>
> Thanks for your response.
>
> In my case, though I have a join on several tables, the result would
always
> be one record. Since it is a join of several tables the data fetched from
the
> database is large enough to be displayed in several rows. The rows of the
> table does not represent the rows the cursor. The cursor has just one row.
I
> hope I am successful in making the scenario clear this time.
>
> I have used lines to create rows and columns on the form. Would like to
know
> if there is something like a table like the one MS word provides, in vfp8
> which can be used as is by specifying the number of rows and columns,
instead
> of having to literally create rows and columns using lines.
>
> Regards.
> kd
>
> "tom knauf" wrote:
>
> > Hi,
> >
> > mhh,
> >
> > I thought of generating a cursor where each row/column reflects the
values
> > you want (sums, join,..), then you may use a grid on that cursor (not on
the
> > origin tables). We do so for presenting something like a "report in a
form"
> > with some of our apps. The grid has an underlying cursor reflecting
sums,
> > variance, user remarks, ... of multiple tables.
> >
> > 2. Maybe you can put the resulting ms-excelsheet (see below) as object
(ole)
> > on the form.
> >
> > 3. Otherwise you could setup the form with manual calls of
addobj(textbox)
> > with the size and values you need. I think that maybe a very boring job
to
> > do.
> >
> > HTH
> > Tom
> >
> >
> >
> > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > news:A0273314-8D47-4061-8D7B-9C654D30332E@microsoft.com...
> > > Hello Tom,
> > >
> > > I think you got me wrong!
> > >
> > > The table that I mentioned would be on a foxprop form. I require the
table
> > > only to display details in rows on columns in a foxpro application
without
> > > using a grid.
> > >
> > > Thanks.
> > >
> > > "tom knauf" wrote:
> > >
> > > > Hi,
> > > >
> > > > If i understand you correctly, I would gather the result into a
cursor
> > and
> > > > use office automation to transfer the data into an excelsheet.
> > > > If the appearance always looks the same , insert it into an
existing
> > sheet.
> > > > If not : format the sheet.
> > > >
> > > > HTH
> > > > Tom
> > > >
> > > >
> > > > "kd" <kd@discussions.microsoft.com> schrieb im Newsbeitrag
> > > > news:9DC2B72F-67ED-4EC8-B3B1-69E56F4CDBAA@microsoft.com...
> > > > > Hi All,
> > > > >
> > > > > I think this question sounds stupid!
> > > > >
> > > > > Anyway, here it goes...
> > > > >
> > > > > Is it possible to draw a table with rows and colums like in MS
Word? I
> > did
> > > > > think of using a grid. But, I won't be populating the grid with
> > multiple
> > > > > record from a table/s. The contents to be displayed on the table
would
> > be
> > > > a
> > > > > result of a join of several tables which fetches exactly, one
entity's
> > > > data
> > > > > from all the tables in the database. But I would be displaying the
> > whole
> > > > lot
> > > > > of information in a several rows and columns.
> > > > >
> > > > > Can anybody suggest me how to do this?
> > > > >
> > > > > Thanks.
> > > >
> > > >
> > > >
> >
> >
> >