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
Hi,
you may have to do it by column - here is a code snippet that worked for
me:
oRange = oXL.Range([A1], oXL.ActiveCell.SpecialCells(11))
i=0
FOR EACH oColumn IN oRange.Columns
i = i + 1
?i, oColumn.Address, oColumn.EntireColumn.NumberFormat,
ISNULL(oColumn.NumberFormat)
IF ISNUL
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
Andrew Davies MBCS CITP
- AndyD 8-)#
PC Development Officer
**
Ma
> 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
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
Dave Crozier said:
"I'd go for integer fields with bit settings for the stored data .."
thanks Dave - that's more or less what I meant by hacking a bit map
".. or even discrete Binary (Y/N) fields depending on the analysis
required."
any ideas on data binding discrete fields to a multiple choice l
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
profox
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 f
> It's the automation that is creating the problem, an excel file from
> scratch goes through
that's very strange - your code didn't appear to be doing anything unusual.
Try opening an 'automation' xls and copying all the data into a new file,
then send that. If one works and one fails do a hex co
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
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it
... I missed off a useful line of code :
*!* 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
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
user
>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
> 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 chara
> 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-)#
**
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
> 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 Sm
> 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 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 of a view or table of de-normalised data (I'm using a backend
database but the same techniques would work for f
> 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-)#
**
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 o
> 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!)
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 confide
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 s
profox
On 8/10/07, Andy Davies <[EMAIL PROTECTED]> wrote:
> works for me in the UK -
> perhaps not surprisingly it bombed on Cecilia Bartoli but
works for me in the UK -
perhaps not surprisingly it bombed on Cecilia Bartoli but had no problems
with Crystal Gayle !
see also: www.pristineclassical.com
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Co
>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 Smokefr
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 Smoke
> 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 -
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 crossloop
>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-)#
*
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 ) 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 ran
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 elec
profox
Andy Davies wrote:
>> Don't think this will work...
>
> it works!
>
> 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
>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-)#
**
Manch
t it as a
mainstream product without the support of a major player.
Stupid I know and I do hope this short 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: p
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-)#
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 emp
"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
... and a *long* time ago (in a PL-SQL for beginners class iirc) I was
taught that using error trapping code to control normal program flow was
*naughty*.
Andrew Davies MBCS CITP
- AndyD 8-)#
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
tab
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 an
... 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 transmitte
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-)#
**
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
***
>>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!
Andrew Davies MBCS CITP
- AndyD 8-)#
*
and watch out for:
http://www.theregister.co.uk/2007/07/04/exploding_mobile/
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files trans
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
b
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 M
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 transmi
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 transmitt
what doesn't it do that you would expect table buffering to do?
Andrew Davies MBCS CITP
- AndyD 8-)#
Mark Stanton
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
Andre
Whil said "50th bday, huh? I thought the irrational attraction was to two
seat
convertible sports cars and shapely women "
no that happens on *retirement* - can be any age from 40 - 80
Andrew Davies MBCS CITP
- AndyD 8-)#
*
>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 s
>Andy,
>Better get back to knotting that cardigan and finding your slippers as
>opposed to being helpful!
>
>Dave Crozier
I wish! - there's 100yds of hedge to cut as soon as I finish my day job!
Andrew Davies MBCS CITP
- AndyD 8-)#
***
profox
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 VF
> 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
Andrew Davies MBCS CITP
- AndyD 8-)#
**
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 us
... and on that site Google raised you:
http://web.nseries.com/products/n95/#l=products,n95,demo
Andrew Davies MBCS CITP
- AndyD 8-)#
> 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
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 Ju
> 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 a
> 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 t1.i
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 Eng
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
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester
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-)#
*
> 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
profox
Andy Davies wrote:
>
> 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 chi
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 box,
Hi,
I just deleted a bunch of records in error, is there any way to get them
back or have they actually gone (as I suspect)?
thanks
Andrew Davies MBCS CITP
- AndyD 8-)#
PC Development Officer
Housing IT
Housing Services
Manchester City Council
@Hawthorn Cottage
( Office +44 161 2
> 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
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 trans
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
t
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 st
Lew,
the endtry is in the right place - actually that isn't relevant as the
problem occurs in the gridouter.init code (invoked by the newobject()
call).
see my subsequent (Bayes delayed) posts for an explanation of the
[pinter]grid I'm using.
thanks
-Original Message-
Hmmm.
Could you r
> 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
> 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
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-)#
*
>> 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
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 supports
> 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 t
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 Maintenance:
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 Warning
Has anyone come across this - I have some code where just occasionally the
alias() gets changed:
** myform.someButton.Click
SELECT curMembers
* snip some set form properties code
TRY
thisform.Pframebase1.Page2.NewObject('Gridouter1','Gridouter','mmclasscode.prg')
CATCH TO oException
** mmclass
has anyone come across the current work area (alias()) changing apparently
at random? - here is sample code:
* myform.someButton.Click()
SELECT curMembers
* snip myform property setting code
TRY
thisform.Pframebase1.Page2.NewObject('Gridouter1','Gridouter','mmclasscode.prg')
CATCH TO oException
> 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
Thi
> 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 Smoke
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 -
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 .
Andrew Davies MBCS CITP
- AndyD 8-)#
my 2nd attempt to send some code explaining my a l i a s problem seems to
have gone the same way as the first version!
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 J
co-citation = "you scratch my back, I'll scratch yours"?
Andrew Davies MBCS CITP
- AndyD 8-)#
**
Manchester City Council supports Smokefree England - 1 July 2007
This email and any files transmitted with it are con
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 confident
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
so now it's open to anyone to wrap Fox or Dabo 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 England
> 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-)#
**
1 - 100 of 613 matches
Mail list logo
