Search results for query: *

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...

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?

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 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?

I tried to find the answer in here... but... what is the difference... or better yet the advantage to using tags for indexes as opposed to just using "index on cfield to whatever" ? Do straight indexes require reindexing and Tags do not? Thanks

I am stumped. At work I use ver 7.0 I have two simple tables, Input and models. Table A with a field called Lmodel. Table B with field called model. Both tables have a field populated with the word ACCURA. I checked the spelling very carefully also. When I issue the following: select 1 &THIS...

We deal with many files that have hypenated names such as King Oldsmobile-honda. I have seen but cant find again funtions or snippets to conver Oldsmobile-honda to Oldsmobile-Honda. Does anyone know of a function or small program snippet I could use to convert these pesky hyphenated names...

INDEX ON STR(SKID)+STR(BAG)+STR(PKG) UNIQUE TO TANK descending all three are numeric and 9 digit with no decimal. what am I missing to make this work? I get an error each time.

Using SQL statements I find it easy to add and drop fields in a table, but does a statement exist that only changes the field width? As an example, the field width of the zipcode is currently c(5), I want to change it to c(10) so I may populate it with the additional zip+4 digits.