FoxPro Help and Support - Can I get Consultancy advice on SQL/Fox in the UK (South East)?

Author

Can I get Consultancy advice on SQL/Fox in the UK (South East)?

Barley Man

2005-05-25, 7:24 am

Are there any Fox people in the South East UK (preferably around Cambridge
area) who would let me PAY them for advice on setting up and using best
practice for connecting FoxPro to SQL. It seems SO Evil and Alien as the help
messages and reaction of the system seem truly dismal!

I really need to visit someone with my PC to show them the problems. Wthout
that, it's hard to discover what I am doing so badly!

Ian

Eric den Doop

2005-05-25, 7:24 am

You may want to contact Mike Lewis, but he's in Edinburgh, Scotland:
http://www.ml-consult.demon.co.uk/
--
Eric den Doop
www.foxite.com - The Home Of The Visual FoxPro Experts - Powered By VFP8

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:CC68B9B2-599A-439F-B489- A4816C6B74D9@microso
ft.com...
> Are there any Fox people in the South East UK (preferably around Cambridge
> area) who would let me PAY them for advice on setting up and using best
> practice for connecting FoxPro to SQL. It seems SO Evil and Alien as the
> help
> messages and reaction of the system seem truly dismal!
>
> I really need to visit someone with my PC to show them the problems.
> Wthout
> that, it's hard to discover what I am doing so badly!
>
> Ian

Cindy Winegarden

2005-05-26, 8:25 pm

Hi Ian,

Again, do NOT define your view to select all the records from the table. You
can't possibly _read_ all the records so don't retrieve them. To filter the
data so you get only a reasonable number of records, do the following:

1. Open the View Designer, choose a connection, and add a table (or
combination of tables).
2. Fields tab - Use the Add> or Add All>> buttons to choose the fields
(columns) you want to see.
3. Join tab - you won't need anything here unless you are combining records
from more than one table in your view. I assume you are using only one
table.
4. Filter tab - This is where you can limit the number of records. I've got
a view to a Counties table. In the box under "Field Name" - I'm choosing
"County_Name" which is a field in my Counties table. There's a button under
"Not" which you can click if you want to choose records that are not equal
to your criteria. In my example I'm going to leave this alone. In the
"Criteria" column I'm going to use "=". In the Example column is where the
filter actually happens so I'll talk about that next.
5. Example column -
A) First let's assume I always want the same subset of rows from my
view. I want Counties beginning with 'A'. I pull down the list under the
Field Name and choose <Expression...> from the list. A box comes up where I
type Left(Counties.County_Name, 1). Moving across I choose = for the
Criteria and I put 'A' in the Example box. When I save the view and then
open it I get counties beginning with A.
B) Let's say I don't want the same criteria every time I open the view -
I want to specify it each time. Instead of putting 'A' in the Example box I
put "?MyCounty" (without the quotes) in the box. When I save the view and
then open it I get an "input box" asking me to put in a value for MyCounty.
I can put in 'A', 'B', or whatever I want. This gives me about 10 rows,
which is a small enough amount that it is easy to work with.
C) Let's say you don't want the input box coming up for the user to type
in. You can specify a variable called MyCounty and give it a value. As long
as the variable is in scope the view will find it. For example, I create a
variable and give it a value by typing MyCounty = 'A' in the Command window.
When I open the view, FoxPro notices that I've got a variable with the right
name available and uses that for the view.

Now, I can specify more than one criteria by adding rows to the list on the
Filter tab. For example, rather than reading a whole telephone directory I
could enter LastName = 'B' , City = 'Durham' , and Street = 'Elm'. This way
I get only a few rows from the server.

While you're in the View Designer, right-click and view the SQL code. You
can create a view in code, without using the View Designer at all by typing
code in a PRG file and then running it. You start out with "Create SQL View
As ", followed by the SQL code. Check out the Create SQL View command in
Help.

Please post back with more questions after you've tried the steps above.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden@msn
.com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden

"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:CC68B9B2-599A-439F-B489- A4816C6B74D9@microso
ft.com...
> Are there any Fox people in the South East UK (preferably around Cambridge
> area) who would let me PAY them for advice on setting up and using best
> practice for connecting FoxPro to SQL. It seems SO Evil and Alien as the
> help
> messages and reaction of the system seem truly dismal!
>
> I really need to visit someone with my PC to show them the problems.
> Wthout
> that, it's hard to discover what I am doing so badly!
>
> Ian

swdev2

2005-06-09, 7:24 am

Heya BarleyMan -
look up AllenPollard at
al [at] gatwicksoftware dot com (reform the email address) - he's setting up
another UK based VFP UG in the South -

or the other UG at http://www.devug.com/

Your other option, of course, is to engage someone to walk you through
things on your computer desktop via remote desktop support and telephone .

if this is quite true? -> "help messages and reaction of the system seem
truly dismal! " then you do not have things indexed as they SHOULD BE and
you are not utilizing parameterized views properly AND
your 1-many child relationships need to be reformed for that 'blindingly
fast' speed.

IF you are sincere and are looking to engage someone for a few hours -
please email me back at
BMAN at efgr/oup dot net .. [rmv the slash and reform]

mondo regards [Bill]
--
===================
William Sanders / EFG VFP / mySql / MS-SQL
www.efgroup.net/vfpwebhosting
www.dotnetconversions.com
"Barley Man" < BarleyMan@discussion
s.microsoft.com> wrote in message
news:CC68B9B2-599A-439F-B489- A4816C6B74D9@microso
ft.com...
> Are there any Fox people in the South East UK (preferably around Cambridge
> area) who would let me PAY them for advice on setting up and using best
> practice for connecting FoxPro to SQL. It seems SO Evil and Alien as the
help
> messages and reaction of the system seem truly dismal!
>
> I really need to visit someone with my PC to show them the problems.
Wthout
> that, it's hard to discover what I am doing so badly!
>
> Ian

Sponsored Links