changing field's length?
Hi,
We use AbraSuite HRIS at my workplace. It's about 5 years old. It has
foxpro (dbf) files on the backend...
Currently, the P_JobTitle field in the hrPersnl.dbf file holds only 25
characters (though the field length reports as 154.. but 154 what I
have no idea...)
We would like to alter this field to accept 70 characters... changing
the field length from 154 to, say 308, didn't accomplish anything..
Anyway.. I'm looking for any advice on offer regarding how to make this
alteration to the field.
Thanks a million.
Joshua
.
Relevant Pages
- Re: Dbase III field attributes
... > What is the largest text or character field attribute in DBF tables? ... > I would like to populate a field with 8000 characters. ... Andrew told you about memo fields, but you mentioned dbase III in a FoxPro ... When you USE a dBase dbf with a memo field, ... (microsoft.public.fox.programmer.exchange) - Re: probably a codepage problem
... > knowing that I have "default" tables compiled in my exe with codepage ... Foxpro can be made to automatically translate characters for tables that you ... automatic translation of characters across code pages. ... (microsoft.public.fox.programmer.exchange) - Re: Invalid argument - importing dbf from shp-file
... Use the old DOS 8.3 file name convention. ... Also be sure the column names in the file are 10 characters or less. ... I'm trying to figure out what's different about this shp or dbf. ... to rename all the 7 files of the shp-file is built up of. ... (microsoft.public.access.externaldata) - Re: Linking a dbf file with a filename longer than 8 characters
... ByVal lpszShortPath As String, ByVal cchBuffer As Long) As Long ... > filenames longer than eight characters. ... (microsoft.public.access.externaldata) - Re: Creating dbf table using ADO Recordset open method
... I will certainly look up more details on the DBF format, ... table name specified is longer than 8 characters is will truncate to 8 ... Names so they were limited to the old Dos 8.3 format. ... Since then other version of "xBase" have appeared, ... (microsoft.public.data.ado) |
|