Visual FoxPro General Forum

Writing months as field name, as user selects the start month

Sat, 28 Nov 2009 10:31:29 Z

Hi all good day, I wanted to enter month as tee field of a table once the user selects the first month as he wish. E.g. If user enters March, I want to enter rest of the months as field names of a table including the month that the user entered.

Thanks

progressbar in select statement

Fri, 27 Nov 2009 18:35:55 Z

Hi,
Following is my select statement. How can I give a progressbar to this select.
select m.hdrid, ;

trn.stockid, ;
trn.taxid, ;
trn.itemname, ;
trn.qty, ;
trn.location, ;
trn.profit, ;
trn.salerate, ;
trn.amount, ;
trn.shortpty, ;
stk.batchno, ;
stk.expiry, ;
stk.mrp, ;
stk.cmrp, ;
stk.itemcode, ;
stk.purrate, ;
stk.cpurrate, ;
stk.landing, ;
stk.itc, ;
stk.taxcode, ;
from &r_trn trn,&r_stk stk ;
where m.hdrid=trn.hdrid and trn.stockid=stk.stockid ;
order by 1 ;
into dbf tmp

vfp report to pdf or word

Fri, 27 Nov 2009 03:10:26 Z

i wanted my report from vfp to be converted to pdf, excel or in word format. what should i do?
please help

use command

Sat, 28 Nov 2009 01:56:15 Z

hi

how to close an open table because i have encountered an error 'table or alias is already open'

kindly evaluate my ocdes below;

command button
proceedure click

use c:\table
set filter to fieldname=trim(erika)
report form reports\report1 prev

the error occure when i click the button for the second time.
what should i do?

thanks in advance

How to lock a program from edit, reading and delete?

Fri, 27 Nov 2009 15:34:37 Z

Is there a way to lock a program that reside in the drive folders from edit, read, and delete but can still use it to run when needed? thanks

How do you shift a column in Foxpro table as you would do in excel

Thu, 26 Nov 2009 11:37:14 Z

what is the command to do that? shift up and down, etc?? shift but have the top heading as it is.

Thanks

C#

Fri, 27 Nov 2009 07:10:38 Z

disadvantage of goto inC#?

vfp8 + pdf

Fri, 27 Nov 2009 15:28:40 Z

can i generate a pdf report from vfp8? how?

What .DLL files are needed to run VFP 9.0 without installing VFP package?

Thu, 26 Nov 2009 14:57:50 Z

I want to know where I can find the .dll files and which are the ones I need to run VFP in system without installing the package.

What steps should I take to upgrade visual foxpro 8.0 to 9.0?

Wed, 18 Nov 2009 11:23:13 Z

Hello, I have to upgrade visual foxpro 8.0 to 9.0. I've never done this before and I don't know if I should just download 1 file or more. My databse is also made in visual foxpro (not by me) and I don't want to do something that will create a headache for me. Please help!

Incremental search in foxpro 9.0

Tue, 18 Aug 2009 14:23:02 Z

I am developing an application in which i need incremental search for data stored in database. I have developed one but it uses another form with text box and listbox and opens in another window.

I want that when the user enters the text box , list will appear on the same window just below the text box and as the user types any character it will highlight the matching data and i also want to use uparrow and downarrow key to move in the list up and down while remaining in text box.

Can anybody help ? I will be very thankful. it is very important to me.

thanks,

saving data in multiuser invironment

Wed, 25 Nov 2009 19:13:06 Z

Deare Experts,
I have posted questions to this forum to understand buffering,locking,tableupdate() etc
to save my data in multiuser invironment. Many things cleared to me by getting your
valuabl replies but still I am confused. I am repeating one of my questions. So please do not
say "Don not repeat a question". I could not understand how to save data,where to start
from so that data clash between users could be avoided. So I am giving deltailed information
of my invironment. Please give me a guideline in my given invironment so that I could
accomplish my work. Following is my detailed environment.

1-I have six dbf tables opened in init() of the form. some tables opened 2 times and 3 times
whith differnt alias in order to set relation between tables and index.
2-hdrtable,trntable,stocktable,partytable,leadgertable,gettaxtable
3-two cursors tmp and tmp3
4-hdrtable,trntable and leadertable is linked with common table field hdrid
5-hdrtable stores information of the invoice
6-trntable stores information of invoice items
7-stockfile stores stock quantities and other information.

When user clicks for new invoice, he is given blank fields to fill.
cursor tmp stores invoice items filled by user and finally to save to trnfile.

When use is finished and clicks save button.
1-I have to generate hdrid and replace hdrid in tmp cursor
2-I have to save one new record in hdrfile
3-I have to save new records to trnfile from tmp cursor
4-I have to save one new record to gettaxfile from tmp3 cursor
5-I have to save one new record to leaderfile
6-I have to update party balance in partyfile
7-I have to deduct sold quantities from stockinhand quantity in stockfile

Above is the invironment, I have to save. Should I enable buffering when user
clicks for new invoice? Please help me.
Thanking you all in anticipation.

Cannot retrieve remote data from all network computers?

Wed, 25 Nov 2009 20:08:32 Z

I developed a paging program that sends specific information to a transmitter. Works well, however moving forward I now need a client to access the data over the network. The client locates and connects via a TCP connection which I broadcast back the network path for data retrieval, ie \\computername\c\programdir\ and stored in variable cDataPath.
I've attempted to retrieve this remote data with various methods.
* Using the vfpoledb...ADODB.connection
* Using SQL SELECT Method
* APPEND Method
All methods use cDataPath in their constructs. After creating a distrib. version and installed, the client connects but fails to retrieve data. Here is the Mystery, it works here, all methods??? All 10 computers, some XP, some VISTA on our network function as expected. I did bring in a couple labtops, wirelessly hooked to the LAN, however they also failed to retrieve data.
Any ideas on what may be causing the malfunction, PLS HELP.

Regards:
Clink

How do I get the right driver to access VFP 6 via ODBC?

Wed, 25 Nov 2009 21:19:35 Z

Hello. I'm trying to access a VFP 6.0 database via ODBC, and when I try to point ODBC to it, I receive a message saying "You must first install the current version of the VFP ODBC driver." It then gives me a url to go to, which turns out to be defunct, but I have gathered from exploring the MSDN site that one could maybe get by with a VFP ODBC driver (which is not well supported), or go to the OLEDB driver. However, there seem to be a bewildering variety of them and it's hard to find the exact one to go with.

I have managed to download both VFPOLEDB.MSM and VFPODBC.MSM. However, when I click on them, my computer tells me it doesn't know what program to run an MSM file with, nor does a search on the web report the answer.

I have a working version of this app on another computer, and on that computer, neither VFPODBC.DLL nor VFPOLEDB.DLL is to be found in WINDOWS/SYSTEM nor anywhere else. However, that computer does have Visual Studio 2005 installed on it. I could install Visual Studio 2005 on this second computer (if that's legal), but I'd rather solve the problem as simply as possible since this computer doesn't need Visual Studio (nor, as it turned out, did the other computer).

What should I do?

Thanks for your help,

Peyton Todd

Coverting a numeric value to a character with the str() finction.

Thu, 26 Nov 2009 17:22:42 Z

When I do convert the a few numeric expression to a character and add them to put them together , then insert it into a textbox, Why does it have so many spaces in between them. How do I get rid of these spaces?

Windows 7 and VFP 8

Thu, 26 Nov 2009 12:11:04 Z

Hi :)

I can not install VFP 8 on Windows 7[Evaluation Copy].

Can anyone help ?

Thanks in advance

Nishu

problem with on selection of combo box listitem in the grid

Wed, 25 Nov 2009 14:02:02 Z

Hi experts,
I have added combo box dynamically to the grid.like looping through the cursor and adding the combo boxes to the grid.but once a particular list item is select in the combox, all the comboxes in the rows of the grid are showing the same list item.Instead I want the selected list item be shown in only that perticular combox of the row and change the columns of that row accordingly.please help

thanks
Percy

Importing data from 30 datafiles from a file named Flowdata.xlsx at one click of a button

Fri, 20 Nov 2009 20:43:56 Z

hello,

There are 23 Excel workbooks contaning data.In addition , there is a workbook that contains this data.This workbook is callede Data.xlsx.I want to develop a macro to IMPORT all the daat from the 23 datafiles at the click of a button.Also, this macro should be able to do this when placed in the same folder as the 23 data files.

kindly help.

cannot find local table or alias

Thu, 26 Nov 2009 09:50:33 Z

hi,

i have issued ths code in a timer to check the value of a table evry 5 sec but i have encountered error " table or alias is not found"

I have tried using "use command" and select but still it has the same error

the form in which has the timer is in showwindow=1 and in top level form
any correction on the codes below to correct it is highly appreciated.

thanks.

SELECT

local_user

levelx=level1

PUBLIC

so2

SELECT

alert1

xx=status1

xx=1

DO CASE

case

levelx=9

DO FORM forms\genei

ENDCASE

ENDIF

how to tell the position of my cursor?

Wed, 25 Nov 2009 23:56:22 Z

I wish to find out the position of my blicking cursor on a string so that I could cut whatever before that. What is the actual value for the cursor position. We had readkey() or something else to find our the asc value?
Thanks and have a nice holiday.

Starting an application

Wed, 25 Nov 2009 20:18:37 Z

Hi,
i want to develope an inventory application. How should i start.
i know to create form and place controls on the form.

how to print the excel sheet content from vfp code?

Wed, 25 Nov 2009 14:44:11 Z

Hi Experts,

I have a requirement to print the contents of the grid to excel and then print the grid content on the paper.
i able to export the content to the excel. but,
As by printing the columns of the grid by using the ? and ?? commands im getting the printout with no proper alignment of the columns.Is there any way to print directly the exported content of the excel instead of using the ? and ?? commands to print?

vfp popups

Tue, 24 Nov 2009 05:46:30 Z

hi, i was trying to make some pop ups or alarm which reminds a user of something to do. i have seen one in which a genie will come out from a screen and will diplay some text message reminding you of somthing. Can i do it in vfp? if so, can anyone help me with this. Any help on this regard is a big help to my project.... tnx

VFP, Win7; Install Shield window is BEHIND browser

Mon, 23 Nov 2009 04:04:55 Z

I try to sell a couple of Visual Foxpro (VFP9, sp2) apps online. Everything seems to work with Win 7, BUT.....

The Install Shield Express VFP Special Edition window is behind the browser window. Users think the download button does not work. When the browser is minimized the, the Install Shield window shows itself, but by this time a sale is lost.

Any suggestions? Thanks.
Walter

How do you select a file in FoXpro and add fields and change the width of fields??

Wed, 25 Nov 2009 01:11:14 Z

How do you do this in a command and save it as a program is what I mean. I was able to do this manually, which is after you import the file into fox pro, then you would select that file, the file that you want to add fields too, by set, then select the file, click on the file, then do modify structure, then you could add fields and change the width.

Now how do you do this as command?? the recorder won't do this for you

Thank you!!

how to close cdx file

Wed, 25 Nov 2009 09:31:19 Z

Dear friends,

I have a form. A grid is based on local table. The table is indexed on 6 columns and the indices are kept in a temp.cdx file.
When I run the form many times the cdx file becomes bulky. So I used DELETE FILE TEMP.CDX in BeforeOpenTables in form.realease event.
When I run the form for the first time it runs ok. but at subsequent instance the above delete statement gives an error 'The file is in use,'
So, how to close the cdx file?
I tried ;
if used('temp')
sele temp
use
endif
in form.release method but it is not working,

Should begin transaction...end transaction be used only when updating more than 1 tables at the same time?

Mon, 23 Nov 2009 17:10:12 Z

Is the begin transaction really needed to update a table. What are other pointers to "fine tune" a multi-user environment.

How to print A5 Rotated

Mon, 23 Nov 2009 17:03:20 Z

I have Windows XP SP3, VFP 9 SP1.
The printer is dot matrix. The paper is endless pre-printed with some form
format A5 with width 210mm and with perforation at each 148mm.
How can create Report for this paper? In Page Setup there is also offered A5
format but I do not know how to exchange width with height. To set
Orientation from Portrait to Landscape is not solution because the format
remains the same just printing is upright.
In my "Print Server Properties" I found 187 forms and among them also
exactly the form I want. His name is "A5 Rotated". So I already have
requested form and I suppose that it will be at the customer's PC too.

I had defined my default printer to Epson FX-80 ( yes, very old printer )
and in my VFP "Page Setup" was offered just few ( 6 ) of them : A4, A5,
B5(JIS), Fontfold 8,5 x 12 in, Legal, Letter. Then I changed default printer
to Fax and "magicaly" there appeared all forms in VFP's "Page Setup" and I
could choose my desired form.

In my PC work fine although my Epson haven't declared "A5 Rotated" form.
My friend has HP printer and he get wrong report! I have Page footer at
the end of rotated A5 form ( middle of A4 form ) but friend got
Page footer at the end of A4 form ( to much space between Group footer
and Page footer ) ! ! !

This is Expr field from this FRX when "Save printer environment" is on :
DRIVER=winspool
DEVICE=Fax
OUTPUT=SHRFAX:
ORIENTATION=0
PAPERSIZE=78
DEFAULTSOURCE=15
PRINTQUALITY=120
YRESOLUTION=144

and with "Save printer environment" is off :
ORIENTATION=0
PAPERSIZE=78
COLOR=2

I tried to save with and without "Save printer environment" but with no
result. He constantly got to much space between Group footer and Page
footer. Any suggestions?

I have a question : how could I print "A5 Rotated" form in whichever printer?
I look everywhere but I don't see how can I do this.

TIA
Mitja

status of cursorsetprop()

Mon, 23 Nov 2009 20:02:00 Z

Hi,
What are the conditions in which cursorsetprop() return .f.
Should I add an error routin after issuing cursorsetprop().

How do I skip a column just when I press enter in a grid.

Mon, 23 Nov 2009 21:13:29 Z

I want to skip a column in a grid. What r the commands to do that? I know it should be done in the columns text.

Adding a new record to a table

Tue, 24 Nov 2009 03:06:08 Z

Hi Experts,
How a new record will be added to a table useing rlock(),cursorsetprop(),tableupdate() etc.
Please elaborate.

Tableupdate() not responding

Mon, 23 Nov 2009 17:43:01 Z

Following command I issue.

set multilocks on
use mytable.dbf alia mytable in 0 shared
go top
scatt memv
cursorsetprop("buffering",5,"mytable")
set reprocess to 1
rlock("1","mytable")
tableupdate(1,.f.,"mytable")
data does not save to mytable.dbf
but when I issue replace mytable.code with m.code before tableupdate()
data saved to mytable.dbf.
What is wrog?
Please

coying a file in multiuser invironment

Tue, 24 Nov 2009 10:35:44 Z

Hi all,
In betwin my program at defferent places I have to copy a single or multiple files.
or I have to use select * in muliuser invironment.
How I handle this situation while other users may lock files?
Please.

how to make a row in the grid readonly?

Mon, 23 Nov 2009 12:44:47 Z

im using the following code
LOCAL lbReadOnly
lbReadOnly = (Earn_Type==7)
thisform.grid1.SetAll([ReadOnly],lbReadOnly , [column])

but it makes the column readonly.I want to make a perticular row as readonly when the Earn_Type column has the text has 7.how to do this?

How do I "fine tune" a multiuser environment for it´s best performance.

Mon, 23 Nov 2009 17:14:59 Z

I want 2 know if there are anymore pointers on how to fine tune a multi-user application. Other than private datasessions in forms, DE tables buffered to 5, set exclusive off commands. What other issues should I make sure are correct and assures me quality performance.

C#

Mon, 23 Nov 2009 09:00:57 Z

inC# language what r default values for the following data types: longint,char,string,byte,double,float of these datd types

C#

Mon, 23 Nov 2009 08:56:28 Z

if u r having two for loop statement one inside &the other then how to break the outer loop&inner loop

how to print the grid in foxpro

Sun, 22 Nov 2009 06:35:43 Z

Hi,

I'd like to print all the content of a DataGrid and the text box contents in a single page. How would something like this be done? I couldn't find any code examples.

Thanks

Percy

Saving data in multi-user invironment

Sun, 22 Nov 2009 16:52:01 Z

Hi all,

I have 6 tables involved in sales bill entry. I have written code in load() as follows:

set multilocks on
use table1 in 0 shared
use table2 in 0 shared
use table3 in 0 shared
use table4 in 0 shared
use table5 in 0 shared
use table6 in 0 shared
cursorsetprop("buffering",5,"table1")
cursorsetprop("buffering",5,"table2")
cursorsetprop("buffering",5,"table3")
cursorsetprop("buffering",5,"table4")
cursorsetprop("buffering",5,"table5")
cursorsetprop("buffering",5,"table6")

Now when user will click save button, I have to save data.
should I use tableupdate() or
befor issuing tableupdate(), I should issue flock() and set reprocess to ..

landscape printing

Sun, 22 Nov 2009 10:26:52 Z

Hi experts

I am using vfp9 and want to print some reports using "?" OR "??" on landscape paper. How can I send reports on landscape paper without calling pagesetup.

thanks in advance