On Wed, Jun 4, 2014, at 11:25 PM, Richard Kaye wrote:
> Over
> the years, when I've had the need to do really fun stuff with grids, I've
> ended up writing methods to set the datasource and rebuild the grid in
> code.
This. It really is easier and more flexible in the long run IMO.
__
Here's the code:
CLEAR ALL
CLOSE ALL
CREATE CURSOR Test (ClaimID i, PCN i, Admit d, Disch d, Paid d, ProvNum
c(9), ICN c(11))
INSERT INTO Test VALUES (56, 6, DATE(2013,1,1), DATE(2013,1,11),
DATE(2013,5,1), '9', 'A1')
INSERT INTO Test VALUES (3, 6, DATE(2013,1,1), DATE(2013,1,11),
DATE(2013
On 2014-06-05 04:51, Alan Bourke wrote:
On Wed, Jun 4, 2014, at 11:25 PM, Richard Kaye wrote:
Over
the years, when I've had the need to do really fun stuff with grids,
I've
ended up writing methods to set the datasource and rebuild the grid in
code.
This. It really is easier and more flexib
You can certainly put the grid definition in the grid init, especially if it
does not change after it comes up. The particular scenario that took me to use
form level methods to handle this involved changing the number of columns (and
data) shown based on the user selecting a different option in
Thank you so much, Jack.
On Jun 4, 2014 11:20 AM, "Jack Skelley"
wrote:
> Ken:
> No issues with this.
> Our scouting system is written in VFP6 SP5 and runs great on a Windows 7
> Pro x64 box.
> Some of code had to be re-done for 100% functionality from XP (mainly some
> of the functions in the AP
On 2014-06-05 12:12, Richard Kaye wrote:
You can certainly put the grid definition in the grid init, especially
if it does not change after it comes up. The particular scenario that
took me to use form level methods to handle this involved changing the
number of columns (and data) shown based on
Are you only looking for a Max() for ICN, A3 being the maximum? Your data
shows A2 as the data you want but your explanation of expected results has
the value for A3.
Select PCN, Max(ICN) from test
group by PCN
order by PCN
as a real quick method to do this.
On Thu, Jun 5, 2014 at 10:44 AM,
I think I've got it!!! (ClaimID is unique, btw)
SELECT A1.*
FROM Test A1
WHERE A1.ClaimID = (select TOP 1 ClaimID
FROM Test B1
WHERE A1.PCN = B1.PCN AND A1.Admit = B1.Admit AND A1.Discharge =
B1.Discharge AND A1.ProvNum = B1.ProvNum
Whoops forgot the wrapper for the data.
Select PCN, Max(ICN)
into #t1
from test
< where clause here>
group by PCN
order by PCN
Select ClaimID , #t1.PCN from Test
inner join #t1
on test.ICN = #t1.ICN
On Thu, Jun 5, 2014 at 11:25 AM, Stephen Russell
wrote:
> Are you only looking for a Max() f
mbsoftwaresoluti...@mbsoftwaresolutions.com wrote on 2014-06-05:
> Here's the code:
>
> CLEAR ALL
> CLOSE ALL
>
> CREATE CURSOR Test (ClaimID i, PCN i, Admit d, Disch d, Paid d, ProvNum
> c(9), ICN c(11))
>
> INSERT INTO Test VALUES (56, 6, DATE(2013,1,1), DATE(2013,1,11),
> DATE(2013
At 04:15 2014-06-04, Jack Skelley wrote:
Allen
My first computer was a 'mechanical graphite display generator
complete with a destructive cursor'. It came as a model 2 and was
yellow in color. Every
From your first sentence, my thought was "An Etch A
Sketch?"! (A kid's drawing toy.)
I changed over to "CALCULATE MIN(BegStamp), MAX(EndStamp) FOR selected
TO..." instead of the "SELECT Min(BegStamp), MAX(EndStamp) FROM Inputs
WHERE selected..." All my unexpected response problems went away.
My tentative conclusion: the SELECT does something that messes with the
way the table ge
It's kind of fox because I am working with web connection html form
pages. I used Kompozer and it blew away my original source. Mainly it
added "width:" styles and converted all "<" to "<" and same with
">". It also wrapped some "<%= variable %>" so the browser could not
find "variable".
I
Better choose a text and f5 in your browser ...
I know no web dev using wysiwyg editor
Thierry Nivelet
http://foxincloud.com/
Give your VFP app a second life in the cloud
> Le 5 juin 2014 à 20:44, Jeff Johnson a écrit :
>
> It's kind of fox because I am working with web connection html form pag
On Thu, Jun 5, 2014 at 1:44 PM, Jeff Johnson wrote:
> It's kind of fox because I am working with web connection html form pages.
> I used Kompozer and it blew away my original source. Mainly it added
> "width:" styles and converted all "<" to "<" and same with ">". It also
> wrapped some "<%=
Our webmaster used PageBreeze for years. I tried it, and it works pretty well,
but the problem is that when you do a WysiWig edit on something, it regenerates
the HTML, frequently generating redundant code and invalid syntax. I spent a
lot of time taking out the syntax errors and making the HT
I use EditPro for just that purpose (and a lot more). It handles any
size file, up to whatever the OS can store...it has preset management
for various file types (including HTML), macro recorder, an awesome
search/replace system, is updated regularly, and is pretty cheap at $50.
When you edit
That's what I figured! I've been using UltraEdit for years and really
like it. Especially for investigating low level hex etc. So I will go
back to it. I just started editing Web Connect pages and they were
rather daunting to me initially as an HTML novice. But fixing the pages
after messi
+1
At 04:15 2014-06-04, Jack Skelley wrote:
Allen
My first computer was a 'mechanical graphite display generator
complete with a destructive cursor'. It came as a model 2 and was
yellow in color. Every
From your first sentence, my thought was "An Etch A Sketch?"! (A
kid's drawing toy
this contentnot html encoded
??
On 05/06/2014 19:58, Dan Covill wrote:
Our webmaster used PageBreeze for years. I tried it, and it works pretty well,
but the problem is that when you do a WysiWig edit on something, it regenerates
the HTML, frequently generating redundant code and i
20 matches
Mail list logo