dBASE Questions and Answers - Using ExportData.wfm

Author

Using ExportData.wfm

Bosco Wilson

2006-02-09, 11:24 am

I have tried for days to use this program, and have yet to get any results.
In the code it tells you how to use the program, but I am a bit lost. The
usage code is:

set proc to ExportData.wfm additive
fExport = new ExportDataForm()
fExport.oQuery = <query>
fExport.Open()

Can someone please explain to me what line 3 is asking for? I have tried
multiple things that have not worked. I tried creating a .sql in the
designer and passing it as the <query> but it did not like that. I then
tried passing a "SELECT ....." statement, it didn't like that. I have tried
it with parenthesis, tried with no parenthesis, and am just plain lost now.
When the program runs it says that I have not passed a query object.
Thanks for anyone pointing me in the right direction.

Thank you.

Bosco

Ivar B. Jessen

2006-02-09, 1:24 pm

On Thu, 9 Feb 2006 11:29:46 -0500, in dbase.how-to,
Subject: Using ExportData.wfm,
Message-ID: <7K9qOcZLGHA.1148@news-server>,
"Bosco Wilson" <bosco@wilserv.net> wrote:

>I have tried for days to use this program, and have yet to get any results.
>In the code it tells you how to use the program, but I am a bit lost. The
>usage code is:
>
>set proc to ExportData.wfm additive
> fExport = new ExportDataForm()
> fExport.oQuery = <query>
> fExport.Open()
>
>Can someone please explain to me what line 3 is asking for? I have tried
>multiple things that have not worked. I tried creating a .sql in the
>designer and passing it as the <query> but it did not like that. I then
>tried passing a "SELECT ....." statement, it didn't like that. I have tried
>it with parenthesis, tried with no parenthesis, and am just plain lost now.
>When the program runs it says that I have not passed a query object.
>Thanks for anyone pointing me in the right direction.

Try the code below my signature.

Ivar B. Jessen

//-----
d = new database()
d.databasename = "dbasesamples"
d.active = true

q = new query()
q.database = d
q.sql = 'select ID, Name, Species from Fish where ID > 5'
q.active = true

set proc to :duflp:exportdata.wfm additive
fExport = new exportdataForm()
fExport.oQuery = q
fExport.open()
//-----

Ken Mayer [dBVIPS]

2006-02-09, 1:24 pm

Bosco Wilson wrote:
> I have tried for days to use this program, and have yet to get any results.
> In the code it tells you how to use the program, but I am a bit lost. The
> usage code is:
>
> set proc to ExportData.wfm additive
> fExport = new ExportDataForm()
> fExport.oQuery = <query>
> fExport.Open()
>
> Can someone please explain to me what line 3 is asking for? I have tried
> multiple things that have not worked. I tried creating a .sql in the

Line three is expecting a query object reference, such as:

qMyTable = new query()
qMyTable.sql := "select * from MyTable"
qMyTable.active := true

Then in the code above, substitute <query> with qMyTable.

Ken

--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/

*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Bosco Wilson

2006-02-09, 1:24 pm

Hey thanks a lot guys! My problem is that I was not creating a = new
query().

Thanks again.

Bosco

"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:N4s20naLGHA.592@news-server...
> Bosco Wilson wrote:
>
> Line three is expecting a query object reference, such as:
>
> qMyTable = new query()
> qMyTable.sql := "select * from MyTable"
> qMyTable.active := true
>
> Then in the code above, substitute <query> with qMyTable.
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/dbase/dBASEBook.htm
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase

Sponsored Links