Search results for query: *

OP's original premise is off. There is not a 1:1 correlation between a UK postcode and an address. A UK postcode will generally break down to the "postman's walk", similar to a US ZIP+4. With the postcode AND a street number, you'll most likely get a hit. I've done something similar with USPS...

SELECT myTable COPY TO a:\myDirectory\mySubDirectory\myTable or SELECT myTable COPY TO ("a:\myDirectory\mySubDirectory\"+ALIAS())

Check this thread : thread184-1633357 I follow these steps Use oledb to import to a cursor of memo fields. calculate the max used length of each field(n). if it is less than 255, then alter the field type to a C(n) for each field, find the first non-empty data, most often than not, that is a...

Assuming id is unique... Select hgroup,min(level) as level from yourtable group by 1 into cursor s1 Select yt.hgroup,min(yt.id) as id from yourtable yt inner join s1 on yt.hgroup=s1.hgroup and yt.level=s1.level group by 1 into cursor s2 Select * from yourtable where id in (select id from s2)...

Based on a minimal number of fields: salestk, profit, tradeinstk SELECT salestk as rootstk,* FROM deals INTO CURSOR temp1 READWRITE DO WHILE _TALLY>0 UPDATE t1 SET t1.rootstk=t2.rootstk from temp1 t1 inner join temp1 t2 on t1.salestk=t2.tradeinstk AND t2.rootstk!=t1.rootstk ENDDO SELECT...

Check out the Microsoft sysinternals utilities. In particular interest are Process Explorer, which will allow you to determine which files a process has open, and psfile which allows you to determine which users have files open. This may not help if the culprit is anti virus software, as I have...

If all you're looking to do is create 2007 style worksheets, and are not worried about formatting and the other options that OLE automation allows, then take a look at Craig Boyd's posting at sweetpotatosoftware...

One thing to be aware of when using the Outlook attachment directory is that the file names will not necessarily match the attachment file names. In the case of the same file name being attached to multiple emails, the name in the attachment directory will have " (x)" where x is between 1 and...

I want to say to order the conditions by their probability of hit to make use of logic short-circuiting, but I can't say that the speed increase would be that noticeable.

The way you describe it, a particular DWG file should be in ONE of the folders, although there is a possibility that it may be in several of the mapped drives. For each of your mapped drives: Use ADIR() or parse a DOS/CMD DIR /b/ad command to get a list of correctly named folders (put them in...

I've tried all sorts of methods to export DBF files to Excel, to work with large datasets and include memo fields, and I've recently worked on another way of exporting: Using Excel 2007's own 'Import Data' functionality. So the process is : 1. Create DBF file 2. Automate Excel to Import that...

"I before E, except after C", is supposed to be used only for the long 'ee' sound. believe, retrieve receipt, deceive, receive It's not supposed to apply to the 'eye/aye' sounds. height, neighbour There are still exceptions: either, neither (although they can also be pronounced with as 'eye')

Yes you can use Excel automation, but the speed of running that code is prohibitive when compared to OLEDB/XML Try running that on a sheet with 50 columns and 150,000 rows.

Unfortunately, there are some characters that are valid in excel sheet names that are not valid as an oledb table name. Rather than try to translate between the two different sets of legal characters we use automation to rename the sheets to translate1, translate2, etc. before the actual...

ldDate=DATE() && assign a date lcOutText=CMONTH(m.ldDate)+" "+TRANSFORM(YEAR(m.ldDate)) ? m.lcOutText If you just want the shortened month name, use LEFT( CMONTH( m.ldDate), 3)

Weird that the author would use the basechars string to encode, but not to decode (using AT())

I don't know the base64 specs, but: + = CHR(43), so ch = 43 This falls through the nested IIFs, assigning -1 to q, which appears to be a terminator. The function is expecting the terminator to be the '=' character (ASCII 61). Any other character just forces the function to return an empty...

Without getting into verifying the excel file itself against the BIFF5/7 specifications, I'd suggest importing the file to a temporary cursor first with error trapping. If the file imports to the temporary cursor without errors, then append to the main table. llOK = .T. TRY SELECT...

RECCOUNT(), not RECNO()

Just had flashbacks to my teenage years... Yes those are Epson control codes. http://www.atariarchives.org/epson/appendix_b.php I don't recall "invert" as being a control code. When I did it, I set the printer to graphics mode and set the bytes by hand. Have you tried another method such as...