Search results for query: *

Update. let me show you the code: SELECT SEQUENCE AS RECORDID,; LEFT(BARCODE,11) AS POSTNET,; CODECHAR AS IMB,; SOURCECODE,; '' AS GREETINS,; NAME_FIRST AS FIRSTNAME,; '' AS MIDDLENAME,; NAME_LAST AS LASTNAME,; '' AS SUFFIX,; MAILNAME AS FULLNAME,; '' AS...

Well hell. the app processed 6 files correctly then once again gave me the same error message. I applied the READWRITE and everything looked fine then BOOM. it started doing it again. there are 800+ gigs free on the target drive so it is not running out of room. hmmm gotta take a different tack.

I thank you all for your responses. after a lot of testing and code wrangling I got it to work,. I was using select statements into tables so that I could make changes to the table before copying it out. I changed the tables to cursors and commented the changes as cursors do not allow writing...

I have an application that writes many different files and types across the network for many different departments. two of them have stopped writing and is issuing the error message of "Unable to output file". I have changed the directories and the drives and get the same messages. These should...

Gentlemen, I have taken your advice and created a method to create the table structure string in memory and then used EXECSCRIPT() to create the table. My thanks! It is much more efficient. As to the different structures, we have perhaps 50 to 60 clients that all have their own structures and...

Jack and Olaf, Thanks for the great insights. COMPILE worked like a charm. Jack, I am creating the .PRG on the fly due to the myriad of file structures that we deal with on a day to day basis. These structures use long field names and I needed to shorten these to unique usable table field...

Mike, I added the message boxes JUST before THE DO command. =MESSAGEBOX(TMPPRG) TMPDIR = SYS(5)+SYS(2003) =MESSAGEBOX(TMPDIR) The file I am choosing is s:\jobs\14865\1\14865-1PS.TXT TMPPRG is S:\JOBS\14865\1\MAKEDBF.PRG TMPDIR is S:\JOBS\14865\1 So the above is all correct. I just ran JUST...

Mike, Yes, I added the redundancy when the error started popping up. Trying to cover all the bases. In developement mode, I can clearly see the current directory is correct. I will try the messagebox() in the executable and see what it tells me. I will keep you posted. Thanks! Fred Fattore

Hi Mike, I watch the directory very closely and the file is in the right place. I set the default to the working directory and use the path in the DO command. During debugging I check the current directory just before the DO command is executed and it is correct. I have checked the path to make...

Friends, I am writing a program that takes a standard Tab Delimited Data file and creates a table from the long header names. It creates a file called MakeDBF.prg, which I then "Do MakeDBF.prg". When I use Set Step On and debug the executable from the command window in VFP 9.0, all works fine...

Mike, I am using VFP 9.0 and I do indeed issue the SET ENGINEBEHAVIOR 70 and in testing it works very well. I have been using this process for quite a while now, so there is no PROBLEM so to speak. The "SELECT KEY, COUNT(KEY) FROM TMP GROUP BY KEY HAVING COUNT(KEY) > 1" statement only returns...

I have read many of the posts here regarding SQL select statements for de-duplication of tables and I wanted to get everyone's opinion of the method that I use. The table TMP, has the fields: name_first, Name_last, Address1, address2, city, state, zipcode All addresses in the table are...

Tamar, You are right. I removed the control source and all was fine. It was just at first the service code was not being assigned to the variable for later use. Thanks for the response!

Hi All! I have a combobox linked to a table of services and their respective codes. The rowsource is the service for the combobox. The controlsource is the service code. When the particular service is selected the service code is correctly assigned to the variable tmpservicecode but the data in...

Hi all, Has anyone used this function? I have an invoice type file in XML and I want to be able to convert it to a table for USPS Presort processing, then create a report for printing the invoice. So far all it does is put all the data into a string and into one field called t112. Here is a...

M, Quick and dirty... Create a table with one field at about 120 to 240 length of type char and append from your text file TYPE SDF. then you can do string searches for splits or just copy to (filename1) for recno() <= reccount()/2 copy to (filename2) for recno() > reccount()/2 If your...

Thanks Brian & Chris. That's what I was looking for! 8) Fred

Jimoo, I did try changing the last parameter to 0. It did not stop the print dialog from opening. Thanks though, I appreciate any and all input!

Greetings! I have an app that is processing and printing over 1100 html documents and I am using: DECLARE INTEGER ShellExecute IN shell32.dll ; INTEGER hndWin, STRING cAction, STRING cFileName, ; STRING cParams, STRING cDir, INTEGER nShowWin =ShellExecute(0,"PRINT","MyHTML.HTM","","",1)...