Re: [NF] Netbooks - growing market sector

2008-10-05 Thread Mark Stanton
tions to take the real computing power back behind closed doors, as far as I can tell largely for the benefit of their own income streams. Of course we trust them to be nice, don't we boys and girls... Mark Stanton One small step for mankind... __

Re: PDF Watermarks

2008-10-18 Thread Mark Stanton
There's PHP code to do it... Being PHP it's fairly easy to read, and modify? It's an extention to fPDF called fPDi I think. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Ma

Re: Reverse DTOS?

2009-08-26 Thread Mark Stanton
Thanks both, So quick when you know how :-) Regards Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable

Re: Dual Boot Linux Installation

2009-10-29 Thread Mark Stanton
ad the windows files when I need to. If you try it, don't unplug "the other" disk ("to be safe") when doing the installations. It all goes horribly wrong :-( Mark Stanton One small step for mankind... ___ Post Mes

Re: [NF] Network Viewer

2008-03-01 Thread Mark Stanton
The website (nmap.org) says there's a GUI version too 8-) Mark Stanton (New Linux owner...) ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leaf

Dissapearing project window

2008-03-24 Thread Mark Stanton
o something about it _vfp.forms doesn't containt a reference to it! Other projects appear properly, just not the one I'm working on. If I switch off the resource file, it's still the same. Any ideas how I can get this back? Regards Mark Stanton ___

Re: Disappearing project window

2008-03-24 Thread Mark Stanton
Hi John, > My solution would be to delete the project and re-create it by creating a > new project with the same name, adding main.prg then build an app. Hmm, well, in truth there's a few more complications that mean I was hoping not to do that, but on reflection, they may not have a bearing on

Re: Dissapearing project window

2008-03-24 Thread Mark Stanton
> Is it off the screen? > Or hidden? Nope, that's the bit where, when I switch to the command window, there's no form any more :-( If I modify that project, then switch immediately to the command window and "DISPLAY MEMORY", there are no windows defined. The project *is* in the project collect

Re: Dissapearing project window

2008-03-24 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Rick Schummer wrote: > You can try to PACK the pjx file when you have it opened exclusively. > Also look for any corruption in the file. No obvious corruption, although this thing about looking in the "DEVINFO" field hanging the (XP-PRO) machine seems a bit odd, is

Re: Disappearing project window

2008-03-24 Thread Mark Stanton
rmersmarkets" takes focus away from me. If click in the command window I get focus back. No error message. If I try to open the project file as a table at this point I *do* get an error message, which is fine because there's no table there! ? Mark Stanton One small step for manki

Re: Dissapearing project window

2008-03-25 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Richard Kaye wrote: > Did you try using as a table and copying to a new table with a PJX > extension? Yes I did. Copied to the new pjx file it's a bit bigger (13k, about 5%). And as long as it's not called "farmersmarkets" (the old name) it works just fine. As s

Re: Dissapearing project window

2008-03-26 Thread Mark Stanton
Hmmm, evidently not, because that fixes it. Thank you Tracy! The Fox remembers things without the resource file? That's useful to know. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Mainte

Re: Dissapearing project window

2008-03-26 Thread Mark Stanton
control stuff will go haywire. Anyway, Tracy nailed it and it's now fixed. Many thanx to all. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox O

Re: Dissapearing project window

2008-03-26 Thread Mark Stanton
off, if it had already been used in the current session. That's why Tracy's fix worked. So many things happening and going wrong here all at the same time, I got flustered :-( Thanks again. Mark Stanton One small step for mankind... ___

Re: [NF] Ready Ste Hack!

2008-03-28 Thread Mark Stanton
When they say "no one had gained control of the Vista" machine, that presumably includes the person trying to use it legally? Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free vers

Re: [NF] Big blue gets Black Balled

2008-04-02 Thread Mark Stanton
> Well that's one monopolistic, draconian, lock-in-focused, often unethical > company taken care of. Only locally. Here in England it's just been announced that the whole of the south west region has outsourced it's emergency calls (& a whole lot of other stuff local government related stuff I

Simple two step query possible in one?

2008-04-28 Thread Mark Stanton
I'm being asked to do this query in one step, and I'm not sure it's possible. I have a table of data entry and an audit table that records changes to the data. They want all data of a certain type (status "open") and the date and username from the *latest* audit entry for each row. The only w

Re: Simple two step query possible in one?

2008-04-30 Thread Mark Stanton
> Is there a reason why it needs to be done in one step? Because it's in an overnight batch driven from an SQL statement stored in a table. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Mai

Re: Simple two step query possible in one?

2008-05-01 Thread Mark Stanton
> VFP memo? Yup Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxt

Re: Simple two step query possible in one?

2008-05-01 Thread Mark Stanton
, but, supplied by the lead developer from the client, I'll go with it for the moment. Hmm. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profo

Re: Simple two step query possible in one?

2008-05-01 Thread Mark Stanton
Whilst the ExecScript thang is a great idea, my client's batch simply doesn't work like that at the moment 8-( Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.c

Re: Simple two step query possible in one?

2008-05-02 Thread Mark Stanton
ggest to them they change such a core part of the system. Thanks for the help y'all. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-f

Re: [NF] need advice regarding Honesty vs. Brutal honesty with clients

2009-06-30 Thread Mark Stanton
as been said here is "just don't do it. They really don't want to know." Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-fre

Reverse DTOS?

2009-08-24 Thread Mark Stanton
Is there really no VFP function that is the reverse of DTOS? DTOS turns into "MMDD". I can break it apart manually and put it back together as a date, but it's a bit laborious. Nothing already inside? Mark Stanton One small s

Re: Reverse DTOS?

2009-08-24 Thread Mark Stanton
Thanks Jeff, Now you mention it I seem to remember the client has this in their arsenal too. Probably far poorer than that though. TVM Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox O

Re: anyone using Sunline?

2009-02-06 Thread Mark Stanton
;s in the paid for version 'cos this one rocks! Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.

Re: anyone using Sunline?

2009-02-06 Thread Mark Stanton
only intended "after the fact" 8-D). And as Paul (H) says, Agent finds text in any type of file. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listi

Re: VFP app over VNC

2009-02-23 Thread Mark Stanton
I suspect that VNC is single user on Windows because of Windows, and it works properly multi-user on Linux for the same reason. Windows Terminal Server is Bill's equivalent of a proper multi-user box. I'm working remotely for one client exclusively through terminal server. Yes there are some numbe

Re: VFP app over VNC

2009-02-23 Thread Mark Stanton
VFP apps remotely. TS works well with that > (as does VNC of course). As was pointed out though, VNC to Winders boxes isn't great for more than one person though. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leaf

Grids, row highlight and memo's

2009-02-25 Thread Mark Stanton
ull text. I haven't find a way to do this. Is there a way? Thanks Mark Stanton ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listi

Re: Grids, row highlight and memo's

2009-02-25 Thread Mark Stanton
y as you move up and down the grid > though. Ah, that would be good, I'd forgotten about that too. Hmm, that might make the error message tooltip show wherever they hover on the row, which currently I also can't do. :-( > As for grid highlighting try turning themes off. Ah, fabul

Re: Codebook Runtime Application Help

2009-02-25 Thread Mark Stanton
work. Sounds like it's not quite what you're doing in this instance though... What are you doing? 8-) Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman

Re: Codebook Runtime Application Help

2009-02-26 Thread Mark Stanton
asked to save. Codebook doesn't do the "read or edit mode" thing, forms are always editable. I'm sure you could hack it around so that doesn't happen, it's a fundamental part of the framework though. Good luck... Mark Stanton One small step for mankind... ___

Re: Grids, row highlight and memo's

2009-02-26 Thread Mark Stanton
> As for grid highlighting try turning themes off. Does that need to be in conjunction with something else? I've set Themes to .F. both at the grid level and, because that didn't work, at the display object level. That didn't work either :-( I've still got the other settings the way they were be

Re: [NF] is your billable rate dropping?

2009-03-04 Thread Mark Stanton
y saying that that is perfectly legitimate... Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/

Re: Nice VFP SQL Select * from "virtually anything"

2007-12-21 Thread Mark Stanton
Just in case anyone labours under the misapprehension that Microsoft invented this (after reading the intro to this excellent sounding utility), a database called Empress (I think) had some of this (the ability to query arrays as if they were tables) more'n twenty years ago... Merry Christmas!

Re: [NF] Wireless Router & Startup software.

2008-01-17 Thread Mark Stanton
here to go with their unilateral changes). Mark Stanton Who's just upgraded firmware in his router because of Vista problems. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free versi

Re: VFP9-Broadband detection

2008-01-18 Thread Mark Stanton
tabase of what they downloaded and when. With not too much fiddling you can probably send data between your desktop database (& apps) and the web based one... Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subsc

Re: [NF] any audiofiles ?

2008-02-08 Thread Mark Stanton
> I wish *I* had more money than brains. Frontal lobotomy sir? 8-) Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxt

Re: [NF] -- Headaches May Remain In Microsoft Vista Land

2006-11-14 Thread Mark Stanton
> I've heard this sentiment echoed a number of times now (including > here). Certainly what I'm hearing about Vista (mostly here) is moving me very much nearer to switching to Linux. Mark ___ Post Messages to: ProFox@leafe.com Subscription Mainten

Re: [NF] -- Headaches May Remain In Microsoft Vista Land

2006-11-14 Thread Mark Stanton
> But we are a small segment (tech-savvy folks)the zillions out there > just take (and stay) with whatever is loaded onto their PC when they buy > themand M$ knows that. Until Linux comes pre-loaded on the big > players PCs by default, M$ will always rule the day, imo. Agreed. I'm not

Re: [NF] -- Headaches May Remain In Microsoft Vista Land

2006-11-15 Thread Mark Stanton
> Yep. It's hard to go against MS. Very good for the soul though... [;-) > But I'd strongly advise that at the very > least you get things switched over to Open Office. Yup, there is that now you mention it. 'Twould be a very good idea. Mark Stanton On

Re: [NF] -- Hell yes to virtualization!

2006-12-06 Thread Mark Stanton
> Boy I don't understand this at all. > You say that we should punish a company for making a living from the goods > that their employees make ? No, what's being said (in my understanding of it anyway) is that a company who thinks their revenue stream is more important than their customers needs,

Re: [NF] MySQL List

2006-12-11 Thread Mark Stanton
Ummm alt.comp.databases.mysql (I think) recently started up, but I changed isp so in fact I've not been seeing it to be able to tell whether it's any good or not. *Obviously* couldn't be as good as stuff that Ed's set up... ;-) Mark Stanton One sm

Re: [NF] The end of desktop software development?

2007-01-10 Thread Mark Stanton
> petty # pretty...unfortunately... It does too often for my liking... Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/pro

Re: [NF] Microsoft Caught out - Naughty, Naughty!

2007-01-18 Thread Mark Stanton
> computer professionals. Or imagine the converse: that doctors made > their recommendations not on the best interests of the patient, but > on what would generate the most revenue for the doctor himself ?? You don't think this is happening already? Mark Stanton One small st

Re: Office Automation

2007-04-09 Thread Mark Stanton
Hopefully you'll be suggesting they upgrade to OpenOffice??? Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list:

Re: Office Automation

2007-04-10 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, John Weller wrote: > They already have for word processing, etc but OO automation is another > thing entirely! What other thing is it? Mark Stanton One small step for mankind... ___ Post Messages to: ProF

Re: Problem Closing DBC

2007-04-12 Thread Mark Stanton
This might be a daft answer, but you don't happen to have the project file open for the application that uses that database would you? 'Cos *that* will hold the dbc open... Daft I know, but I fell for it a couple of times. Mark Stanton One small step f

Re: Problem Closing DBC

2007-04-12 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Ted Roche wrote: > Burned me, too. If you go to the data tab and highlight the database, > one of the buttons in the Project Manager changes to "Close" that lets > you close the project. Ahah! I hadn't noticed that. Thanx! M

Re: Problem Closing DBC

2007-04-12 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Jeff Johnson wrote: > Mark: This procedure runs in an exe and there is no project open. I don't > include dbcs & tables in my projects. I thought that was probably the case, but you didn't explicitly say so. Sometimes the silliest things are helpful... :-s Regard

Re: Need a Math Wiz

2007-04-29 Thread Mark Stanton
Last time I looked there was a whole load of stuff at the end of the MySQL (4.01 I think) manual about GIS functions. Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of t

Re: [NF] Firefox addon for search engines

2006-08-28 Thread Mark Stanton
gt; > > > > There's a zillion other nifty add-ons. I'm a big fan of NoScript and > > AdBlocker. What other add-ons/plug-ins are people using? > > StubleUpon, Pluck, TinyURLCreator and forecastfox Session Saver Mark Stanton _

Re: Label printing

2006-09-08 Thread Mark Stanton
to but never yet got round to it. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/p

Re: [NF] Python - Thinking Differently

2006-10-02 Thread Mark Stanton
And a very dangerous shift it is too. Having got things going so the average man at the desk has some say in his computing, the big companies have worked out it's not good for their income and are trying to kill it. Very bad for individual freedom imo. Mark Stanton One small step for ma

Re: [NF] I love contracting!

2007-05-17 Thread Mark Stanton
bout the project succeeding and suddenly want to stop doing the cr*p that I've been told to add/change/remove and start telling them how it should be done right, and suddenly they don't like me so much any more... Mark Stanton One small step for mankind... ___

Re: [NF] I love contracting!

2007-05-18 Thread Mark Stanton
n't or couldn't > deliver. Yes indeed. And it would seem that the current climate is to try to put that particularly back in the box, d'you think? Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscript

Re: [NF] MySQL4 and MySQL5 residing on same machine

2007-05-20 Thread Mark Stanton
When using MySQL for website work a powerful, though unfortunate, reason for keeping 4 is that many hosts haven't updated their setups, and hence one may be forced to use 4. Mark Stanton One small step for mankind... ___ Post Messages to: P

Re: [NF] UK Microsoft: Kick out incompetent IT pros

2007-05-28 Thread Mark Stanton
trust them to look after us... And how much is that going to stifle innovation? Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of thi

Re: [NF] Spam king arrested

2007-05-31 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Man-wai Chang wrote: > I guess the rest of the world would be watching the consequences of the > newly passed laws. :) Probably not holding it's breath though... Mark ___ Post Messages to: ProFox@leafe.com Subscripti

Re: Printing on envelopes from VFP app

2007-06-07 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, MB Software Solutions wrote: > Sounds easiest to devise a > VFP Label Report and do that but thought I'd poll the list. That's certainly what I've done. Very easy, not hard at all. Mark Stanton

Re: [NF] The Top 10 Dead or Dying Computer Skills

2007-06-20 Thread Mark Stanton
> instead I did one using ADA... a really > practical skill set that turned out to be (not). Isn't that still going? I thought I say it mentioned in an ad for a contract (admittedly defense) just recently. Mark Stanton One small step

Re: [NF] Toner waste

2007-06-22 Thread Mark Stanton
> Michael: I have a laser printer that fills up a plastic bin with waste > toner. The printer stops and will not print when the bucket is full. The > instructions say to dispose of the bucket in the same manner your client > mentioned. As opposed to the Cannon S520 (I think), which just stops a

Object engineering #2

2007-06-30 Thread Mark Stanton
one screen rather than opening separate screens/forms to update bits of linked data? Or is just that my medication is wearing off? Regards Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: htt

Re: Object engineering #2

2007-07-02 Thread Mark Stanton
local, buffered, data, and save data to a "real" file. Sounds like picking it apart into separate screens *is* the way to go, because that gives at least some indication of why some data has been committed and other data hasn't. Mark Stanton One small step for mankind... _

Re: Object engineering #2

2007-07-03 Thread Mark Stanton
> If you follow Ted's and my suggestion of generating a > local, flat read-write cursor & do batch updates of the underlying tables Seems a shame, doesn't it, that all that clever table buffering is actually completely useless... Ok, not completely, but it would appear not to do the job it's meant

Re: Object engineering #2

2007-07-03 Thread Mark Stanton
> Don't forget that you can use WITH BUFFERING in your SQL now to reflect the > buffered changes! VFP9? I haven't converted any of my applications to it yet. 8-( > ... a definite gotcha in this case. Pardon? Mark Stanton One sma

Re: UK Job

2007-07-17 Thread Mark Stanton
There are three or four around at the moment (or there were last week anyway). One in Truro, one in Edinburgh, one in Birmingham, and a coupla others I don't remember. Mark Stanton One small step for mankind... ___ Post Messages to: P

Re: VFP9-CRM

2007-07-26 Thread Mark Stanton
27;s myself, because that lets me control users by giving them a unique (in my case) three char prefix defining the machine to which I just add the character representation of a normal numeric key. Unfortunately it's not finished yet ... 8-( Regards Mark

Re: VFP9-Icon

2007-08-05 Thread Mark Stanton
is or can I specify this > in the FPW (or some other method) Hey, that's what OO is for (well, kinda sorta). Or should I guess from that that the forms aren't classes? Mark Stanton One small step for mankind... ___ Post Messages to: ProF

Data Strategy

2007-08-08 Thread Mark Stanton
other way? Regards Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchab

Re: Data Strategy

2007-08-08 Thread Mark Stanton
ut the finance person only needs to see this year. What does the "payments" view do? Have a filter for this year? Hmmm, talking this "out loud" it's starting to sound like a daft question. Mark Stanton One small step for mankind... _

Re: Data Strategy

2007-08-08 Thread Mark Stanton
ty to vary this, of course. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Re: Data Strategy

2007-08-08 Thread Mark Stanton
lly. As I said in the reply to Ed (although in slightly different context), this sounds like it takes me away from my pre-made forms, does it? I don't s'pose that's necessarily a problem. However, my user base is *extremely*, e, "naive", so it has to be really simple t

Re: Data Strategy

2007-08-08 Thread Mark Stanton
quot;datalens" (TM 8-) ) to restrict, or not, the main view. I haven't thought through how feasible that would be though... What's the "dynamism" of those views? Regards Mark Stanton One small step for mankind... ___ Post M

Re: Data Strategy

2007-08-08 Thread Mark Stanton
Hi Mike, In article <[EMAIL PROTECTED]>, Mike yearwood wrote: > Unlike most every other system I've seen, I give the user the > ability to construct a where clause. Yup, that sounds more like the direction I'm thinking to go in. But the issue (I think) is that my preset views are a structural nec

Re: Data Strategy

2007-08-08 Thread Mark Stanton
user will want to set up some filters (this year, those traders, these markets), and then a large number of views will need to have those types of parameterised clauses. I'm hoping not to have to do this to so many views, but I can't currently

Re: Data Strategy

2007-08-08 Thread Mark Stanton
HIPAA? Doesn't matter I s'pose, just curious. How many views does that mean you have to adjust? Regards Mark ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: htt

Cascading triggers

2007-08-08 Thread Mark Stanton
y-chaining" (damn, spot the ex-hardware engineer) trigger routines? I s'pose I can imagine a way of coding it, but it feels like it would be messy. Regards Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com

Re: Data Strategy

2007-08-08 Thread Mark Stanton
y sure how y'mean though. Do you mean you used the view tied to the BizObj as the basis for a new one (produced by fiddling with the WHERE clause), and then switched the BizObj to look at this new one? Regards Mark Stanton One small step for mankind... ___

Re: Data Strategy

2007-08-08 Thread Mark Stanton
> ViewEditor is a great tool offered by Rick Schummer: > http://www.whitelightcomputing.com/prodvieweditorpro.htm Ah, thanks. > You don't have to use (nor would I recommend) public variables...you can > use PRIVATE scoped variables. I mean, because of the scope of the filter it would have to

Re: Data Strategy

2007-08-08 Thread Mark Stanton
ike a refinement of Ed's strategy above, whereby I wouldn't need to fiddle with the SQL. The view's are "dynamic" without having to fiddle with them. Cool, thanx. Mark Stanton One small step for mankind... ___ Post Messa

Re: Data Strategy

2007-08-09 Thread Mark Stanton
Seems to me that the big disadvantage of views is the inability to update more than one table via the view, or have I got a big chunk of missing knowledge? It certainly doesn't *seem* to work with the way business objects have been implemented in CodeBook... Mark Stanton One small ste

Re: Data Strategy

2007-08-09 Thread Mark Stanton
s so's I can have a nicely separated client/server setup, hmmm, are we impressed boys & girls? VFP's view wizard lets (in fact seems to want) me to identify key fields in all the tables in the view, and if it knows that, how far off updating more than one of the t

Re: Data Strategy

2007-08-09 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Ted Roche wrote: > On 8/9/07, Mark Stanton <[EMAIL PROTECTED]> wrote: > > > Seems to me that the big disadvantage of views is the inability to > > update more than one table via the view, or have I got a big chunk of > > mis

Re: Data Strategy

2007-08-09 Thread Mark Stanton
that suddenly makes a clean system rather more mucky. Probably not worth the corruption of the math I s'pose. Mark Stanton One hesitant step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/list

Re: Data Strategy

2007-08-09 Thread Mark Stanton
x27;d still like an answer to my previous question. If this is really not doable and views can only update one table, how much of an advantage are they really, except to give server tables a "local presence"? Mark Stanton One small step for mankind... _

Re: Data Strategy

2007-08-09 Thread Mark Stanton
s the advantage over views? Is it more than "I wrote it so it's got all the features I want"? Not that that's invalid at all, of course. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscripti

Re: Data Strategy

2007-08-09 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Dave Crozier wrote: > Mark, > No, your pre made forms are just loaded with a n OLE control "cube" that the > user can manipulate/filter at will using simple cursor drag/drop. I can see I'm'a gonna have to revisit these, tha

Re: Data Strategy

2007-08-09 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Stephen the Cook wrote: > SPT or Stored procedures that take params. Yup, Fairy Nuff Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://

Re: Data Strategy

2007-08-09 Thread Mark Stanton
on't let them build the entire SQL command, just the filtering > parts. Yup. Sounds like a point in favour of the cube stuff that David's using too. Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscr

Re: Cascading triggers

2007-08-09 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Stephen the Cook wrote: > What are you capturing? > > Table, OrigValue, NewValue, User, DateTime, Application Yup, 'cept after an initial try with it I haven't captured "application". My "changes" table is specific

Re: Data Strategy

2007-08-09 Thread Mark Stanton
> temp DBC, and that is what the form controls see. Does that need some quite fancy footwork shifting the BizObj's datasource around? (Is this is getting too "CodeBook"y?) Mark Stanton One small step for mankind... ___ Post M

Re: Cascading triggers

2007-08-09 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Bill Anderson wrote: > RETURN Trigger1() AND Trigger2() AND Trigger3()... Presumably this'll need to be set up after all the RI have been put in place for the database? Mark Stanton One small st

Re: Data Strategy

2007-08-11 Thread Mark Stanton
ind Andy Kramek's stuff? You, Michael, & Steve have all talked about implementing something better via SQL, the VFP views are really SQL, so it looks like it's "just" a not-very-good implementation issue? D'you think something clever here will extend the Fox's

Re: Data Strategy

2007-08-11 Thread Mark Stanton
in my application(s), but it's not the same conversation as the "views" one we've got on to here. Thanx Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/ma

Re: Data Strategy

2007-08-16 Thread Mark Stanton
In article <[EMAIL PROTECTED]>, Ted Roche wrote: > Codebook was written a long time ago. Some of the thoughts of the ways > to do things have evolved since then. Anything, Ted? Mark Stanton One small step for mankind... ___ Post

Re: Data Strategy

2007-08-16 Thread Mark Stanton
you were referring to, and I'm interested too. "Too busy" is certainly a valid reply though. Regards Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman

Re: Data Strategy

2007-08-17 Thread Mark Stanton
't know why, but I have now, sorry I missed it before. Thanks for your thoughts, they're very much appreciated. Best regards Mark Stanton One small step for mankind... ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http:/

SQL "improvements"

2007-09-02 Thread Mark Stanton
agine that it's to "protect coders from themselves", but that's the only excuse for it that I can come up with, and I don't want to be protected from myself. Any thoughts? Regards Mark Stanton One small step for mankind... __

  1   2   >