Yes Mike, this is what I needed, and It works for the scroll, and the other controls I put a timer that turns back the focus to the input field, it is not solid solution, but it works.
Thank you Mike.
Tony Lama
Admigha SoftHouse
That's what is happining, but in some case the user gets to a grid to scroll or to view extra data, in this case it is difficult to know when the barcode is starting again, I have to know that is typing (scanning) in a protected field, This trigger is the question.
Tony Lama
Admigha SoftHouse
Hi,
I'm using a form with some readonly fields and Grids,
One input field is used to receive barcode scanning.
Some times the user gets focus on the Grid, and without returning to the INPUT Field, he starts to scan, which leads to a sequence of beeps.
Is there a way to trigger the scanning...
I KNOW THAT using select can reduce the speed, but why for one run it takes twelve times more than subsequent runs?
I worked around the problem, and I solved it by indexing the big table, which I did not want to do from the beginning.
The new index is custid+date_sc (date_sc represents the...
all names beginning with m are variables
field to update in bilstmt is:TOT_PMT
fields to get from invoices are :CC1, CC2, CASH and DATE not "date()" to compare to variables MDATEF and MADTET.
I will try to split in SQL statements, and give you an answer.
Tony Lama
Admigha SoftHouse
Hi Olaf,
You are right about the Scan vs do while and the WAIT WINDOW NOWAIT, but this does not affect too mutch my procedure because it's displaying the message at the parent level which is a small table.
Also, the big table is local and not on the sever.
Tony Lama
Admigha SoftHouse
Hi,
I have tested the program with scan-endscan but it was slower than do-enddo
and I tested with SET RELATION, and also it was slower even in the subsequent runs.
I tried to just read the table without any updates or conditions:
Do while not eof()
skip 1
enddo
It took long time (more than...
Hi Tamar,
I have one small table called BILSTMT which have custid, and I want to update the field Total payments TOT_PMT from the huge table called INVOICES, this one has an Index on custid, the update must be done if the invoice date is within a given range.
Thanks for replying.
Tony Lama...
Hi, I'm reading a table of 600.000 records to update an other table, for the frst time read within the same foxpro session it takes more than 60 seconds, the second time it takes less than 5 seconds. Any help?
here is the procedure:
SET ORDER TO CUSTID IN invoices
SELECT bilstmt
GO top
DO WHILE...
Hi Olaf,
As I mensioned, It is working fine on the computer using Outlook, but on the other computer not having outlook it doesn't work, it may need some MAPI components to be installed.
Tony Lama
Admigha SoftHouse
Hi Olaf,
In fact, I was looking for a solution either in Outlook or OE, the solution you gave me is good for outlook, and it didn't work on Outlook express, If I find the solution I will let you know.
Thanks again.
Tony Lama
Admigha SoftHouse
Thanks OlafDoschke,
this is exactly what I was looking for,
I tried it and I helped me.
Thanks again.
Tony Lama
Admigha SoftHouse
Tony Lama
Admigha SoftHouse
How Can I Save Attachment w/o openning Outlook Express in VFP9?
knowing that I'm using CDO to send e-mails via FoxPro.
thanks.
Tony Lama
Admigha SoftHouse
thank you verry much white605, it helped.
for others who have the same problem they can use the following in VFP: loMsg.Attachments.Add.ContentTransferEncoding="base64"
Thanks again..
Tony Lama
Admigha SoftHouse
I think it is a matter of data type, but I don't know where to specify that the attachement is Binary intead of text. any help?
Tony Lama
Admigha SoftHouse
Thanks for replying,
But I used the zipped file locally, it opens normally.
Knowing that I tried winzip and pkzip and I had the same result, corrupted file on the receiving side.
When I send the same file using any other e-mail program I have no problem.
Tony Lama
Admigha SoftHouse
Can we automate IE in VB6, like moving to tabs and passing values to text box, for now I can use the address box, the back and forword keys and the window size. Any Help?
Tony Lama
Admigha SoftHouse
I'm using this: Createobject("CDO.Configuration")
to send e-mails within VFP9 application, it works fine
But when I send zipped attachment, the file is received corrupted.
System:WindXp pro, VFP9, AVG anti virus
Any suggestion?
Thanks.
Tony Lama
Admigha SoftHouse
You may run a neverending program in the background, which checks every an amount of time you specify, the time of changes and you update your database and if you want you change the word document subsequently.
Tony Lama.
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.