Seek VFP programmer.

[rod]

Seek programmer to write a run time program
for a large database
Is this a suitable group?
Private enquiry
Perth
Western Australia

[Olaf Doschke]

Hi rod,

you might give a little more detail.

I'd also try
m.p.fox.programmer.exchange
but vfp programmers will read many
newsgroups of m.p.fox anyway.

You should try
Universal Thread www.universalthread.com,
Foxite www.foxite.com
too.

Bye, Olaf.

[rod]

Thanks Olaf, very much.
FYI I wouldn't know what detail to give,
I drive the car, am not the mechanic :)
We have a large VFP database and need a run time program
to extract fields of choice to DBF subset.
That's about the best I can do without being queried.
I'll check your links.
Happy New Year Rod.

Post by Olaf Doschke
Hi rod,
you might give a little more detail.
I'd also try m.p.fox.programmer.exchange
but vfp programmers will read many
newsgroups of m.p.fox anyway.
You should try Universal Thread www.universalthread.com, Foxite
www.foxite.com
too.
Bye, Olaf.

[Olaf Doschke]

Hi rod,

Post by rod
FYI I wouldn't know what detail to give,
I drive the car, am not the mechanic :)
We have a large VFP database and need a run time program
to extract fields of choice to DBF subset.

That is a detail, ok.

A potential programmer would want to know first,
what budget is there regarding time and money.
Monstly that is ASAP and for free...<g>

To extract fields from a database to a table
all you need is SQL-Select INTO TABLE.

That would be pretty easy to do. And perhaps
the cheapest would be to use vfp itself for it.
I'm sure the real world problem is a bit more
special than that, isn't it?

Bye, Olaf.

[rod]

G'day Olaf,

Post by Olaf Doschke
That would be pretty easy to do. And perhaps
the cheapest would be to use vfp itself for it.
I'm sure the real world problem is a bit more
special than that, isn't it?

This situation is rather surreal at times :), we are just a couple of
guys "working in the backyard shed" as it were, we have a
5 million record database we use for our hobby. It is a proprietory
program, so we initially felt bound by loyalty to approach the vendor
for the solution, but that seems to have been ignored.

OK. so we have a VFP db, and we have a run time program
that extracts a DBF sub set of approx 80 fields, fine, however
the program only runs from a linked trigger set that gives us
a defined sub set (date wise of approx 7 days). Not good for what we seek.

We just want (as you suggested) vfp to give us a sub set
in field position mirrored by the other run time program,
and bracketed by our date parameters, in other words
a sub set in field order but say 2 years ago over 30 days.

Now we place an seek advert, and some of the replies are intimidating
and embarrasing? as the respondents are so very highly qualified it's
frightening,
I would suggest we would be prepared to pay upwards to $1000
and patience is a given, we have waited a year already.
but we have no benchmarks as to where we stand.
We cannot just call someone in off the yellow pages for a quote :)
we are completely in the dark.

The maddening thing is our vfp program has query sets, but no matter
what matrix we could employ there, it would not cover the 80 fields
we need. Grrr :)
I hope that goes some way towards our perplexed position.

Very best regards.
Rod.

[Olaf Doschke]

hi rod,

Post by rod
Now we place an seek advert, and some of the replies are intimidating
and embarrasing? as the respondents are so very highly qualified it's
frightening,

Sorry if my response was in that range. Individual software
costs much more for less functionallity than any standard
software where development time costs are split by an ideally
large number of customers.

Post by rod
we have a
5 million record database we use for our hobby. It is a proprietory
program, so we initially felt bound by loyalty to approach the vendor
for the solution, but that seems to have been ignored.
OK. so we have a VFP db, and we have a run time program
that extracts a DBF sub set of approx 80 fields, fine, however
the program only runs from a linked trigger set that gives us
a defined sub set (date wise of approx 7 days). Not good for what we seek.
I would suggest we would be prepared to pay upwards to $1000
and patience is a given, we have waited a year already.

Then I'd recommend you buy vfp9 and have some money
left. It will allow you to browse through the data and extract
any portions you like plus much much more. For your needs it seems
you could do with asking your way to reach your goal here for
free. It's jsut some SQL needed to exract data into new tables.

For example, if you have vfp, you can use a program called
gendbc to extract the structure of the database, although you
already seem to know what fields there are and you need in
the data extract.

You can even get along by just downloading the vfp ole db
provider and can then extract data with VB for Applications,
for example from MS Access or MS Excel. Or even with
php.

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en

As long as your dbc and/or dbfs are not encrypted you can
get at the data that way.

Setup of vfp oledb provider also installs a chm help file which
shows how to work from several MS languages as VB.NET
or VBA.

Bye, Olaf.

[rod]

Post by Olaf Doschke
hi rod,

Post by rod
Now we place an seek advert, and some of the replies are intimidating
and embarrasing? as the respondents are so very highly qualified it's
frightening,

Sorry if my response was in that range. Individual software
costs much more for less functionallity than any standard
software where development time costs are split by an ideally
large number of customers.

Post by rod
we have a
5 million record database we use for our hobby. It is a proprietory
program, so we initially felt bound by loyalty to approach the vendor
for the solution, but that seems to have been ignored.
OK. so we have a VFP db, and we have a run time program
that extracts a DBF sub set of approx 80 fields, fine, however
the program only runs from a linked trigger set that gives us
a defined sub set (date wise of approx 7 days). Not good for what we seek.
I would suggest we would be prepared to pay upwards to $1000
and patience is a given, we have waited a year already.

Then I'd recommend you buy vfp9 and have some money
left. It will allow you to browse through the data and extract
any portions you like plus much much more. For your needs it seems
you could do with asking your way to reach your goal here for
free. It's jsut some SQL needed to exract data into new tables.
For example, if you have vfp, you can use a program called
gendbc to extract the structure of the database, although you
already seem to know what fields there are and you need in
the data extract.
You can even get along by just downloading the vfp ole db
provider and can then extract data with VB for Applications,
for example from MS Access or MS Excel. Or even with
php.
http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en
As long as your dbc and/or dbfs are not encrypted you can
get at the data that way.
Setup of vfp oledb provider also installs a chm help file which
shows how to work from several MS languages as VB.NET
or VBA.
Bye, Olaf.

[rod]

Thanks Olaf, you have been very helpful.
the more advice we get, the more intriguing the scenario,
you guys are by nature canny, and it seems the db we have has been split in
two, we have two major locations for structures on C drive.

I like your two last suggestions and will take this when/if we can get
someone
to look at our structure locally.

We just want our sub sets in dbf format, access/excel does not offer what
we need in flat file format for data inspection.

Post by Olaf Doschke
You can even get along by just downloading the vfp ole db
provider and can then extract data with VB for Applications,
for example from MS Access or MS Excel. Or even with
php.
http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en
As long as your dbc and/or dbfs are not encrypted you can
get at the data that way.
Setup of vfp oledb provider also installs a chm help file which
shows how to work from several MS languages as VB.NET
or VBA.
Bye, Olaf.

[Olaf Doschke]

Post by rod
We just want our sub sets in dbf format, access/excel does not offer what
we need in flat file format for data inspection.

okay. So how do you process the dbf files you would get,
if you don't have foxpro?

What kind of dbfs would you want? Eg Excel can only open
old fp 2.6 dbf formats.

You could also export to other formats, eg text formats,
comma or tab delimited would be quite universal, as long as no
memo fields (eg with multiline texts) are involved.

With foxpro you could also upsize data to an ms sql server.

Bye, Olaf.

[rod]

G'day Olaf,
Boy! what a week.
I hope the time you have spent is manifestly less than the egg on my face :(
apart from what we were told, a friend off list has offered
snipped
Ah - based on the file list you've sent to me:
1. this is a FoxPro for Dos v2.5 (FPD) system -
2. I don't touch FPD systems any more except to rewrite in VFP v9, and
thats only for a rewrite.
3. if yer data is not encrypted, I suggest you use dbf Viewer 2000 to
read it and extract - see http://dbf2002.com .

So Olaf, we offer our sincere apologies.

Post by Olaf Doschke
okay. So how do you process the dbf files you would get,
if you don't have foxpro?

we prefer a small flatfile database 256 fields and 32,000 records.
Regards.
Rod.

[Olaf Doschke]

You'd better get someone with FPD
experience then. I'm out of that, too.

Bye, Olaf.

[Anders Altberg]

Check out DBFViewer, the FoxFire Query Tool and and Report Writer, and
Stonefield Query.

-Anders

Post by rod
G'day Olaf,
Boy! what a week.
I hope the time you have spent is manifestly less than the egg on my face :(
apart from what we were told, a friend off list has offered
snipped
1. this is a FoxPro for Dos v2.5 (FPD) system -
2. I don't touch FPD systems any more except to rewrite in VFP v9, and
thats only for a rewrite.
3. if yer data is not encrypted, I suggest you use dbf Viewer 2000 to
read it and extract - see http://dbf2002.com .
So Olaf, we offer our sincere apologies.

Post by Olaf Doschke
okay. So how do you process the dbf files you would get,
if you don't have foxpro?

we prefer a small flatfile database 256 fields and 32,000 records.
Regards.
Rod.

[rod]

Thanks Olaf, very much.
FYI I wouldn't know what detail to give,
I drive the car, am not the mechanic :)
We have a large VFP database and need a run time program
to extract fields of choice to DBF subset.
That's about the best I can do without being queried.
I'll check your links.
Happy New Year Rod.

Post by Olaf Doschke
Hi rod,
you might give a little more detail.
I'd also try m.p.fox.programmer.exchange
but vfp programmers will read many
newsgroups of m.p.fox anyway.
You should try Universal Thread www.universalthread.com, Foxite
www.foxite.com
too.
Bye, Olaf.

[Alan Pengelly]

Rod,

*Date:* Thu, 27 Dec 2007 19:58:36 +0900
Seek programmer to write a run time program
for a large database
Is this a suitable group?
Private enquiry
Perth
Western Australia

I still have FPD installed as I still support a program I wrote several years ago.

All the advice I have read here is good. Are you sorted now or do you still want
help?

If so try emailing me and I'll do my best. (remove capital letters)

regards
Alan

[rod]

Post by Alan Pengelly
I still have FPD installed as I still support a program I wrote several years ago.
All the advice I have read here is good. Are you sorted now or do you still want
help?
Alan

Alan et al,
I'd just like to express my gratitude to all that responded,
you were all very understanding, obviously our expertise lies
in other areas, certainly not computing.
We have applied to the vendor, for last ditch assistance,
and also, our little prayer was answered maybe, we have had
contact with a local programmer, we are awaiting his advice
as to FPD.
Its been an interesting week, but I am glad I asked.
If any of the avenues we have open fail, I'll contact again
for assistance.
Sincere appreciation and a Happy New Year to all.
Rod.
Perth