Recent content by 113983

I have need to write program something like below if @pnumber=1 begin select * into #all from table1 where code = 9 end else begin select * into #all from table1 where secondcode=99 end when I try this I get #all already exists even though I am executing the else portion of above...

Thanks Markros - that looks good - however it is a manual conversion and I am going to create a form to open tables and convert as we have multiple installations. Lots of good tips in that thread.

We develop a commercial package and have a million test directories, then a few thousand development dirs. I EXAGGERATE!

Thanks for the help guys - deleting all the foxuser.dbf files worked! I went into mycomputer, searched for filename - foxuser.dbf - went for lunch! when I got back - 409 foxuser files on list - deleted them - fixed my properties window problem good way to clean up other wasteful duplicate files

I have a weird problem - my properties window starts with the name of method field only about 3 characters wide - for instance, "Activate" displays as "Act". I can resize, but after quitting and reloading, same thing. I have tried deleting the foxuser.dbf, rebooting, searching thru help - no...

I created a new form with a grid and cannot re-create the problem - so there must be a setting in our program that is different. I am investigating and will post if I find out what is causing it. Thanks for the help.

I have tried adding formatting (RT) and also inputmask 99,999,999.99- - didn't fix.

Hi Craig - this is easily repeated in the grids. using VFP9, SP1

We display transactions in a grid and if you happen to place your cursor on a read only amount that contains cents then use the up arrow key to move up to another item in the grid, the decimal amount changes to .00 For instance, if you have an amount of 12.34 and place the cursor just before...

thx everyone - seems to be a problem with our new icon which is supposed to be 16x16.

We just recompiled a project using the same icon etc and it doesn't show properly when you alt tab to scroll thru apps that are running. it shows properly at bottom of screen. Is this a Windows Vista thing?

yes - for sure - the project has a number of scxs. basically they are run from a menu where would say "do form abc.scx". If you go directly into the project (it is a reports module) and select the abc option - it runs. However if you have run a number of other prgs, scxs, exes, etc...

WE have a large VFP9 application (menu driven) where users may run a number of exes at any time and in any order. Occasionally we will get a file not found error in one of the exes (usually a prg or scx). We check the project and the file is part of the project. We exit the system, come back...

Thanks everyone - and thanks for the heads up Olaf - a good idea to start small and learn the technology before jumping in. We do have one application that is only one exe and probably only about 20 scx's so would be good place to start. Thanks again. You guys always have good answers!

I have to agree and we are not looking forward to the day they (MS) stops supporting it. We have app of over 200 exes, 750,000 lines of code and are not looking forward to moving - but 64 bit will someday become 128 bit and .... when is the correct time to move forward!? We love VFP and can...