So what was the problem? --- On Sun, 11/22/09, Sytze de Boer <[email protected]> wrote:
> From: Sytze de Boer <[email protected]> > Subject: Re: Appending problem > To: [email protected] > Date: Sunday, November 22, 2009, 8:23 PM > Problem solved > Thank you Richard and Tina, your input helped me identify > where the problem > was > > S > > > On Mon, Nov 23, 2009 at 11:43 AM, Tina Currie <[email protected]> > wrote: > > > > > Is it worth putting getfile( ) in there instead of the > filename??? - make > > the user point out the file they need - don't know if > this would change the > > way Fox looks at the file....????? It shouldn't make a > difference, but if I > > was you and going nuts, I'd be trying it. > > > > Also for comma delimited files I just say [type deli] > on the end of the > > appen instead of [deli with ","]. Again... > shouldn't make a difference, > > but > > if you want something to try... > > > > Tina > > > > ----- Original Message ----- > > From: "Sytze de Boer" <[email protected]> > > To: <[email protected]> > > Sent: Monday, November 23, 2009 9:14 AM > > Subject: Re: Appending problem > > > > > > > Yes, he see the file and see the contents > > > > > > > > > On Mon, Nov 23, 2009 at 11:13 AM, Richard > Quilhot > > > <[email protected]>wrote: > > > > > >> Have you verified that the client can see the > contents of the import > > file > > >> prior to tring to import? > > >> > > >> Richard E. Quilhot C.N.A. > > >> [email protected] > > >> > > >> > > >> Joan Crawford< > > >> http://www.brainyquote.com/quotes/authors/j/joan_crawford.html> > > >> - "I, Joan Crawford, I believe in the dollar. > Everything I earn, I > > >> spend." > > >> > > >> On Sun, Nov 22, 2009 at 5:08 PM, Sytze de > Boer <[email protected]> > > >> wrote: > > >> > > >> > Can anyone see anything why this doesn't > work ? > > >> > > > >> > create table temp (stockcode > C(15), qty N(10), supcode C(10), > > suporder > > >> > N(10)) > > >> > use > > >> > sele 900 > > >> > use temp > > >> > appe from FREETASK.UPD delim with "," > > >> > > > >> > When I do it on my pc, no problem > > >> > When I log into client using Remote > Desktop, no problem > > >> > When client does it, temp.dbf ends up > with no records > > >> > > > >> > I've watched it happen like this > > >> > I log in using RD > > >> > Me: Delete file temp.* > > >> > Me: Delete file *.UPD > > >> > > > >> > Him: Desktop batch file that > imports the barcode file from the BC > > >> > reader > > >> > Him: Import the file freetask.upd (This > is a bar code file, simple txt > > >> file > > >> > with 2 columns, code and qty > > >> > > > >> > Me: I can now see the UPD file > > >> > Me: I can now see the data in this file > > >> > Me: I can manually import this data or > through the program > > >> > Him: Opens Temp.dbf and there are no > records > > >> > Me: I'm going nuts > > >> > > > >> > It seems it chokes on the APPEND line > > >> > > > >> > -- > > >> > Regards > > >> > Sytze de Boer > > >> > Kiss Systems > > >> > Hamilton, NZ > > >> > Ph: 64-7-8391670, Mob:64 21 937611 > > >> > URL: www.kiss.co.nz > > >> > > > >> > > > >> > --- StripMime Report -- processed MIME > parts --- > > >> > multipart/alternative > > >> > text/plain (text body -- kept) > > >> > text/html > > >> > --- > > >> > > [excessive quoting removed by server] > > _______________________________________________ > Post Messages to: [email protected] > Subscription Maintenance: http://leafe.com/mailman/listinfo/profox > OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech > Searchable Archive: http://leafe.com/archives/search/profox > This message: > http://leafe.com/archives/byMID/profox/[email protected] > ** All postings, unless explicitly stated otherwise, are > the opinions of the author, and do not constitute legal or > medical advice. This statement is added to the messages for > those lawyers who are too stupid to see the obvious. > _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
