I have created some software where multiple users need to access the data at the same time and make changes to the same table. I have all the files open shared so that multiple people can use see the data at the same time, but if someone tries to write to the file by modifying a record or...
Hello,
I'm trying to convert a numeric value to a string, but I don't want it to round up the decimal point. Is there a way to do this?
NumValue = 0.1275
I need the string to be "0.12"
If I use str(NumValue,4,2) the value is rounded to " 0.13". Maybe there is a way to truncate the string...
Hello all,
I am trying to extract some jpg files from a foxpro table with a general field. Each record has an employee's number along with their picture. I would like to extract these photos from the table and name them each with their corresponding emp. number. For instance the following is...
We are trying to print a picture that is held in a general field in a table. The photo is in color but it is printing in black and white. We know that the printer is fine because we can print in color without using the foxpro program. But when we try to print the same picture from the general...
Hello,
I'm using VFP 6.0. When I try to create a new form with the form designer, there is a grey box that won't let me expand the form past this box. I can change the height and width in the properties, but then i can't see past this grey box. Does anyone know else have this or know how to...
I have an application running from a citrix server that users can access by logging in and running the app. On some user's machines, I can print reports fine to the default printer. But, on two user's machines, nothing will print. The application runs like it's printing, but the data is...
I have an application that I have running on a server. Before this application can be run on a user's PC, I need to copy files from the server to their hard drive for the app. to work. These files are mainly just .dbf's to direct that hold path's to the server, but I also need to copy over the...
User's keep getting a "Record Unavailble, Please Wait..." message at the bottom of the screen. This occurs when a user is trying to write to a table. Then the screen will lock up for a while. Multiple users have access to write to the table because it is open shared. The table in...
I'm using foxpro 6.0. I have a string where i need to delete the two rightmost characters from it. I have a string that holds a street name but the direction(N,S,E,W)is at the end of the string and I need it to be at the beginning. The string looks like this.
'ELM ST S'
I need the string to...
Is there a way to export records from a foxpro table into a text file? I need each record to be a new line in the text file. The fields also need to be in the same order that they are in the record.
Is there a way to change the background color of a button so that it is the same color as the form? This way only the word that is on the button will appear. I'm trying to create clickable text. Is there an easier way? Thanks.
Erik
I have a file with the .dat extension that i'll call data.dat. i need to read each line in from the data.dat file into a string. for instance, i have data.dat with this in it
m4*TA012340>03/05/12:04:36:44
m4*TA012341>03/05/12:04:36:44
m4*TA012342>03/05/12:04:36:44...
I have a button on a form so that when you click the button, I want the following to happen.
1.) Click button.
2.) Set focus to text box(5 characters) ex. thisform.textBox1.setFocus()
3.) Wait for 5 characters to be entered in the text box.
4.) After 5 characters are entered, read the data...
I'm trying to create a compound index for a table in the code by using a variable name as the name of the index. but I keep getting an error. The variable hold's a date value. This is the code I'm using.
mdate = date()
index on fieldA, fieldB tag dtos(&mdate)
Is this the right syntax?
i have a table in excel format and need to convert it to a foxpro table. i know that there is a command to convert foxpro tables to excel tables, but is it possible to do it the other way around. if so, then could you help? thanks,
Erik
I've created an executable file from a project i've been working on. the executable works fine on machines that have VFP 6.0 installed on it. i have the executable on a server, so the user can just click on the executable and it should run. when i run the executable on a machine that doesn't...
I'm trying to create compound index tag with code instead of the interactive way. so far the code i'm using is as this.
use table
index on field_1 tag uid
the problem is "uid" is a variable that i have set as a user's id. so i want the .cdx to be named what is in the variable, not...
i am trying to call a form "fpwmod" from another form "fpw004". i am have a button on the first form "fpw004" and in this buttons click event i used "do form fpwmod" to call the other form. then in the form "fpwmod" i am trying to assign a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.