What I would like to do is get the sample procedure below to send my cell phone an email instead of 'cancel'. Any ideas on this?
sample procedure
PROCEDURE hand_err
PARAMETERS zerror, zcmess, zcmess1, zprog, zlineno
PRIVATE zerror, zcmess, zcmess1, zprog, zlineno
DO CASE
CASE zerror...
Does anyone know how I can speed this up? Its just not cutting it anymore with 2,000,000 record lists. Its just a simple program that finds two records with identicle phone number fields and tags them both with "X" for deletion when completed. It would really help me out....
Thanks,
Ross...
My code works fine when SQL returns a record but when it does not I get an exeption error. Any Ideas?
Set objConn = Server.CreatObject ("ADOB.Connection")
Connstr = "Driver=Microsoft Visual Foxpro Driver; etc...
objConn.Open Connstr
Set objRS = Server.CreateObject ("ADOB.Connection")
strSQL =...
I have a form where have the user enters their username.
But when I check the Request.form("login_username") against the objrs("username") in my table they don't match because the one pulled from the table has a space after it.
I found the space by doing a Response.Write objrs("username")...
The .prg file below is running over and over again on my cpu...(for hours)... anyways sometimes after lets say 4 or 5 hours the program halts and I get an error message at
select * from /u/server/dstore/data/mainapps.dbf where recordid = datetime into table /u/server/dstore/data/tempapps.dbf...
What is the best way to make my foxpro program wait for a specified number of seconds without any output to the screen or requied anykey pressing.
Why doesn't this work?
WAIT CLEAR TIMEOUT 1
I have a program that ftp's information from unix sco to my nt server. It is a simple program, that is set up to just keep running until I kill it. It simply looks for new records and sends them over via ftp then deletes the records it just sent, so it doesn't keep sending the same records, just...
The string below works in foxpro8 but I need to get this to work in 2.6 for unix. Obviously my directories are different from going from NT to unix, but that shouldn't matter. I am thinking that 2.6 just needs this string entered in differently...
PLEASE HELP ME FOR THE LOVE OF GOD...
I need fox to simply delete a file such as c:/datastore/test.dbf without using it. Just to simply remove it off my hard drive.. without using the command
delete file c:/datastore/test.dbf
Thanks,
The person who hates the delete file command.....
How can I get a variable to equal the time combined with tht date.
vartimedate = vartime & vardate
vartimedate = time() & date()
End with something like this:
12355603082004
for this time and date
12:35:56 03/08/04
I need to open a connection to a database that may be in use by another program and unavailble to my asp page.
Could someone show me an example on an If Then or somthing that would allow the page to wait for the file to be availble and then open it?
Or if you know of another post ... which I...
I have a table called usertable that is accessed by a webpage via asp and VFP ODBC driver. I need to have foxpro running in the backgroup putting new records into this table. I can't get it to do this without opening the database as exclusive. But when I do this ... the asp page comes up with a...
I am tring to write a simple program that will grab all the records from filea.dbf, import them into a fileb.dbf, then go back to filea.dbf and check for new records every five seconds grabbing only new records since the last time it checked the file....
any ideas?
Thanks,
Ross
I am opening a database and updating records; What command could I type to close out a database after updating it? Is their a way to open the database shared?
Ross
"life is like a box of chocolates, you never know what your gonna get"
-Forrest Gump
The command below returns a blank box instead of the variable I need. Can anyone help me here?
fullname=request("fullname")
strSQL = "update usertable set fullname = '"& fullname &"' where phone='5073405577'
strSQL = "insert into usertable values ('fullname', 'address', 'city', 'state', 'zip', 'zip4', 'phone')"
**above is the sql string i am using. This string writes 'fullname' 'address' etc inside my table. I need it to write "BOB SMITH", "208 Jake Street" etc inside...
I have a table that I would like to access from a webpage. How do I go about doing this. Obviously I would want to have a secure login ect. Could anyone point me in the right direction???
Thanks,
Ross
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.