Forgive my ignorance. Can someone explain the basics/benefits/fallbacks of Unicode database products versus say, my favorte, Foxpro. What is and where can I research a Unicode product?
Add to that, so many people making very, very complicated programs using Access. I have three projects going now that were created in Acess that are now hopelessly broken and no one can fix. Patches galore over time. I am simply rewriting the entire projects in Fox. Takes only a few hours, easy...
...because they hold more than one policy.
OK.. the code I used to fix the first problem... Please don't laugh, I had to do something QUICK.
*****************************
set safety off
use members
copy to table1
set dele on
select 1
use table1
copy to table1bak
close all
select 1
use...
I feel like I might be getting somewhere.
here are the revisions. However at this point.....
***
Insert Into donationsconsolidated;
Values (m.CName, m.Ca1, m.Ca2, m.Ccity, m.Czip, m.Ccountry, m.Cdate, m.Ccode, m.Camount)
***
I recieve a data type mismatch error... I can see no errors in...
...Scan
h = h + 1
atem[i,h] = temp.pdate
h = h + 1
atem[i,h] = temp.amount
Select temp
Endscan
************************
Clear All
Use table1
Select Distinct cName,city, state From table1 Order By 1,2,3 Into Cursor discursor
i = 0
h = 3
Select...
Glad I gave you a chuckle <grin>. At least you didnt break my puter. LOL
If I had my way I would be using a report but I am required to give the data to another department who will carry the ball from there however they want.
I will be working on this code this morning. I really appreciate...
...the .tmp file was too large at the line;
Insert values into donationsconsoldated;
Values(m.Cname,m.Cad1) Etc.
here is the code... any ideas?
****2/9/09
****code to create donor table for merge to letter
Select Name,a1,a2,city,st,zip,country,Date,Code,amount;
from members.Dbf;
order By...
Ok. Makes sense. Someone else told me I could not use SQL to make this work. I knew I would have to considate the data somehow though. It's a one time job and I just need to get the data together and send it to the laser printing department for print. I will try to pull together what you suggest...
I have a table of donors, the name and address is repeated up to 10 times with the date of the gift and the dollar amount of the gift different in each record.
John Adams 123 anystreet 9/10/08 $100
John Adams 123 anystreet 6/06/08 $50
John Adams 123 anystreet 3/15/08 $100
John Adams...
I checked out the above link. Thanks.
Upon copying pasting the code from berezniker's post to the command button (to edit the send, attachments etc.) I receive the following error.
"Methods and Events cannot contain nested procedures error"
Does this require to be run from a prg only as...
...for your help.
o=createobject("outlook.application")
oitem=o.createitem(0)
oitem.subject="Email From VFP6"
oitem.to="someone@testing.com"
** To send copy to addresses..
oitem.body="This mail was sent from vfp using Microsoft Outlook"
** To attach a file...
I currently use live cycle to create an interactive PDF form for our department schedules. What I want to do is create a form for data entry and export that from a report form to a PDF. Is there a way to create that PDF form to be interactive similar to the way Live Cycle allows me to do?
Can I...
I have not seen the letter of the law. I am under the assumption that if I were to generate 1,000,000 seperate strings or characters that they would need to be unique and not sequential, hence random. To test it I simply indexed unique. Duplicates were generated about a rate of 48 or so each...
I've read somewhere else about that point, starting with rand(-1). Fortunately this is not for a lottery. Its for a retail chain that is going to hold a sweepstakes. the law says the numbers must be random, that is not a problem now with the above code supplied by Mike. I will add the -1 to the...
I didnt think anything that easy would work! So if my data contains a field bnum with "F6X32K3AA"...
replace field chk with Left(SYS(2007,bnum),1) will give me a valid check digit, right? Its critical I am right about this.
Thanks for your reply. Happy new year!!
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.