I have also been in direct mail.. for some time.. over 30 years. EBOUGHEY is right, no better product exists than personator, I use it all the time with the best results of any program I have tried. Its worth paying for if you are working with large or multiple files. The only time I find a need...
I know it must be a simple answer
select * from maintable;
where maintable.dr<>dtoc('01/06/54');
inner join zmake2 on zmake2.make = maintable.make;
inner join zenter2 on zenter2.czip = maintable.zip;
I am not putting the where clause in the right place. This is doable, right? I've tried...
Oh. they were created specifically for file names? Stem and extension....thats interesting.. it's fun to learn new commands that are useful. I still find it hard to believe its the first time I've seen it. Thanks for the explanation. :-)
I'm trying to talk my boss into a big donation to this...
this I understand
x="master.pkey"
?left(x,atc(".",x)-1)
?right(x,len(x)-atc(".",x))
This function has me baffled.. it works..but how? I think I have other uses for it.
? juststem(x)
? justext(x)
a function I cant find in my books
Jered.. its not pretty, but it seems to work. Try this
set deleted on
SET SAFETY OFF
SELECT automaster
select _zips
locate for zip =ZENTER3.Czip
store str(longitude,8,5) to long
store str(latitude,8,5) to lat
STORE SUBSTR(ZIP,1,5) TO MZIP
SELECT passedzip
REPLACE LATITUDE WITH LAT
REPLACE...
Yes, I copied the code. I found it on the net, still trying to create a program that determines zips in a radius.. this is what I copied.
* THIS VARIABLE SETS THE RADIUS IN MILES
iRadius = 150
LatRange = iradius / ((6076 / 5280) * 60)
LongRange = iRadius / (((cos(cdbl(iStartLat * _...
LongRange = iRadius / (((cos(cdbl(iStartLat * _
3.141592653589 / 180)) * 6076.) / 5280.) * 60)
(cdbl
is not recognized (vfp 6.0)
Is there an alternate statement to replace the cdbl with?
that last looks workable with my limited knowledge, but doesnt there have to be a value for zip= nzip? Something looks wrong. Maybe I will work with it. thanks all fro trying
My master data contains all zip codes in the US and all longitudes and latitudes assciated with them.
My working database contains the fields zip, longitude and latitude as well as other data.
Has anyone heard of code that will allow me to determine the distance from one zip to another zip. My...
I've been playing with this code for my own purposes and was wondering something... when table a has say 10000 records and table b has maybe 1000 records that contain the value to be replaced, why does the odometer register 10000 record replaced and not 1000?
I thought putfile() would work.. but it gives on option to save as a dbf file and I am getting complaints. I'm using vp6.0
I wonder if there is a better way to allow someone to save the results of a query to table to wherever they want, with any name and not be complicated about it. The export...
Another related question to using indexes, with SQL select statments and very large databases, will indexes speed up the results by a substantional margin? If its re-indexed to a temp.idx each time, it seem that you trade off.
Thanks.. the inner join statement escaped me cause of a brain fart I suppose.
I am rethinking this thanks to Jim... it is a very large database... the final compilation will be over 4 million records and just dealing with the shear size alone is a challenge in itself. I'm using these...
I have three tables Zenter which contains only 2 zipcodes, Zmake which contains only 3 makes of autos and Automaster with contains 1,900,000 records which includes a persons zip and the make they own.
Shouldn't the following display all the zips and makes associated with the first two tables...
Is there a way to force the export to dialoge box to appear from within a form with a button click? once a query is produced into a table, I want the user to have the option to save it in the folder of thier choice. Any ideas?
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.