-
- TYPE
by dni
- 3 Replies
- Last post
by Docpro777
- I like to know what character will return function TYPE() from x, where x is:
x=STR ( YEAR ( DATE ()))
I think I have somthing wrong with my vfp 9 installation.
-
- sending email from VFP through MS Outlook
by glenna
- 11 Replies
- Last post
by Joe Au
- We have the following code for sending email to Outlook. The email gets sent, but the font size is always 36 px or 36 pt (we tried both). None of the <cr><lf> show up. The email is one big paragraph. Can anyone help Here is the code: LOCAL loApp, loEmailItem, cHex lnsize = '"' + str(gaPointsize(Slcrm.nbodysize),2,0)+ '"' cHex = '' nDec = Slcrm.nColor  
-
- Problem when updating!!!! Help!!!
by pamtru
- 10 Replies
- Last post
by Naomi Nosonovsky
- Hi i have a problem when running this query in shared mode or set exclu off.
update table set field=5
It is very slow in a network or mapped drive. The crazy thing is that if the mapped drive is to a directory in the local computer it is very slow too. Example
use c:\table shared
update table set field=5
this go allright but now let suppose that i shared the fold
-
- SELECT Statement
by Somebody2
- 2 Replies
- Last post
by dni
- I have a working select statement, but I want to select additional information from another database. Here is what I have so far -
Code Snippet
SELECT billing.parentid, billing.location, billing.timein, billing. timeout , billing.staff, children.age, children.first, children. last ;
FROM billing, children;
WHERE TTOD ( timeout ) between startdate AND enddate;
A
-
- Using VFoxPro 9 and SQL to create a table
by Zaphod2003
- 9 Replies
- Last post
by Zaphod2003
- Can someone tell me what's wrong with this code
CREATE TABLE countries( ;
id n(10,0) PRIMARY KEY , ;
ccode c(2) UNIQUE , ;
CHECK ( LEN ( ALLTRIM (ccode))=2) ;
ERROR "Currency code must be 2 characters", ;
currency n(10,0), ;
CHECK ( currency >0), ;
cname c(30) UNIQUE ;
)
I have indentified the problem to be with the code CHECK (
-
- Unable to open a table with 255 fields in VFP
by S.G.K.Hari
- 4 Replies
- Last post
by MaxRalph
- Hi all, I have a DBF with 255 fields. When i give the use command in VFP I am getting an error message as' Not a Table' The same can be opened in Excel. Help me how to open the same. Hari
-
- How to use an updateable parameterized view.
by Aleniko
- 7 Replies
- Last post
by Naomi Nosonovsky
- Hi all; This is my first try with updateable views, so please go easy on me :-) I have a table with a primary autoincrementing key. I have created an updateable parameterized view. I'm using this view in a grid. I need to be able to add, delete and modify grid items. I am NOT setting any buffering at the load event of the form. I'm not sure if I should - isn't the view my buffer I'm experiencing
-
- Check permissions of directory
by teeth777
- 8 Replies
- Last post
by Christof Wollenhaupt
- Hi all, I'm after a way to check the write access the user has to a particular directory. Pref. a way to do it that doesn't require non foxpro objects (ie wsh/fso). doing an fcreate to create a dummy file then deleting it isn't suitable. It's not really elegant and there are instances where the user might have create rights but no delete rights & there'd be a bunch of dummy files in the dir. a
-
- Accessing VFP 8 through C# and ODBC
by KevinInIndy
- 12 Replies
- Last post
by Craig Berntson
- Our company has an online product ordering program that accesses our VFP 8 accounting package through an ODBC connection on our server. Occasionally, our system error log table will trap the following error:
"ERROR [S1000] [Microsoft][ODBC Visual FoxPro Driver]This file is incompatible with the current version of Visual FoxPro. Run 30UPDATE.PRG to update the file to the current version. ER
-
- close all child forms
by Victor BA
- 8 Replies
- Last post
by Radenko Zec
- How can i close all the child forms shown in a MDI form at the same time
-
- MSCHRT20.ocx erro
by Christina853
- 7 Replies
- Last post
by Dietervd
- I have just restored a machine in which a program is loaded for testing. (I am not the programmer I was just hired). When I try to start the program i get the following error;
mschrt20.ocx or one of its dependencies is not correctly registered.
I did a full restore from backup to the new machine. The program will not start. Any Ideas I am not a seasoned programmer I am a network adminis
-
- RLOCK on a DBF file on a Windows Vista Shaded Folder
by Stefano Alderotti
- 13 Replies
- Last post
by dni
- Hi,
I have problems on some functions [at first RLOCK()] when i try to access on a DBF file on a Vista Shared Folder from another Vista PC.
If I try to access or execute Rlock() function, from XP on Vista or from Vista to XP, i have no problems.
When i try to execute Rlock() on this file from Vista i have an "Error Reading File" only when another used already use this file.
-
- Ideas for accessing a remote table
by Aleniko
- 6 Replies
- Last post
by navcool
- Hi all; I am going to distribute an application to a few dozen customers. I would like to have a way for these sites to read/post info to a mysql table on the internet. Is there a way I can connect to a remote table but in such a way that the username and password for the connection would be hidden and secure I would also like to have the means of changing the password to the Mysql database and ha
-
- do form and wait
by VFPNewbie
- 6 Replies
- Last post
by AndyKr
- I have a program that scans through a table and when it hits a condition will call a form. The problem is that it runs the form and then continues scanning when I need it to wait for the user to complete the form before moving on. I'm calling it with the DO FORM method and can't find anything on it, please help.
-
- How to remove redundant phrase in field?
by Littletommy
- 14 Replies
- Last post
by Littletommy
- Hi all........
I have a table field that contains things such as.....
V DISCONTINUED W/O REPLACEMENT; V DISCONTINUED W/O REPLACEMENT
-I&S MASTER; 7 SUB 2610-139-3704; I&S MASTER; 7 SUB FOR 2610-139-3704
What I need to do is remove the duplicate phrases, leaving only one instance of each phrase in the field. The amount of phrases in the field varies...could be 2 as shown abo
-
- FOXFIX5.DLL and Windows 2003 Server
by Stuman99
- 9 Replies
- Last post
by Stuman99
- I seem to be having a problem using foxfix.dll on a windows 2003 server. The error message generated is cannot load 32-bit dll c:\foxfix\foxfix5.dll. Any ideas... seems to work ok when run from my windows xp workstation.
Stuart
-
- How to Call Web Page With POST Method in foxpro9
by surinder singh
- 1 Replies
- Last post
by dni
- Hi All I am here again with a new problem Problem: I need to show a web page to users that accepts 2 parameters say name & password through foxpro. But I need to call this web page by using POST method. i.e. if I call this web page by shellexecute function then it shows me the passed paramters in the url like this. web page: https://localhost/test/users/index.html https://localhost/test/users/
-
- Textbox value does not seem to change
by Hans L
- 13 Replies
- Last post
by Naomi Nosonovsky
- I am in a form which shows, i.a., an address and a billing address (in textboxes; record A). I skip down a few records (to record F), and the "skip" buttons (Previous, Next) have ThisForm.Refresh in them. So I figured that the textbox Value property would be updated. And the address textbox surely shows the correct address from record F. But, when I click on a checkbox that moves the add
-
- Calling a listbox from PRG
by Eddie N
- 4 Replies
- Last post
by Eddie N
- I put the following function in a PRG. It displays properly, but every time I call this function and click the list, it returns an arbitrary string, blank or otherwise. What should I do
Code Snippet
FUNCTION ASK_s
i = 1
condition2 = ssoundex (my_word)
frmShow.listbox1. clear
do whil i < 6 .and. ssoundex (my_word) = condition2
frmSh
-
- Private data Session for Prg Files?
by Sammy Adems
- 3 Replies
- Last post
by AndyKr
- Is it possible to set a prg file to a private data session
For most of my reports I have an associated prg file to handle
all the data processing, and then call the report to format the data the data
out on viewing\printing. I am currently using a DataSession class (basically a
form with a private datasession) that handles
theses report calls. Since the prg is called from a D
-
- Why _pageTotal always shows 1 ???
by Lightening
- 9 Replies
- Last post
by Tamar E. Granor
- in VFP9, I tried to use
use my table
report form test noconsole preview "Page " + TRANS(_PAGENO) + " of " + TRANS( _PAGETOTAL) But the _pagetotal value is always 1 although the report contains 4 pages. What is that
-
- Server-Volume Name ... Simple Solution Found
by Docpro777
- 9 Replies
- Last post
by Docpro777
- Dearest Friends, FoxMasters, Geeks and/or venerable MVPs,
Looking at Sys() commands, etc. I can't seem to be able to 'display' a name for the LAN Server(s). Sys(5) works for the "Drive" of course, but Sys(5) fails to be meaningful for a Server Name :
...eg. "DellDimension4300", "Martha", "Ivan", "MyLanServer", etc.
I've searched help files
-
- Detecting whether running as COM server
by Darren Woodford
- 2 Replies
- Last post
by Darren Woodford
- Is there a way for VFP to detect whether or not it is running as a COM Server I can't find a SYS function or anything that will tell me this.
I am doing some testing and debugging within the VFP IDE and the COMRETURNERROR function keeps complaining that the feature isn't available so I would like to use an IF statement to raise errors differently when not running as a COM server.
Man
-
- OLE object error
by gamease
- 12 Replies
- Last post
by Naomi Nosonovsky
- Hi,
I get the error : OLE error code 0x80040154. Class is not registered. OLE Object is being ignored . I get this error when i run a form which has a pdf document in VFP 6.0.
If my computer has only installed the acrobat reader with version 6.0 or before, there will be no error occured. But when my computer has installed the acrobat reader with version 7.0 or later. The error will appear.
-
- image resize
by NILKAMAL
- 7 Replies
- Last post
by Naomi Nosonovsky
- hello!
i ceate simple form with image now i want to image resize in my imagecontrol can i do that also how do i do to change background color of my application
thanks