Search results for query: *

Hi Niki, The easiest way would be to create a cursor using UNION and then pull the data. So just combine two queries (your variable "stra" has in one UNION in between). The second "stra" will look like stra=stra+" UNION " then the rest ... Thanks Ljupce

No issues, neither any settings needed if native dbfs reside on shared server and exe's on local PC's.

Hi Mandy, We do not see when and how you open table rek. Maybe for quick test try after last replace to close and reopen the table Use in select("rek") Use rek in 0 alias("rek"). Hope this helps

Hi, Unless there is tab-chr(9) within the string it should fit into one cell. Can you try: oSheet1.range("A1").value='^'+'"'+_cliptext+'"' Thus we will force it (even if the string contains digits) to be accepted as a character string. Any specific reason to use Paste() to populate single cell?

Can you try: oSheet1.range("A1").Paste() or oSheet1.range("A1").value=_cliptext Should work.

These are not native VFP options. They are rather small executive files which can be called externally from VFP. Please search for pstools.

curl or pscp can do that.

Siraf, As Olaf mentioned for fast conversion go to C/C++. If an EBCDIC file contains packed fields you'll have to describe each column starting and ending position and, therefore, overall record width.

Thanks Mike, but I have to stay on free tables bulk created on fly.

Thanks Mike, please check my next post.

Hi guys, Has anybody figured out how to relate values in expr fields for FRX field name (objtype 8) and it's appropriate label (objtype 5). For example objtype 8 expr='inv_no' and objtype 5 expr='Invoice Number'. This can be helpful when exporting to Excel to show labels rather than field...

Olaf and Mike, thanks for your input. Your confirmation made me check my Adobe installation. It turned out to be corrupt and after reinstalling Adobe everything works well.

Hi experts, Can somebody help with VFP 9 OLEObjects adding pdf file to Excel (2007 and up)? The following code works with doc files but not with PDF's: afile=getfile('doc') oExcel = CREATEOBJECT('Excel.Application') WITH oExcel .WorkBooks.Add .Visible = .t. with...