Search results for query: *

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

Hi Mike - mostly asking out of curiosity but also if any have gone thru the process

sorry - we are in VFP 9 but realize that MS is not going to be doing any improvements to VFP so are looking to future. By largest, I meant in number of screens, exes or apps, reports etc. Probably we will be re-writing in another language (C sharp?) but still should be able to use a lot of...

We have a large foxpro app and are considering converting it in the future and would like to know what others have done. Probably convert to C Sharp and MS SQL. Any suggestions

I was afraid that was the answer! I wanted to change the defaults that come with VFP 9. Thanks

Is there a way to pre-set the font for textbox, labels etc. When I add a textbox to a form, the font is set to Arial. I would like to have it preset to MS Sans Serif so that I don't always have to change it. Is this possible?