Recent content by Doug Lindauer

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...

Mike, won't regenerating the cursor cause a problem with RecordSource of the grid? You've created a new object even if it has the same name. I've had problems when I've used the builder to create a grid and then change something even like a ControlSource for a column. It seems to blow up the...

1. yes it would be indexing the cursor but you didn't use the readwrite option and the way I found it works is that you can only make one tag index if the cursor is read only. I get an error when I try to do more than one unless I specify "readwrite". 2. Yes, it would just close the table, not...

I suppose the simplest way would be to create tag indexes when you create the cursor. (But apparently the cursor has to be readwrite.) You could even write one procedure that would work for any column by making the tag name the same as the field name. Then you can reference the...