Recent content by BillPSU

I have a program which imports .txt files from a mainframe download directory and imports this data into SQL 2008 tables. The file names are contained in the importing database in a file location table. It lists the file import URL and the import table location. The file sizes generally are...

If your time stamp must be based on the local time you will have issues with people traveling. Someone from New Yord travels to California with a laptop. How do you control the time stamp? Bill

Code 3 of 9 only has 43 characters available and none of them are alt or ctrl characters. Generally speaking barcodes are data driven not control driven characters. If you want to have special characters to do special thing then you will have to write a program to use the character strings you...

I am listening to all the heartbreak these massively complex spreadsheets cause and feel the pain everybody is suffering. The real solution is to stop using spreadsheets as databases and convert to a true database. The spread sheet linkage rules and single user usage make it difficult for...

Another approach is to send the printout to Microsoft Office OneNote. It will capture the printout and you can include it in any document you want as a jpg or a png image. Bill

First, a .dbf file will transfer into a table within an .mdb. Second, what is the source of the .dbf is it dBase or VFP or another xBase? A dBase file can be linked or imported. A VFP file must be linked but I am not sure with what as I have never done that.

The following is from the dBase 5.0 language reference as an option to the BROWSE command. 'FREEZE confines you to one field or column in the file. If the field has been made read-only, you may not edit it. Other fields in the field list or database file table can display on the screen if they...

On another topic I wondered why MS gave the import functionality of importing from individual worksheets in Excel yet exporting to worksheets requires COM functionality. Why can Excel open a dBase .dbf yet fails to open a Foxpro .dbf?

Do a search in Google for sector editor. Its been years since I did any of this type of investigation and I did not have good results. I am not sure how the current operating system read/write data to the disc.

If all else fails read the file with a byte editor and look at the record where the file stops copying. Compare it to the previous record and see if they are encoded the same. You may be able to salvage the file using this approach. If you can't read the data then there probably problems with...

Whoever has the database will have to find the file. It could be an .mdx file also.

The index is a seperate file in dBase. Access should allow you to still import the data as the indexes are completely different between the two applications. You can then build your own Access indexes.

I can think of (3) ways to get your file imported. Open the file in WordPad and do a replace the "|" with a comma. Depending on the file size. Create a new database and import into a single field and parse the field into individual fields. If the data is longer than 255 characters create...

In the past using a dot matrix printer to make a barcode was not acceptable. The scanner couldn't read the codes. It can be done with a laser printer but you will have to either buy the font cartridge for the printer if you are using DOS or if you are using dBase within Windows you will have to...

Why are you using acceleration use the velocity. Set your velocity in a variable and compare each velocity. Output when new velocity is larger than old velocity. Change velocity variable every cycle.