Search results for query: *

Thanks for all of the replies, again I'll clear up a few little spots! As for using an ado text driver or dumping into sql server I don't think this will be possible. A lot of the data is encoded and stored in odd formats that require converting into something windows is more happy with...

Hi all, my C's a bit rusty so I'm after a little help. I need to read in a text file of fixed length records and locate the various fields in the records. For example, one file has a record size of 937 bytes, the first field is 1 byte, the second is 25, the third is 3, etc. What is the...

Hi all, Here's an example of a definition file that will be read in: 1,STK-COMP,AN 15,STOCKNO,AN 25,STKDES1,AN 25,STKDES2,AN 25,STKDES2-INNERS,AN 5,STKGROUP,AN 15,STK-THEIR2,AN 1,STKVATCD,N 2,STK-COMMENTS,N 6,STKPACK,N 6,STKPACK-WEIGHT,C4 6,STKPACK-VOLUME,C4 6,STKSELL,C4 6,STKSELL-INNER,C4...

Jack - Great idea - not too sure if VB can do it though, I think it 'dumbs down' type conversion too much. I'll have a look into it. James

The structure would have to match the size of the record exactly or VB will throw an error. As there is no way to create a structure at run time and each file requires a different size structure, I cannot create a 'generic' structure to be used for all files. James.

Hi all, I'm trying to process some data files, I have around a gig of files in total. I'm using random file access as each file has a fixed record size. If i use a user defined data type with the get statement I can easily get a throughput of over 3,000 records per second. Great! However...

I'm trying to convert data from a file and after examining the stucture in a hex editor, the S9(9)V999 comp-4 is stored in 6 bytes. So does this stand?, would this be how 15 & -15 would be stored: <FONT FACE=monospace> +15 in PIC S9(9)V999 COMP/COMP-4 in memory looks like 00 00...

Hi all, I'm trying to convert some cobol 'comp' data types using VB or C. Some I've come accross so far are: 9(6) COMP-4 S9(9)V999 COMP-4 9(6) COMP Are there any routines out there for conversion already? I've written a conversion routine for the unsigned comp-4, but under VB6 it just...