Test
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version
I think you'll find all the info you need in the archive
hth
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it
30 seconds in a microwave it supposed to 'fix' it :-)
if there's any poetic justice then repeated exposure to airport metal
detectors will kill it s
Andrew Davies MBCS CITP
- AndyD 8-)#
PC Development Officer
**
Dave,
just a wag - given the age of the odbc driver it might be worth trying the
old join syntax (in the where rather than the join keyword).
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports
Andy,
Using OLEDB sorts out the problem.
Dave Crozier
Embrace, Enhance, Replace with something proprietary!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July
Hi,
one of my users has finally listened when I tell them that free text data
entry isn't a good basis for producing reports, but they now want to be
able to select n options from a list of twenty or so (by about four sets of
options).
I haven't done multiple choice [drop-down] lists but I don't
Andy Davies wrote:
I do it the other way and use vfp to 'push' data to Excel
If anyone's interested here is how I do it:
My main form has a dataObj with properties for the database connection
and
the name
I suspect that it is the attachment (.xls) that they are rejecting
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with
I use tabs - just as old hat but not as complicated as formsets g
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with
suggestion:
in vfp select your data 16/64K rows at a time into a cursor
(... where recno() nLo and recno() = nHi or any other way you prefer)
copy to ... type xl5 etc.
In Excel you can bring worksheets together into one workbook fairly easily.
- or - there is an Excel odbc driver but I
The easiest and fastews way, imo, is to read the data with ado, next use
the copyfromrecordset method to copy to excel.
Jaime,
what advantages does ado have over e.g. 'copy to xxx type xl5' ?
Andrew Davies MBCS CITP
- AndyD 8-)#
Using Jaime's method doesn't involve any export/import of physical
data files.
Dave Crozier
Dave,
does rs.Open(select * from credidt.dbf,...) do less under the hood than
use credidt.dbf then?
.. and does anyone know if the excel .CopyFromRecordset method also
truncates cells to 256
Andy,
Memo data seems to go in no problem with no restriction on field length. I
just tried a memo field in excess of 1000 characters.
Dave Crozier
yes, sorry - senior moment:
it's importing into SQL Server from Excel that truncates to 256 -
I *think* it does the same from .dbf memo fields
I just use metadata (.ini ; dbf; dbc; or backend sql tables) then build the
menus on the fly as Dave suggested. If the list is installation dependant
just select the list, if it's user dependant do a join on user/ usergroup.
I use the default fox menu and add or delete (e.g. debug menu for end
... I missed off a useful line of code g:
*!* on selection popup Reports oApp.CallReport(bar()) use bar() as an
index into this.aReports
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports
Could you finish the book as planned and then add a 5.2 appendix that
addresses the changes.
Stephen S. Wolfe, YA2, DAF
and a big banner on the front cover saying 'Covers 5.2'
... but preferably not?
Andrew Davies MBCS CITP
- AndyD 8-)#
I wrote a book once on a beta product. It was unpleasant.
Whil
It certainly was - it was VFP3 (right?)
actually the BOOK was OK ...
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports
Chet said ... number them in columns 73-80
right!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are
It didn't bomb on the PRIVATE but did on the PUBLIC.
well I guess that's what I would expect as PRIVATE re-defines a var hiding
any public of the same name
this is probably down to my not fully understanding private scope but I
have always avoided them like the plague -
a few PUBLICS (sorry!)
Stephen Wolfe said ...are there any good online help on effectively
using the cursoradapter as a update device?
update (and insert delete) is very flexible, I haven't looked at all the
options available (there are the usual setprop options plus some code
'hooks') because in most cases it works
Andy,
You're using CA against what kind of backend?
--
Michael J. Babcock, MCP
mostly ms SQL Server, some Oracle (but really only the 'connection' is
concerned by the backend). iirc I also had a play with xml
Andrew Davies MBCS CITP
- AndyD 8-)#
there is also the point that with most backends you can create views on the
backend, and most 'simple' views of this type are automatically updatable.
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council
to
profox
On 8/10/07, Andy Davies
my preset views are a structural necessity,
and it's then a case of adding the filtering to those.
But how?
Mark
CursorAdapters ??
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree
works for me in the UK -
perhaps not surprisingly it bombed on Cecilia Bartoli but had no problems
with Crystal Gayle bg!
see also: www.pristineclassical.com
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City
wasn't there a virus around some years ago that did this - but was actually
targetting some other file type that used the .dbf extension?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports
Al,
Look at Ultramon. The dual monitor handling is far superior to XP and it
runs on XP and WIn2K.
Dave Crozier
I'm running Win2K Pro with two monitors using nvidia quadro and it's great.
Andrew Davies MBCS CITP
- AndyD 8-)#
Ted - or anyone,
what do you suggest for this scenario:
my own laptop (XP Pro) in an internet cafe. I want to a) link to machine(s)
at home. b) Use a proxy to get onto the internet because some sites (e.g.
the UK lottery) are selectively blocked depending on e.g country of access.
I have
Andy,
www.Logmein.com select the Free Version which does everything apart from
File transfer and print.
As opposed to Crossloop, you can set up the host so you can connect
from
anywhere with a simple authorisation password.
Dave Crozier
... caused a bit of a senior moment there - I tried
Dave, I know less about this than you do but isn't 192.168.1.n more usual -
and what subnet mask are you using?
My setup (which seems to work g) has the router on 192.168.1.1 subnet
mask 255.255.255.0
pool starts at 192.168.1.33 size 32 - servers etc. are assigned static
addresses in the 16-32
Andy Davies wrote:
Don't think this will work...
it works!
Andrew Davies MBCS CITP
- AndyD
First, Google for wattage output (and maybe purchase price) per square
metre for solar panels and work out how much output the client has room/
money for. This will give you some indication of viability - heating and
cooling place *big* loads - you can use direct solar heating as well as
solar
What if the byte represents the number 522? That is undefined in ASCII.
-- Ed Leafe
OK I'll byte (sorry!)
what is the 8-bit representation of the [decimal]number 522?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Don't think this will work...
it works!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are confidential and
Ted Roche said:
I don't want to hunt you down and kill you, either, but really engage
you on this idea that Open Source is more unstable. I thought that way
for a long time, until I realized that *all* software is unstable,
unless its stone-cold dead.
I see an example of this with my current
If you make an error in the code_type or code_description among codes with
the same structure, it might not be detected. You can turn 500.000 from
{ldquo}Natural Sciences and Mathematics{rdquo} in Dewey Decimal codes into
Coal Workers{rsquo} Pneumoconiosis in ICD and vice versa. This can really
mm said:
Read the recent threads on battery life. Apparently
putting the battery in the freezer will wipe out the
eproms and give the battery back its life.
... or not in the case of Li-ion batteries; which afaik is what's in all
laptops.
Andrew Davies MBCS CITP
- AndyD 8-)#
sighted attitude changes but I doubt
it will.
Dave Crozier
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Andy Davies
Sent: 25 July 2007 09:26
To: profox@leafe.com
Subject: Re: [NF] Dabo ++: Open Source and Instability
Ted Roche said:
I don't want to hunt you
For simple lookups I have one table (domain, code, text) and use logic
which is some variation (depending on backend) of:
select text from (select code, text from codes where domain = 'flims')
flims where code = ?flimCode
I don't care whether it's normalised or not, I don't want loads of bitsy
keep your original table and create 5 views?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are confidential
... find out who's running 'end-user' ad-hoc queries against the database
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
hi,
I haven't done any vfp help in years and don't want to have to find my way
around .chm stuff.
So is it still possible to use .dbf help files, and if so what is the
format of the file
ta
Andrew Davies MBCS CITP
- AndyD 8-)#
PC Development Officer
thanks for the info Rick -
poking around in Help! I found this under 'HelpContextId Property'
The Help compiler required to create graphical-style help is included with
Visual FoxPro
Is it - where?
Andrew Davies MBCS CITP
- AndyD 8-)#
and watch out for:
http://www.theregister.co.uk/2007/07/04/exploding_mobile/
g
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
I will never get a laptop that will not require a new battery at
least every 2 years.
You might when fuel cells become common.
but make sure it doesn't leak hydrogen anywhere near your jetpack! g
Andrew Davies MBCS CITP
- AndyD 8-)#
Malcolm Greene said Remove your battery and only insert it when you
absolutely need it
in my experience if you do that it will go completely flat and die.
I have my (ThinkPad) battery installed and plugged in 24x7 - if I need
battery I get 4hrs plus on a two year old battery.
Andrew Davies
from that site:
most people sit their laptops on a desk and use ac power, so the battery
usually suffers, resulting in chemical 'memory', which gives them a life of
about 3 seconds...if you have nicd or nimh batteries...
afaik laptop batteries are pretty much all Li-ion (including Thinkpad 400
Hi,
I don't know why CR shouldn't support 'union all' but if not, oledb does
support vfp databases so you could use a local view:
create database mydb1
open mydb1
create view allmydata as select * from sometab union all
.\newfolder\other\othertab
close data all
* then set CR to use allmydata
what doesn't it do that you would expect table buffering to do?
Andrew Davies MBCS CITP
- AndyD 8-)#
Mark Stanton
imho all the things that people have said about Empower also apply to msdn
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
screen scrape it from www.worldtimeserver.com/current_time_in_GB.aspx
?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
Google 'pixela'
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are confidential and intended
solely for the
Wonder when I became a Luddite.
Ted Roche
it usually happens some time around your 50th birthday, at the same time as
you suddenly get an irrational attraction to carpet slippers and cardigans
with pockets vbg
Andrew Davies MBCS CITP
- AndyD 8-)#
Andy Davies wrote:
Google 'pixela'
Andy
Why (I just did and didn't see anything immediately relevant) ? Perhaps
you would care to elucidate ? The original post was for getting pixel
color at a location from VFP - therefore standalone utilities would
Andy Davies wrote:
cardigans
Are they called cardigans in the US?
no they're called sandwiches - they confused the two Earls.
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree
... and on that site Google raised you:
http://web.nseries.com/products/n95/#l=products,n95,demo
Andrew Davies MBCS CITP
- AndyD 8-)#
there's an option in dts ( a tagged page - 'filter' or some such irc) where
you can change the 'to' file spec.
hth
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1
Just spent the last 3 hours doing this.
so now you can go through it all again to rtrim any varchar's, set defaults
for empty fields (with special attention to empty dates - an sproc is
probably the best bet) and then you can start worrying about nulls (after
all these years they hardly keep me
SELECT * FROM products
WHERE ipk IN (SELECT iproductid FROM customers_products WHERE icustid =
?viCust)
or maybe:
select pr.* from products pr join custoners_products cp on pr.ipk =
cp.iproductid
where cp.icustid = ?viCust
Andrew Davies MBCS CITP
- AndyD 8-)#
not sure if you have an equivalent to IIF in SQL server
case statement - that should do it
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and
on a related topic, we use an application that was originally written in
Fox but now runs under a dialect of C called CO2 (presumably it invokes the
application object).
Anyone know anything about this?
Andrew Davies MBCS CITP
- AndyD 8-)#
select t1.*, isnull(t2.pk,'') alarm, t2.somestuff from t2 left outer
join t1 on t2.pk=t1.pk [where t2.pk is null]
I *think* the t1 t2's are the right way round g
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Hi,
I usually assume that combo/ listboxen contain fairly static data so I
select into arrays (just the once) in e.g. the de.init
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree
Isn't that what I did (but didn't work)?? ::
select t1.*, IFNULL('*',space(1)) as cBilled
? which table is 'left'? and not sure about mysql syntax, try:
select t1.*, IFNULL(d1.itransid,space(1)) as cBilled
from invoice_details d1
left join transactions t1
on d1.itransid = t1.iid
where
Derek Kalweit said:
http://www.red-gate.com/products/sql_log_rescue/index.htm
many thanks to Derek for that, and many 's to those who thought it
couldn't be done; said I just needed a restore from the 'usual' set of
backups; or that I should rtfm.
fwiw Derek's suggestion works out of the
Andy Davies wrote:
snip
thanks from an unusually (?) grumpy- AndyD8-)#
It must be the sight of Boddies brewery slowly getting knocked down:
http://news.bbc.co.uk/1/hi/england/manchester/3640100.stm
At least they are keeping the chimney :-)
Peter
I assume no Prague this year? Perhaps that is why you are grumpy!
Dave Crozier
that *must* be it!
cheers (_)? (_)?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England -
just discovered something I didn't know:
if you click in the frame to the left of an item in the watch window it
automagically sets an 'on expression changes' breakpoint.
you live and learn...
Andrew Davies MBCS CITP
- AndyD 8-)#
As far as I know its being doing that since vfp5.
Have you never put set step on and found that even though one line before
it
said select an alias, its somewhere else when it stops ?
I have many times and I never found out why.
Allen
yes I think this does happen, but in the present case the
Andy, can you observe this behavior when stepping through the code line
by line with the debugger?
Bill
yes and no, when you are at the newobject line the alias is correct, when
you hit the init code it's either right or wrong - there's no line where it
changes.
fwiw I've now put in hack
Rick said:
Check out the SQLSETPROP() function in VFP. There is a property for
DispWarning you can set.
thanks I'll try that - it doesn't actually say anything about changing the
underlying database behaviour as well as supressing the messages, but that
may be database specific. Also it seems
for anyone interested:
the bug was (of course) in the bit of code I snipped from my post, I said:
SELECT curMembers
* snip myform property setting code
TRY
thisform.Pframebase1.Page2.NewObject('Gridouter1','Gridouter','mmclasscode.prg')
CATCH TO oException
the missing bit was:
SELECT curMembers
sorry about the re=posts - the powers that be are flushing Mr. Bayes black
box
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
Andy,
Obviously a PICNIC problem.
(P)roblem (I)n (C)hair (N)ot (I)n (C)omputer
Dave Crozier
'fraid so!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
Dave Crozier said:
Didn't know you had an alter ego (alias). Is it the forthcoming Jeckyle
and
Hyde television drama that has set you off - or have you always felt
this
way?
No no, its not for me, I was asking on behalf of one of my avatars g.
Andrew Davies MBCS CITP
- AndyD 8-)#
n o t h i n g i s g e t t i n g t h r u
s e e
w w w D OT h a w t h o r n - c o t t a g e D O T c o m / h i D O T h t m
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England
Are you attempting a File Attach?
No
If you have magic words in your code, the post won't
make it over.
what are the magic words?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports
does the alias in error relate to the recordsource of the grid?
Dave Crozier
see reply re pintergrid
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This
Hi,
i have an application updating a SQL Server db using cursoradapters in the
de of a form.
The user is cut-and-pasteing large amounts of stuff into a form field which
is causing a 22001 error:
[Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would
be truncated.
Ansi
OK I got fed up waiting for my post to appear:
I've shoved it here:
http://www.hawthorn-cottage.com/hi.htm
any help gratefully received!
Andrew Davies MBCS CITP
- AndyD 8-)#
___
Post Messages to: ProFox@leafe.com
Subscription
Is the different existing cursor attached to a grid?
not a fox grid no, it's what I call a Pintergrid:
http://www.hawthorn-cottage.com/pintergrid.jpg
You can find the original code and Les Pinter\'s article at:
http://www.utmag.com/wconnect/wc.dll?9,7,10,608
the objects in each 'multiline' of
just got a call from our tech admin people - seems it's all Mr Bayes fault
- my emails are statistically suspect!
they're now all flooding thru
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council
just got a call from our tech admin people - seems it's all Mr Bayes
fault
- my emails are statistically suspect!
they're now all flooding thru
Bayesian scanning on the way out??
Derek
that's what I asked - the answer's yes, seems that incoming spam spoofed to
our address is treated as
my posts not getting thru again?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are confidential and intended
well not the one with a subject of 'wrong alias()'
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are
so now it's open to anyone to wrap Fox or Dabo g into a VS shell!
http://www.regdeveloper.co.uk/2007/06/09/vs_shell_eclipse/
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree
Stephen Russell [predictably g] said:
.NET is overwhelming in it's capabilities today and they are going to
roll out a more feature rich version later this year or early next.
exactly what was said about .net v1, and v2 was a re-learning exercise.
There is no (ongoing) money in selling a stable
Alan said:
There is nothing in the Linux world that I've seen that comes close to
the integration and power of Visual Studio and SQL Server.
I used to hear good things about Kommodo but I 've never used it - anyone?
Andrew Davies MBCS CITP
- AndyD 8-)#
here's the code for one of the first asp pages I ever wrote, warts and dev
notes included:
(if the net nanny lets it thru g) - monospace preferred...
%@ LANGUAGE=VBSCRIPT %
!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2 Final//EN
html
head
meta HTTP-EQUIV=Content-Type Content=text/html;
Hi all,
once again I'm finding that not all of my posts are getting onto the list
- Ed, I know that there is a general problem with emails / spam at present
but can you tell if my posts are being bounced by you or not getting out
from my end?
thanks
Andrew Davies MBCS CITP
- AndyD
here's a re-send of a post of mine that didn't seem to get through:
to convert a sql server table to xml
select ... for xml
Why sure...
No, I meant try that actual code - btw imho the xmladapter idea is better
but this works:
SQLDISCONNECT(0)
CONNSTRING=DRIVER=sql
Ed said I see two posts from you today in the log, and none yesterday.
iirc the missing posts were around the 27-29th
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1
to convert a sql server table to xml
select ... for xml
???
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it
Every thing's accelerated now so they can license IT professionals in
about 25-50 more years...
read my sig - CITP = Chartered IT Professional
ho ho ho
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City
are there problems?
I have posted a couple of items today, but no trace.
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files
Dave Crozier said the problem is passing array references
I assume it's all local - so can't you pass an object ref instead?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree
or the
Organizer and I can't just get my head around the best way to do it.
Bloody .NET and C#!
Dave Crozier
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of Andy Davies
Sent: 23 May 2007 09:46
To: profox@leafe.com
Subject: RE: [NF] Lightweight Task Manager
I wondered about a bit of xmlhttp scraping - thought I'd have a try, but:
'UK Official Holidays' appears to be offline or temporarily unavailable.
We have notified the creator of this calendar and will update this
calendar's subscribe link as soon as possible. If the subscribe link for
this
use yesterday\a_sname alias old yesterdays table
select 0
use a_sname alias sname
set relation to recn() into old
replace all sn_account with old.sn_account
Hey presto you have all your PK's back. Anyone think of a better way of
doing that?
Peter
untested
update a_sname set
Back in the neolithic someone wrote an extremely good article on 'core'
Clipper/ dBase - something along the lines of the only 16 instructions you
need to know. It was published in the late lamented .exe magazine.
Someone may have a copy, there may be archives, or you could ask Verity
Stob g.
1 - 100 of 527 matches
Mail list logo