Search results for query: *

Forget previous post. It would help if I had been looking in the folder I had written to. Now I don't know where I got the wk1 from... Oh well.

Hummmm... I just tried in FoxPro 6.0 to write out a table using the XL5 and got an extension wk1 spreadsheet. Does this only work with later versions of FoxPro?

Wouldn't it be a bit more like this? sele f.id,f.employes,sum(s.salary); from firsttblname as f,secondtblname as s; group by s.id; into dbf quarterly

Look at type() or vartype() in the help or Hackers Guide.

I have found with SQL that you can do the following to change a character field length. Select left(zip,10) as zip from mytable into dbf yourtable

Another product I have used for years is SmartBoard. It not only stores images from print screen but also handles text ( in almost any application) & meta-files. It's perfect for building training manuals and moving code around when writting scripts. Unlike the clipboard it does not overwrite a...

You have a character field (code) and a numeric field (autonumber). Try this; assigned_num=allt(code)+allt(str(autonumber))

Building on DSummZZZ's suggestion keeping the original table as is. use mytable alias my copy structure to newTable sele my scan mhowmany=my.countfield &&use your count field from mytable SCATTER MEMVAR MEMO FOR nCnt = 1 TO mhowmany INSERT INTO newTable FROM MEMVAR NEXT endscan

You may want to look at a third party product PhDbase. It's a 'fuzzy' compare/locate among other things. The soundex function gives some bizzar returns (like the same score for different words). You can find a number of hits on the web for PhDbase.

You might take a look at PhDbase a third party addon that does 'fuzzy' comparison/searches. I found a number of hits for this on the web.

The following should do it; Copy field agen,unit,ssn,tax1 to tax1 or select agen,unit,ssn,tax1 from table1 into dbf tax1

I had a similar problem when I moved (copied) FoxPro 2.6a to a Win 2000 fast Dell. I would try to start Fox and get a blink, no error message at all. The patch26.exe I downloaded from MS didn't work-gave me a "Baseline..." something error. However I found something called dzpatch...

I also started 'dbaseing' myself when dBase didn't have a number after it. One very helpful tool is the Hacker Guide to Visual FoxPro found at Hentzenwerke Publishing. You get hard copy and a help chm that puts MS helps to shame. It's always on my task tray to lookup some of the wonderful stuff...