Search results for query: *

Thanks, SQL Sister. In comparing the remote and the local db's, I noticed that the admin of the remote db created a separate user account for the app's login user id, while the local db has only public and... I forget the other one. So, I'm guessing (I told you I was a newbie) that on the...

Sorry, you're right, of course. Still need an answer to the original problem...[ponder]

If you need all rows from the ItemTable, and there's a possibility that some items don't yet have a price history, then you have to do an outer join with the PriceTable, something like: select its.itemid, its.storeid, its.descr, its.onhandqty, pt.price, pt.EffectiveDate from ItemTable its...

The "set" line is in the actual code; I mistakenly deleted it when I abstracted the code to present my problem. Thanks anyway!

Hi guys and gals, Sorry for the newbie-type question, but I haven't found the answer elsewhere. A company I do some work for recently relocated one of their databases to a remote server, which we access through SQLOLEDB, with the IP address as the data source in the connection string. I...

Hi Mel, The learning curve was pretty steep going from 2.6 to 3.0, and will be even steeper going to 8.0. On the positive side, 8.0 is apparently stable, whereas 3.0 was pretty much unusable (I called it much worse things than that at the time! ;-)) Here are a few things I learned while...

I'm not ramani, but I'll try to help a bit. 1) Because you are using the SQL JOIN syntax, as opposed to, ummm... whatever they call the "from table1, table2, etc." syntax. In SQL JOIN syntax, the table names go to the left and right of the JOIN command, which can be INNER JOIN, LEFT...

Hi Tom, In the old days, when file header corruption was more of a problem, we would typically create a new file, delete the old one, then rename the new one, rather than use ZAP or DELETE ALL, PACK: use temp copy stru to temp2 use delete file temp.dbf rename temp2.dbf to temp.dbf Of course...

As Dave says, your programs will probably run fine, although what you want to run are the .prg's, not the .fxp's. VFP 8 may automagically recompile them, but if not, just delete the .fxp's so that the .prg's get recompiled. Also, as Dave says, if your add-on programs have an interface of any...

If the information contained in the reports is not correct, then it sounds like the indexes are not being updated as you enter new information. If your indexes are really "corrupt", I believe you would trigger a FoxPro error when you opened them. So... do you get an error, like...

Jim, I don't have VFP 8, so I can't verify that the "As Integer" is supported, but this syntax works just fine in VFP 6 as well. I believe that the parser ignores everything after the variable name. You can prove this by compiling this: local lInt As whatchamacallit Compiles fine...

Wow, my first star! [smile] Thanks! Jim, my point is that 10.00 is a real number that happens to round to an integer value. They're not the same thing, and sometimes you want to treat/display them differently.

Transform() works fine here, automagically dropping the decimal points if a real number rounds to an integer. But there may be instances where you want to display a real number of value 8 as "8.00", rather than "8". Due to xBASE's loose typing, I don't believe it's possible...

Thanks for all the replies; I greatly appreciate it. I'm glad to hear VFP 8 is more stable than 6.0, although I didn't have many problems with 6.0 apps crashing or locking up. VFP 5.0 seemed a little less stable, and 3.0 was almost unusable. Thanks again. It's great to know there's a...

Hi guys and gals, I've been away from the VFP scene for several years. The most recent version of VFP I've used is 6.0. Did you all upgrade to VFP 7.0, then to 8.0? Is 8.0 greatly different than 6.0, in either ease/difficulty of use or in available power? TIA!