Search results for query: *

Dear All, I have constructed a pivot table view based on an Access 2003 query. As the pivot table view is the view in which the users want it (for possible manupulation) I would like to direct them via form straight to the Pivot Table View based on a query. My question: What is the VB handle...

Thanks Olaf, Also very good advice

Thanks Mike, missed the bit where it said Field OR FILE size... Note to self, read better!!! :)

Hi there, Hope someone can help me. Is there a quick way (ie function) in determining what the is size on a disk of any given table in VFP 9. I.e. 'c:\tables\table.dbf' size is ....... kb/mb/gb I need to know this to create overflow tables when my VFP tables max out at their 2GB limit. I...

Mike, Thanks for the reply! I tried the key without the alltrim and that didn't work at all. Thats why i added the alltrim. I tried it again - and viola - it works!! Thanks so much. I think that the problem lies in the variable Prakcode, it is not of a fixed length. Anyway - thanks!!!! Cobus

Dear All, Thanks for all the previous help! It has brought me 6 months further in the research we are doing! My problem in VFP9 I have two tables (A an B). Both contain similar data and have excactly the same structure. Only difference between them is Table B contains newer added records...

Thank you all for the posts! I have read my original post and apologize for the lack of clarity in the question. To clarify the problem: The ID's vary from numeric to text. They represent a location. The result I need is something like this if the original table is this : ID, date, sequence...

I have a problem with a large table with redundant data (>1GB). The table looks something like this ID, date, sequence number, details 1, x , 1 , aaaaa 1, x , 2 , bbbbb 1, x , 3 , ccccc 1, x+1 , 1...

Bill, Thanks for the idea! I have two problems - the files are greater than 100MB and contain commas :-(. But what I can try is the to transfer use strtrans to first convert the commas to asterikses or something like that. Any ideas on how to chop the files into chunks smaller than 16MB...

BTW, The Foxpro Import Wizard does a great job with importing files. However - there is very little in the code section to suggest doing the same thing at runtime, automatically. Does anyone know where the code for the VFP import wizard stands? I ask this as a newbie in this regards - maybe I...

Thanks Mike, The problem is the order the of the fields getting import into the record is wrong. I.e. in the file structure the fields are listed as follows - my_code, code, date, decis The text file follows the same structure. However when it is imported with append to the date field gets...

Thanks to all who have helped in my previous question - that solved the problem instantly - the problem was here http://www.tek-tips.com/viewthread.cfm?qid=1067033 I have a tabel structure created from various (100+) delimited files. I know this is not ideal but I have to work with what I have...

I have a problem that I am sure I am not the first to come across. My data is generated from Mumps into delimited text files. I cannot change that. I have over 100 tables with 50 variables in each. VFP9 can import text files with the import wizard but that will force me to repeat the process 100...