On 05/16/12 09:14, M Jarvis wrote:
> On Wed, May 16, 2012 at 8:38 AM, James Harvey wrote:
>> This select generates an error message "Command contains unrecognized
>> phrase/keyword".
>>
>> SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount<> 0 AND
>> SUBSTR(hip_no,1,1)<> "R" ORDER BY h
On Wed, May 16, 2012, at 10:11 AM, Kurt Wendt wrote:
> While I am still considering the Dabo route.
Definitely, especially with cross-platform in mind. Python I found to be
very easy to get going with, although I have only dabbled.
> But, seeing the link you gave - sure gives me even more of
As long as you fully qualify the field name in a SQL select, you should
have no problems. At least, I've never run into any that way.
SELECT TOP 5 XX.name, XX.desc FROM yourtable XX etc...
Fred
On Wed, May 16, 2012 at 10:23 AM, Frank Cazabon wrote:
> The only time I've ever been bitten is whe
I'll make sure Whil sends me my sales commission.
Another great way to learn automation is to just play with it at the command
line. Create an Excel object. Figure out how to add a document and play with
it. Intellisense is your best friend...
--
rk
-Original Message-
From: profoxtec
I actually ordered it today. I probably have most of their catalog on VFP
already. :)
GMTA...
--
Message: 13
Date: Wed, 16 May 2012 12:49:20 -0400
From: Richard Kaye
To: profoxt...@leafe.com
Subject: RE: Excel Class
Message-ID:
Content-Type: text/plain; charset
The only time I've ever been bitten is when I had a field called "desc"
which messed up some SQL. Since then I've always made sure my field and
variable names are not keywords.
Frank.
Frank Cazabon
On 16/05/2012 12:49 PM, Michael Madigan wrote:
> I have fields called "name" in SQL Select st
When it's going to cost you the most pain, of course... ;) As Murphy states,
"The perversity of the universe tends to a maximum."
--
rk
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Michael Madigan
Sent: Wednesday, May 16, 2012
I have fields called "name" in SQL Select statements that work fine, so I don't
think it's that, but I wonder when that's going to bite me.
- Original Message -
From: Kurt Wendt
To: ProFox Email List
Cc:
Sent: Wednesday, May 16, 2012 12:30 PM
Subject: RE: select question
That's ex
Or if you're just looking for the basics of COM automation with Office, there's
always the very fine Hentzenworke book - Microsoft Automation with Visual
FoxPro.
--
rk
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Ken Kixmoelle
Name is actually a fieldname in the table. I know it's no excuse, but I
created the table in 1985 BEFORE I knew about not using keywords as
fieldnames, but after it was too late to change the fieldname. I've got
other fields like that too, such as "date", in some of my older tables...
Anyway, I'
That's exactly what I was thinking when I read the 1st post.
-K-
-Original Message-
From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On
Behalf Of M Jarvis
Sent: Wednesday, May 16, 2012 12:15 PM
On Wed, May 16, 2012 at 8:38 AM, James Harvey
wrote:
> This select generates
Also, the tried-and-true way to learn this kind of thing is to record
a macro in Excel while you are performing the actions manually that
you want the application to do. Then look at the macro program and you
can see which commands are invoked for which operation and adapt them
to automation comman
On Wed, May 16, 2012 at 8:38 AM, James Harvey wrote:
> This select generates an error message "Command contains unrecognized
> phrase/keyword".
>
> SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount <> 0 AND
> SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc
>
Is 'name' a keyword?
--
Ma
Try the old Symbol font. Both the micron and ohm character are in there. Of
course, then you don't have the full alphabet so it's a question of what you
need to store in this particular column.
--
rk
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.
James Harvey wrote on 2012-05-16:
> This select generates an error message "Command contains unrecognized
> phrase/keyword".
>
> SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount <> 0 AND
> SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc
>
>
> This select creates the cursor succ
I'll try this one then.
Thanks everyone for the great info as usual!
--
Message: 1
Date: Tue, 15 May 2012 08:08:25 -0400
From: "MB Software Solutions, LLC"
To: profoxt...@leafe.com
Subject: Re: Excel Class
Message-ID:
The AS clause on a column definition is optional so the parser is trying to
alias your column name as "top" when you don't have the AS clause in place.
I always put the TOP keyword right after the SELECT. This should work:
SELECT TOP 5 hip_no, amount, name horse FROM stnhorse WHERE amount <> 0 A
You can use the Character Map that's built into Windows. Start/All
ProgramsAccessories/SystemTools/Character Map.
Unfortunately, I don't see that character in Arial. VFP doesn't do Unicode
very well, that I'm aware of, never had much need for it in my work.
Usually the Character Set is Windows:
Mark Dimmock wrote on 2012-05-16:
> Thanks for that, CHR(181) does the trick.
> Any ideas on Ω (ohm's symbol) ?
> Mark
>
Mark,
Check out the built in Windows tool, Character Map.
The U+ code on the bottom left can be changed to 0x.
For the original μ, it shows U+00B5. So this could easily
This select generates an error message "Command contains unrecognized
phrase/keyword".
SELECT hip_no, amount, name top 5 FROM stnhorse WHERE amount <> 0 AND
SUBSTR(hip_no,1,1) <> "R" ORDER BY hip_no desc
This select creates the cursor successfully.
SELECT hip_no, amount, name as horse top 5 FR
Thanks for that, CHR(181) does the trick.
Any ideas on Ω (ohm's symbol) ?
Mark
-Original Message-
From: profoxtech-boun...@leafe.com [mailto:profoxtech-boun...@leafe.com] On
Behalf Of Fred Taylor
Sent: 16 May 2012 15:53
To: profoxt...@leafe.com
Subject: Re: μ Micro symbol
It's more of
It's more of a font issue vs a code page one. If you use Arial, it's
CHR(181) for the symbol you'r looking for.
?CHR(181) FONT "Arial",8
Fred
On Wed, May 16, 2012 at 7:44 AM, Mark Dimmock wrote:
> Hi All
>
> I am trying to find the right code page so I can get technical symbols in
> my table
Hi All
I am trying to find the right code page so I can get technical symbols in my
tables, I am struggling with the symbol for micro (looks like a reversed u).
Anyone able to help?
TIA
Mark
Mark Dimmock
Acton Gate Systems Limited
Automotive Components Park
Hallens Drive,
Wednesbury WS10 7D
Hey Alan - thanks for that link. I'm "in the same boat" as this thread
started by Mike - in regards to learning a New Tech. Although, I will
admit - I have not completely made up my mind yet. Seems like C#/.Net is
got a big learning curve. While I am still considering the Dabo route. I
guess, learn
Christof Wollenhaupt wrote on 2012-05-16:
>> I've determined the behavior is specific to the scrollbar container I've
>> added to this form.
>> The Original Code for the scrollbar container is from FoxPro Advisor
>> 10-2005.
>>
> Is that the one I used for the zoomable image control? That articl
Hey there Dave,
Thanks for the additional input. It sounds to me - based upon what you wrote -
that Text should be the way I should go.
The data stored in the field would be things like a Message that would go with
an item that someone was giving as a Gift. So - the message can't be huge (I'm
Andy,
Its kinda funny that - even though I already mentioned several times in this
thread and the original thread that I was using the Import/Export Wizard to
convert the data from VFP to SQL - I still keep getting people responding with
advice on how to do the conversion via programming.
So
Text fields are good if:
1. You need to store large text entries
2. You do not have to search on the value of the field
3. You don't have to join on the field
Varchar is good if:
1. You store small strings
2. You search on the field value (as n any join or where condition
3. You always (as in with
28 matches
Mail list logo
