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...
I was / will be running into this problem in a short while on a page I have been working on. I want to have a comment box but can't write more than 254 char into the VFP database character filed. I was thinking about Just have some vbscript break up the text into chucks and putting it into...
What I am looking for is to have a new list with both records that had identical phone fields to be tagged a certain way. So I could:
1. know which records were duplicated
2. if a record was found more then once, they need to be tagged a certain way so all of the 5073455611 phone numbers can...
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...
Everyone thank you for your valuable posts. Especially you Craig, you have helped me learn that yes, people are taking up their valuable time, helping me out with problems when they do not even know me. I apologize for being selfish and inconsiderate of others and in the future will try to show...
Thanks onpnt .. you got me going in the right direction.
This works if the name doesn't exist in the database.
If objrs.EOF Then
Response.Write "Error EOF!"
Else
Response.Write objrs("name")
End If
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 am able to solve the problem with the trim function..
Response.Write (trim(objrs("username")))
But I was just wondering if there is a known setting in VFP that would cause a space like i am seeing... I guess I'll keep my eyes open for another solution, but for now the trim function has...
Perhaps... but I am using an ocbc connection to a Visual Foxpro database and the variable is output to a web page using asp and an sql string. So I thought this would be the right place... any sugestions on where to post is not here?
Do you know of any Visual Foxpro settings for padding?
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...
This is what I have ended up useing and it works great.
DECLARE Sleep IN Win32API LONG
Sleep(1000.0)
Thanks rgbean and wgcs
how come i don't need anything after LONG?
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...
I got a syntax error when I tried this on foxpro 2.6 on unix
INSERT INTO /data/tmp.dbf (fullname) SELECT (fullname) FROM /data/DATAFILE.dbf where phone!=" "
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...
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.