Search found 19 matches

by dbish
Tue May 11, 2010 12:01 am
Forum: Freebasic Questions & Answers
Topic: Problem passing variable to FB file in Win7
Replies: 1
Views: 11256

Actually, I just ran it again and the debug statement (first in FB portion of post) came back $CL= 20100507 so the extra space is showing up in the original pass.
by dbish
Mon May 10, 2010 11:58 pm
Forum: Freebasic Questions & Answers
Topic: Problem passing variable to FB file in Win7
Replies: 1
Views: 11256

Problem passing variable to FB file in Win7

I recently had to replace my aging XP machine with a Win7 64 bit box. Freebasic still works fine but I discovered a strange error. I use a batch file to get user input (a file date), decompress a zipped data file for that date and then call a freebasic executable to do the processing. I am trying to...
by dbish
Mon Feb 01, 2010 3:10 pm
Forum: Freebasic Questions & Answers
Topic: Counting fields in a record
Replies: 6
Views: 18421

Thanks - this will work great!
by dbish
Mon Feb 01, 2010 10:17 am
Forum: Freebasic Questions & Answers
Topic: Counting fields in a record
Replies: 6
Views: 18421

Good Idea. I was hoping there was a single command like PARSE (I just made that up) or something that would do it in one pass but this could work. I am assuming I would do this in some sort of loop like: COMMACOUNT=0 FOR i = 1 to LINEDATALENGTH-1 if MID$(LINEDATA,i,i+1)="," Then COMMACOUNT=COMMACOUN...
by dbish
Sat Jan 30, 2010 2:08 am
Forum: Freebasic Questions & Answers
Topic: Counting fields in a record
Replies: 6
Views: 18421

Note to moderator - if this should be posted in the Qbasic forum please feel free to move/copy.

Thanks
by dbish
Sat Jan 30, 2010 2:03 am
Forum: Freebasic Questions & Answers
Topic: Counting fields in a record
Replies: 6
Views: 18421

Counting fields in a record

I am using the FreeBasic compiler but I suspect that Qbasic techniques would also help me here. My FB programs currently read in a CSV file that is approximately 300,000 rows by exactly 19 data items per row. I first use a Line Input routine to determine the number of rows and then read the file seq...
by dbish
Mon Jul 04, 2005 6:59 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: Efficiency suggestions
Replies: 6
Views: 6339

Thanks for adding the code tags. I am fairly happy with efficiency. (I have compiled it with FreeBasic) The data file that gets read in has approximately 160,000 lines of comma delimited text. My program loads the whole data file into an array and determines which lines of code are associated with e...
by dbish
Sun Jul 03, 2005 7:42 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: Efficiency suggestions
Replies: 6
Views: 6339

Nathan1993, I am not sure what you mean by code tags. The original post was from three months ago and I am using the code in production currently. I was just thinking that there were some glaring errors that someone might spot. I am not a programmer by occupation - just a finance guy trying to solve...
by dbish
Mon May 09, 2005 3:17 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: Efficiency suggestions
Replies: 6
Views: 6339

Efficiency suggestions

My project has evolved to the point where my base data files are cleaned up and I now need to process daily updates. The update file is comma-delimited - 19 columns and about 140000 rows (this number varies and has been slowly growing). I look at each Ticker Symbol and calculate a weighted average o...
by dbish
Fri May 06, 2005 1:02 am
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

HOORAY - I CAN CALL EVERYBODY OFF. No, I don't know what the problem was but I stripped the code down to the smallest initial part I could and ran it. Added the next few lines, etc. Found that FB didn't like something around the ((val(TKR_NEW$(i, 3))/val(TKR_NEW$(i,4))))<.8 lines (this is slight cha...
by dbish
Thu May 05, 2005 2:11 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

I have hived off the Exception report processing into a separate program which should be small and easy. I am still getting the same "won't compile error". New, smaller code as follows: ------------------------------------------------------------------------------------------------------------------...
by dbish
Thu May 05, 2005 12:58 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

My project has evolved to the following: First, I have distilled 2 million stock market related data files into 2400 files of the name form TICKER_OI.csv and TICKER_VL.csv. I download a daily data update file which is 140000 rows and has new data to update the 4800 TICKER_xx.csv files on my computer...
by dbish
Thu May 05, 2005 12:28 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

I looked closer and changed the DIM parameters on my big arrays - I probably don't need them that big. I don't see that this is a memory resource error. Why would it compile when the TKR_PREV array was (5000,2) and not at (5000) one dimensional? This feels like something else. When I get a chance I ...
by dbish
Thu May 05, 2005 11:25 am
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

Hi there MystikShadows, Yes, I do remember you and your previous suggestions have been very helpful indeed. As far as optimizing my routines - it is not really necessary. I am starting with 2 million files and distilling them into what I need. I am taking it one step at a time - write code, test, ru...
by dbish
Thu May 05, 2005 8:45 am
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

I have plenty of memory (768 Mb installed - won't compile with even minimal other apps open). Here is complete code: ------------------------------------------------------------------------------------------------------------------------------------------------------------ OPTION BASE 1 DECLARE SUB ...
by dbish
Thu May 05, 2005 1:14 am
Forum: QBASIC and QB64 Questions & Answers
Topic: "Unknown error-can't save file" FBC dies on compil
Replies: 10
Views: 10172

"Unknown error-can't save file" FBC dies on compil

I have been working on a major series of data manipulation Freebasic programs. Most are single purpose and then I move on taking snippets of code from program to next. On my latest I have been developing a major routine which worked fine until I made one change and now FB IDE freezes when I try to c...
by dbish
Wed Apr 13, 2005 7:40 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: Trouble reading CSV files with QBASIC/FreeBasic
Replies: 6
Views: 9566

I have made it through the first part with the replacement of WRITE with PRINT. MUCH MUCH better. I recreated the data files and they worked perfectly. Now, I need to move onto the reading using your second set of Routines. Thanks so much for the code you sent. You reply was posted within a short ti...
by dbish
Wed Apr 13, 2005 12:40 am
Forum: QBASIC and QB64 Questions & Answers
Topic: Trouble reading CSV files with QBASIC/FreeBasic
Replies: 6
Views: 9566

Thanks for the quick reply. I will need some time to get through all your suggestions and try it out. Thanks - I'll be back!
by dbish
Tue Apr 12, 2005 8:02 pm
Forum: QBASIC and QB64 Questions & Answers
Topic: Trouble reading CSV files with QBASIC/FreeBasic
Replies: 6
Views: 9566

Trouble reading CSV files with QBASIC/FreeBasic

I am in the middle of a large project involving simple manipulation of a large number of files (related to stock market ticker symbols). I first read the raw CSV files and extract summary information and which I write to new CSV files. I have a massive amount of data to read in and process. Order of...