I rather use a char(1) field with values (Y.N) for logical value.
That would make update errors visible and data recovery easier.
On 10/23/13, Gary Jeurink g.jeur...@charter.net wrote:
to mysql data transfers. I still have to change all the .t. and .f. to 1
and 0 along with reformatting the
So I have a grid with a cursor behind it. The active index on the cursor
can be changed by the user, thus sorting the grid in different ways.
Is there any easy way of determine the subset of records visible in the
grid at any given time?
--
Alan Bourke
alanpbourke (at) fastmail (dot) fm
You could use set filter to but this can be VERY slow if the tables are af a
large size or the network connection isn't particularly quick.
Personally I would make the underlying cursor a SQL Expression which you can
modify then requery in order to refresh the cursor but this means that you are
On Thu, Oct 24, 2013, at 02:29 PM, Dave Crozier wrote:
Personally I would make the underlying cursor a SQL Expression which
you can modify then requery in order to refresh the cursor but this means
that you are dealing wit disconnected data and so updates to the
displayed data need to be
I use this formula to determine the quantity of records visible in a grid:
nGridRowQty = int( (thisform.grid1.height - thisform.grid1.headerheight)
/ thisform.grid1.rowheight)
This gives you a very good estimate of the quantity of records that will
be visible in a grid with fontname= Arial
Hmmm. It's a list of customers and yearly turnover totals for current
year, year minus one and so on. The turnover totals aren't stored so I
am calculating them in the grid cursor SQL i.e.
select accountcode, name, Thisform.GetBalance(accountcode, 1) as prev1
... and so on. GetBalance()
On Thu, Oct 24, 2013, at 02:46 PM, Rafael Copquin wrote:
I use this formula to determine the quantity of records visible in a
grid:
Many thanks Rafael, clever approach, I will see if I can integrate it.
___
Post Messages to: ProFox@leafe.com
Thanks Tracy - just what I needed!
John
John Weller
01380 723235
07976 393631
You need to pass the array by reference.
Put an @ in front of the array variable in the calling line.
___
Post Messages to: ProFox@leafe.com
Subscription
For those of you using the latest WestWind stuff, Rick just posted this blog
entry. Coincidentally I just had a client run into this just yesterday.
http://www.west-wind.com/wconnect/weblog/ShowEntry.blog?id=897
--
rk
___
Post Messages to:
On 10/24/13 06:39 AM, Alan Bourke wrote:
Oh for built-in paging functionality:)
I was going to say that Rafael Copquin had a paper on this, which I did
a test implementation of with some success.
Then Rafael himself popped up with his formula.
I didn't carry it further because I've been
Yes, I wrote an article on pagination years ago and it was published by the UT.
Here's the link
http://www.universalthread.com/ViewPageArticle.aspx?ID=847
Rafael Copquin
On 10/24/13 06:39 AM, Alan Bourke wrote:
Oh for built-in paging functionality:)
I was going to say that Rafael Copquin
I've been out of this end of things for quite a while now so thought
I'd check in with The Collective before doing a lot of research and
downloading.
We want to monitor a number of servers on our network for basic stuff
like memory usage, disk usage, fan speeds, temperatures etc.
The thing
I'm not sure they have what you need, but this company has impressed me
with their technical savvy for network utilities.
www.intelliadmin.com
Mike Copeland
Original Message
Subject: [NF] Hardware monitoring softare
From: M Jarvis brewda...@gmail.com
To:
Also, check out the info in their blogs...they're not too proud to refer
you to other companies who have great solutions they have discovered.
http://www.intelliadmin.com/index.php/blog/
Mike Copeland
Original Message
Subject: Re: [NF] Hardware monitoring softare
From: Mike
On 10/24/2013 8:01 AM, Man-wai Chang wrote:
I rather use a char(1) field with values (Y.N) for logical value.
That would make update errors visible and data recovery easier.
On 10/23/13, Gary Jeurink g.jeur...@charter.net wrote:
to mysql data transfers. I still have to change all the .t. and
On Thu, Oct 24, 2013 at 1:29 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 10/24/2013 8:01 AM, Man-wai Chang wrote:
I rather use a char(1) field with values (Y.N) for logical value.
That would make update errors visible and data recovery easier.
On
I'm not familiar with AFIELDS but a few trips to google should get me there.
I have an e-book about fox-pro to mysql but I've never gotten real far with
it.
Thanks
Gary
-Original Message-
From: Tracy Pearson [mailto:tr...@powerchurch.com]
Sent: Tuesday, October 22, 2013 11:37 AM
To:
On 10/24/2013 2:46 PM, Stephen Russell wrote:
There is no bit or binary data type?
Yes there is. MySQL has a bit type.
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
On Thu, Oct 24, 2013 at 2:24 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 10/24/2013 2:46 PM, Stephen Russell wrote:
There is no bit or binary data type?
Yes there is. MySQL has a bit type.
---
Why not use the proper data
On 10/24/2013 3:32 PM, Stephen Russell wrote:
On Thu, Oct 24, 2013 at 2:24 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
On 10/24/2013 2:46 PM, Stephen Russell wrote:
There is no bit or binary data type?
Yes there is. MySQL has a bit type.
On Thu, Oct 24, 2013 at 2:35 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Why not use the proper data version.
Hence why I asked how Y or N was better.
---
Bingo!
--
Stephen Russell
Sr. Analyst
Ring Container Technology
Buddy of mine is on his condo board and wants to have a website (he
says) to make it easy for members to grab documents and get information.
Needs to be private. I was thinking of the old phpBB forums, but I'm
sure there are better options today. They don't yet have a domain.
What do you
On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information. Needs to be
private. I was thinking of
On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information. Needs to be
private. I was thinking of
On 10/24/2013 5:25 PM, M Jarvis wrote:
On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information.
On Thu, Oct 24, 2013 at 2:22 PM, MB Software Solutions, LLC
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote:
Buddy of mine is on his condo board and wants to have a website (he says) to
make it easy for members to grab documents and get information. Needs to be
private. I was thinking of the
I've been using wordpress since 2007.
Theoretically it gives you that capability, but I don't think it will work.
That said, I am coming out with a new website in a couple of weeks called
WordPress by Virgil
I will be going after the no budget small jobs like this with an offer that
for $100
Ok, I'm logged in, so I can see this
http://keepamericaatwork.com/uncategorized/testing-private-posts/
You are not logged in, so please click on it, and let me know what you see.
You might see a password box, if so, enter vjbtest and see if you can see it
now.
I would be curious as to the
Virgil
Worked as advertised. When I got there, it did not respond to clicking
on the title. After I entered your password, I saw the 'article'.
Dan
On 10/24/13 03:02 PM, Virgil Bierschwale wrote:
Ok, I'm logged in, so I can see this
On 10/24/13 02:26 PM, M Jarvis wrote:
Better yet - Google Docs?
+1 on that recommendation. My organization has 150 members, and we have
a conventional website - no blogs, no comments, just information, events
calendar, etc.
For our board of directors (9 members), we just opened a Google
Thanks.
They have another option where you can make it private without a password
If you get bored, I have posted it at the following link
http://keepamericaatwork.com/uncategorized/testing-without-password/
You should not be able to see it, but I'm not sure.
Theoretically if you go to the
Tried that but it didn't work even for a small group - everyone has to
have a Google account and at least half the people failed in setting it up.
On 25/10/2013 05:04, Dan Covill wrote:
On 10/24/13 02:26 PM, M Jarvis wrote:
Better yet - Google Docs?
+1 on that recommendation. My
32 matches
Mail list logo