Recent content by Doug Lindauer

This is a nice philosophical discussion. Actually in transaction tables I've created I HAVE included auto incrementing surrogate keys but I can never recall actually needing them. But you mentioned an updateable view and in that case it's 100% correct. You would need a unique key. I don't...

Absolutely correct Chriss. I didn't look closely enough at that. But, for me, I don't always create a surrogate key like an id number unless it must appear in a related table as a foreign key. It's fine but it seems like mostly an unnecessary addition. I can't argue with someone doing it as...

Mandy, I'm not sure you've gotten it yet. Let me focus just on what you said and wrote and give the simplest explanation. (Apologies to Chriss and mjc for rehashing what you've already said.) First off, you didn't give enough information for anyone to answer your question without making a lot...

Kudos to costin77. He saw the problem while I was still trying to think about it. :) To add to his post, when you initialize an array, all the values are logical .f. so if you try to sort it when some values are character and some are logical it will obviously give an error.

Well it comes down to whatever floats your boat I suppose. But for me, having been a dBase developer since about 1980 and having written stuff in various other languages and SQL implementations, I'm of the philosophy to keep your code as simple and direct as possible. That's because your code...

Not sure why people want to complicate things with "cast". Simply put a 00.00 value in there as this: select CUSTNO , ; space(3) as TYPE , ; space(10) as BILL_STAT, ; 00.00 as NUMBS ; from TEST123 ; where RESTO='5103' You...

Did you ever figure out the problem? BTW EinTerraner is certainly right that "append from ... for " is a solution. It's the simplest.

Perhaps you're missing a key field in the detail table. Without seeing everything it's hard to know. Or maybe you have some filter on in the detail table?

You have to put the "from" AFTER the field list as in : select *, ; , ; , from PASSAGEIROS where ... Note that doing this creates a new table TEMPPAX so if that's what you want, OK. It overwrites any existing TEMPPAX file. Also if you want to append the selected...

If you do that you'll overwrite TableB with the structure from TableA and the contents will only be that of the select statement. You could either do an "append from" operation where you first copy the rows out of TableA into a temporary file and then append from the temporary file or Do a sql...

This is what I did. My local community college has a lot courses in the computer area and I took 3 on developing in Java and Android. One of the projects I ported over to VFP was a blackjack simulation (the card game of blackjack.)

I was gonna answer but all these other guys kind of beat the answer to death already. :) I absolutely couldn't think of a thing to add!

My bad, sorry. I usually pay attention to the VFP forum and those are visual foxpro functions.

Use adir() to get an array of text files then filetostr() to read each one and add it to a string then strtofile() to write it back out as one file

You didn't specify the data types and lengths of the fields. It looks like they're character type but the code will be a little different depending. In any case you'll be using either padl() or chrtran() somewhere in there along with "replace all ...". Keep in mind when posting a question like...