Re: primary or unique index

Le 24/04/2013 21:51, Ted Roche a écrit : INDEX ON STR(StudentID,12)+STR(classID,12)+STR(sessYear,12)+STR(sessionID,12) TAG NoDupes CANDIDATE And what about using BINTOC() instead of STR(). STR() does a binary-ASCII translation; BINTOC() is 'straight' : nearly a CAST command ! The Foxil __

[OT] Dang, Leland!

There you go again! www.heraldtribune.com/article/20130410/ARTICLE/130419993?tc=obinsite Better stop pushing the VW idea to these impressionable kids! -- Regards, Pete http://pete-theisen.com/ http://elect-pete-theisen.com/ ___ Post Messages to: ProF

Re: primary or unique index

On Wed, Apr 24, 2013 at 10:53 PM, Gary Jeurink wrote: > > At the point where I generate the billing, the index I want in place would > not allow an insert command to duplicate a billing for that > student/class/session. I just assumed unique meant only 1 allowed per > table. > > It's a common misu

RE: primary or unique index

I have learned the hard way when updating a field in a view that doesn't use a primary key and several records all get changed. So I feel confident on that part but with all the discussions on candidate vs unique index makes me believe I don't understand the difference. At the point where I gener

RE: primary or unique index

I'm just trying to prevent an accidental double billing for the same item... with a unique index you can only create one instance of ... that student(10) in that class(101) during that session(5th). It would not allow the insert record. Gary -Original Message- From: MB Software Solutions

Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens

You will still have to do real work on a desktop.    From: Alan Bourke To: profox@leafe.com Sent: Wednesday, April 24, 2013 11:56 AM Subject: Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens On Wed, Apr 24, 2013

Re: Review of My Application

Hi Gene I agree, this is a longgg one! Some thoughts though: >>I do not use data sessions, binding to tables, or even a database container. Too bad. If you were to use private data sessions in your forms, you would be able to isolate and encapsulate the form behaviour, at the p

Re: primary or unique index

On 4/24/2013 4:46 PM, Stephen Russell wrote: On Wed, Apr 24, 2013 at 3:02 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: On 4/24/2013 3:46 PM, Jean MAURICE wrote: CAUTION : in VFP a 'UNIQUE' index means that it will keep only the first occurence of a valu

RE: Review of My Application

Gene - at one point you wrote: > To edit, the operator needs to be able to see many transactions > at once. Currently, the system uses grids and does not have much > error checking. Did you mean to say the system uses BROWSES w/o much Err Chking? > If I use grids instead, I want full

Looking for Job in San Diego, California or Los Angeles, CA

Hi I'm a FoxPro 2.6 and Visual FoxPro Programmer in San Diego, California looking for a new job. I know Great Plains Dynamics and SQL and would even consider a job in Los Angeles as a possibility. David David Almada - Database Manager Email: davidalm...@sbcglobal.net

Re: primary or unique index

On Wed, Apr 24, 2013 at 3:02 PM, MB Software Solutions, LLC < mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote: > On 4/24/2013 3:46 PM, Jean MAURICE wrote: > >> CAUTION : in VFP a 'UNIQUE' index means that it will keep only the first >> occurence of a value and it is not very useful ... >> > > >

Re: primary or unique index

I use a subquery to identify What needs to be updated and have the update statement use that set of IDs in its where clause. Update myTable set . where myTable.key in ( Select key from Atable left join btable on . where uber code finds what we need chaged ) HTH On Wed, Apr 24, 2013 at

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Hate to agree with you BUT: 2003 - 2007 wondering WTF? 2007 - now researching, documenting, and researching again. Once I realized that IT was no more for people like me, I obtained my realtors license. Only to see the real estate market go down the tubes, and trust me, real estate is not

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

El 24/04/13 17:23, Virgil Bierschwale escribió: Yep, I realized that as I typed it... You have my humble apologies.. No need, you are paying for your sins right now. Good thing you are lucid enough to not try to deceive yourself with some other faerie story about it not being the system's f

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Yep, I realized that as I typed it... You have my humble apologies.. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Ricardo Aráoz Sent: Wednesday, April 24, 2013 3:22 PM To: ProFox Email List Subject: Re: [NF] The Tech Industry's Darkest Secret: It's All Ab

RE: Review of My Application

Screed? What is that? It sounds Dangerous! And - sorry to bust on you about the Long posting - since - in the past I TOO have at times written Long postings... As it was - I just perused it very quickly - and when I saw the Asterisks - I stopped - read it - and figured I could give quick feedback

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

El 24/04/13 17:19, Virgil Bierschwale escribió: Actually that is not true at all There is no excuse here, with an H1B they will be paying the same taxes and living expenses you are. http://www.irs.gov/uac/SOI-Tax-Stats-Foreign-Recipients-of-U.S.-Income-Stati stics Funny thing about capitalism

RE: Review of My Application

At 12:59 2013-04-24, you wrote: Wow - that was a LONG One Gene! Well, yes, but I am at the point where isolated bits of information are not enough. I validate in Grids - and don't use a DBC - so, no - that is NOT a requirement... That is good to know. Any other comments on

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Actually that is not true at all There is no excuse here, with an H1B they will be paying the same taxes and living expenses you are. http://www.irs.gov/uac/SOI-Tax-Stats-Foreign-Recipients-of-U.S.-Income-Stati stics Funny thing about capitalism though. You believe in it. You even advocate it.

Re: [NF] The Tech Industry’s Darkest Secret: It’s All About Age

El 24/04/13 11:56, MB Software Solutions, LLC escribió: On 4/24/2013 7:31 AM, Alan Bourke wrote: To an extent where despite being a country under an IMF bailout with high-ish unemployment, the Googles and Microsofts who have their European bases here often have to recruit people from outside t

Re: primary or unique index

On 4/24/2013 3:46 PM, Jean MAURICE wrote: CAUTION : in VFP a 'UNIQUE' index means that it will keep only the first occurence of a value and it is not very useful ... Other than for something like a SEEK command, I never understood the purpose/need for the UNIQUE index in VFP. Hopefully some

RE: Review of My Application

Wow - that was a LONG One Gene! I validate in Grids - and don't use a DBC - so, no - that is NOT a requirement... -K- -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Wednesday, April 24, 2013 3:54 PM Dear Vixens and Reynards:

Re: primary or unique index

On 24/04/2013 03:46 PM, Jean MAURICE wrote: you can't have more than one blank line in your table with a candidate index or primary key. Interesting. Why would you want a primary/candidate key to 1. have duplicates and 2. be blank? Frank. Frank Cazabon ___

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On 04/24/13 11:23 AM, Virgil Bierschwale wrote: Now that I am older and wiser, I would do it this way. Rather than have a central MIS, or IT dept. I would have one or more people working in each of those departments getting their job specifications from the department manager, and their big pic

Review of My Application

Dear Vixens and Reynards: I am going to try grids again. It occurred to me that I could have stated things better in my previous post. I left out details that, on further thinking, I decided I had better mention. I also wrote of a few other minor areas, too, that I would like to addres

Re: primary or unique index

On Wed, Apr 24, 2013 at 3:08 PM, Gary Jeurink wrote: > My database training from books leaves me with many questions. I am > building > a billing table so I have a transID (auto incr), studentID (int), classID > (int), clientID (int.. who is billed), cost (float), sessionID (int) and > sessYear (

Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens

El 24/04/13 12:56, Alan Bourke escribió: On Wed, Apr 24, 2013, at 04:44 PM, Virgil Bierschwale wrote: My theory is this is not happening. 100% correct, in the world of business and the office anyway. What's happening is that people are increasingly using tablets and smartphones for the sort of

Re: primary or unique index

Hi Gary, I am afraid not to understand your real problem. If you want to have a 'unique' (discriminant ?) index , you can build a primary key. But if you already have a primary key (on trans_id for example), a candidate index will be ok. You must be aware of one thing (that annoy me A LOT) :

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Don't know what you're smoking. But you better get off of it before it fries your mind. -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Stephen Russell Sent: Wednesday, April 24, 2013 1:34 PM To: ProFox Email List Subject: Re: [NF] The Tech Industry's Darkes

primary or unique index

My database training from books leaves me with many questions. I am building a billing table so I have a transID (auto incr), studentID (int), classID (int), clientID (int.. who is billed), cost (float), sessionID (int) and sessYear (char or int). Now I need a unique compound index of studenID, cla

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 1:23 PM, Virgil Bierschwale wrote: > Good for you. > > Personally I believe the CIO position will eventually be eliminated and > here > is why. > > You were stating Director of MIS and not CIO, at least from my playbook. Your list was into minucha and not

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 12:58 PM, Gene Wirchenko wrote: > > > 1) I finally got my Bachelor of Computing Science degree in 2010. Time > after time in class, I would have totally different questions from my > classmates. I was looking at how to apply the material and asked > accordingly. I no

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Good for you. Personally I believe the CIO position will eventually be eliminated and here is why. All of the MIS depts. I have worked alongside see themselves as the keepers of the key to their kingdom. NONE of them understand the entire business process. For instance, the last good gig I had

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 12:10 PM, Virgil Bierschwale wrote: > I hear from people that have phd's and even the occasional mba all the time > > Most are over 50 and cant buy a interview > > How will they diversify? > > Sadly in the corporate world most of the it depts. Are under the cfo > > That is

Re: [OT] Gene Wirchenko Test Post 3

On Wed, Apr 24, 2013 at 12:09 PM, Gene Wirchenko wrote: > It didn't come through. >> > > Sure it did. You replied to it No I didn't! I deny everything! It is Obama's fault! No, it is Bushie's fault! Oops: it is Ed's fault. That's it: Ed is to blame for everything. OK, back to work. I apo

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

At 06:37 2013-04-24, Stephen Russell wrote: On Wed, Apr 24, 2013 at 7:05 AM, Virgil Bierschwale wrote: > That is what we are told by the media. > > One of these days people are going to realize that the media is owned, > controlled, and shackled by six multinational corporations. >

Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens

On Wed, Apr 24, 2013 at 11:59 AM, Virgil Bierschwale wrote: > We did similar things with inventory back between 84 - 88 using a portable > bar code reader (can't remember the name anymore) > What you are doing is not rocket science > --- > Never said it was. Just proposed a new way to do

Re: [NF] Gene is Back!

At 13:51 2013-04-23, Dan Covill wrote: On 04/23/13 11:19 AM, Gene Wirchenko wrote: The beauty of an announcement such as this one is that if it fails, no one on the list saw it so there is no crow to eat. Well, except for Ed if he was looking. Ed is ALWAYS looking!! Nope. We

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

I hear from people that have phd's and even the occasional mba all the time Most are over 50 and cant buy a interview How will they diversify? Sadly in the corporate world most of the it depts. Are under the cfo That is because the ivory tower does not feel that they are getting their money's w

Re: [OT] Gene Wirchenko Test Post 3

At 13:41 2013-04-23, "Ken Kixmoeller (ProFox)" wrote: On Tue, Apr 23, 2013 at 1:13 PM, Gene Wirchenko wrote: [nothing] It didn't come through. Sure it did. You replied to it. It was a test message with no body to try to track why my E-mails were not making it to the list. Everyth

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 10:33 AM, Virgil Bierschwale wrote: > Actually I do follow the IRA's quite closely. > I also follow the trillions in ETF's that are based on nothing that will > destroy the IRA. > > A question? > > What is the opposite of overvaluation? > > Now that you have sold one home f

RE: [NF] Also looking at the termination of the PC and how will we be poised as this happens

We did similar things with inventory back between 84 - 88 using a portable bar code reader (can't remember the name anymore) What you are doing is not rocket science My question to you would be the Audit Trail? As for the initial paper starting point. What about the salesman that is off the grid

Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens

On Wed, Apr 24, 2013 at 10:56 AM, Alan Bourke wrote: > > > On Wed, Apr 24, 2013, at 04:44 PM, Virgil Bierschwale wrote: > > > > My theory is this is not happening. > > 100% correct, in the world of business and the office anyway. What's > happening is that people are increasingly using tablets and

RE: [NF] Also looking at the termination of the PC and how will we be poised as this happens

Yes, It is very hard to program on those tablets. The keyboards are so hard to use. David Almada - Database Manager Email: davidalm...@sbcglobal.netTweet@DavidAlmada5 Phone: 619-295-5535 San Diego, California - Databases: FoxPro/SQL/MS-Access Data Translation - Information Extraction -

Re: [NF] Also looking at the termination of the PC and how will we be poised as this happens

On Wed, Apr 24, 2013, at 04:44 PM, Virgil Bierschwale wrote: > > My theory is this is not happening. 100% correct, in the world of business and the office anyway. What's happening is that people are increasingly using tablets and smartphones for the sort of casual use that laptops and netbooks u

[NF] Also looking at the termination of the PC and how will we be poised as this happens

I have a question since we are all developers regarding the death of the PC My theory is this is not happening. What I believe is actually happening is that we need fewer and fewer employees, we are buying fewer and fewer pc's and if we can find a way to reverse the economy so that it is br

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Actually I do follow the IRA's quite closely. I also follow the trillions in ETF's that are based on nothing that will destroy the IRA. A question? What is the opposite of overvaluation? Now that you have sold one home for 45 percent of its value, and your IRA has gone to zero (soon), what will

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 8:48 AM, Virgil Bierschwale wrote: > Funny, I would consider you to be a senior engineer at this point. > > Near as I can tell you are still developing? > > That sadly tells me that people like you are on the way out. > -- > Not with this employer. Funny thing

Re: [NF] The Tech Industry’s Darkest Secret: It’s All About Age

On 4/24/2013 7:31 AM, Alan Bourke wrote: To an extent where despite being a country under an IMF bailout with high-ish unemployment, the Googles and Microsofts who have their European bases here often have to recruit people from outside the country because they can't find enough people from insi

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Funny, I would consider you to be a senior engineer at this point. Near as I can tell you are still developing? That sadly tells me that people like you are on the way out. BUT, I believe there is an alternative as old as our world. It is called the Master / Apprentice Relationship. Perhaps t

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

Stephen Russell wrote: Now back to the reality. No, please no. It's worse than I thought ;-) Peter Rajan Imports has changed - we are now Whispering Smith Ltd. For more information see our website at www.whisperingsmith.c

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013 at 7:05 AM, Virgil Bierschwale wrote: > That is what we are told by the media. > > One of these days people are going to realize that the media is owned, > controlled, and shackled by six multinational corporations. > - Or your ability to have new killer

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

Grin There are alternatives. There are watchdogs I believe one of them is called fair or something like that if you want to google them -Original Message- From: ProFox [mailto:profox-boun...@leafe.com] On Behalf Of Alan Bourke Sent: Wednesday, April 24, 2013 7:29 AM To: profox@leafe.com

Re: [NF] The Tech Industry's Darkest Secret: It's All About Age

On Wed, Apr 24, 2013, at 01:05 PM, Virgil Bierschwale wrote: > > One of these days people are going to realize that the media is owned, > controlled, and shackled by six multinational corporations. > What - even the media that say that the media is owned, controlled, and shackled by six multinat

RE: [NF] The Tech Industry's Darkest Secret: It's All About Age

That is what we are told by the media. One of these days people are going to realize that the media is owned, controlled, and shackled by six multinational corporations. Let me show you what was happening back in the 80's Through the architects and program managers, Gates was able to contr

Re: [NF] The Tech Industry’s Darkest Secret: It’s All About Age

Sure but was it not always thus, for all types of tech professionals? It also depends on location and skill base - here in Ireland there are no kids coming out of college with IT and development skills because they were all told 'tech is dead, go into pharma' after the dotcom bubble. To an extent

Re: lianja

FWIW, here's what they say about VFP in their FAQ: "Microsoft no longer supports Visual FoxPro how does this affect Lianja? This has no effect on Lianja at all as it includes its own native cross-platform implementation of the Visual FoxPro database and scripting language with a full 64-bit data

Re: lianja

On thinking about it struck me as being limited in the control you have over creating the UI, in terms of positioning objects, and there was no obvious way to use source control with it. This could just be me not spending enough time on it though. ___ P

Re: lianja

I looked at the beta and again recently after they released a 1.0 It certainly has potential, but there's a load of these appearing (Application Craft, Wakanda) and no clear leader yet. What I always do with these things is read the support forums. The level of activity and number of complaint po