Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #5815

Re: Problem when I change the type of a field in a database

From Massimo Bighelli <info@arcasistemi.it>
Newsgroups comp.lang.clipper.visual-objects
Subject Re: Problem when I change the type of a field in a database
Date 2013-09-08 11:45 +0200
Organization ARCA Sistemi S.r.l.
Message-ID <l0hh0d$ugv$1@speranza.aioe.org> (permalink)
References <fde630fe-3a99-4a5a-8286-72019f896e21@googlegroups.com>

Show all headers | View raw


George,

if you are with DBFNTX driver, you have the DBT file too, because of the 
memo field

Massimo

Il 08/09/2013 08:35, BGeorge ha scritto:
> Hi all,
>
> I have a problem when i change the type of a field in a database.
> e.g.
> MyDataBaseFile.DBF
> FieldName   Type    Width
> FirstField  Numeric 2
> SecondField Memo
> after change
> FirstField  Numeric 2
> SecondFiled String  20
>
> in template file i put my changes
>
> My code:
> sourcefile:="MyDataBaseFile.DBF"
> mfile1:=sourcefile+".DBF"
> mfile2:=sourcefile+".OLD"
> FRename(mfile1,mfile2)
> create &msourcefile from template
> append from &mfile2 // here is the error
> erase &mfile2
>
> Error message:
> --------------
> Error Code:  34 [ DATA WIDTH ERROR ]
> Subsystem: DBFNTX
> Error Subcode: 1121 (Datawidth error)
> Function: DBAPP
> Requested type: NUMERIC
> CallStack:
> DBASE:PUSHBUTTON2 (Line: 62)
> DIAXDBASE:PUSHBUTTON3 (Line: 7)
> APP:START (Line: 35)
>
> Error Object created:
> --------------------
> SubSystem       :DBFNTX
> SubCode         :      1121
> GenCode         :Data width error
> OsCode          :         0
> ArgType         :NIL
> FuncPtr         :0x00000000
> ArgNum          :         0
> FuncSym         :DBAPP
> Severity        :         2
> CanDefault      :.T.
> CanRetry        :.F.
> CanSubstitute   :.F.
> Operation       :
> Description     :
> FileName        :
> Tries           :         1
> FileHandle      :         0
> SubCodeText     :Datawidth error
> Arg             :
> ArgTypeReq      :NUMERIC
> MaxSize         :         0
> SubstituteType  :NIL
> CallFuncSym     :
> --------------------
>
> George
>


*Massimo Bighelli* ARCA Sistemi S.r.l.

Back to comp.lang.clipper.visual-objects | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread


Thread

Problem when I change the type of a field in a database BGeorge <GeorgeTritsos@yahoo.gr> - 2013-09-07 23:35 -0700
  Re: Problem when I change the type of a field in a database Massimo Bighelli <info@arcasistemi.it> - 2013-09-08 11:45 +0200
  Re: Problem when I change the type of a field in a database D.J.W. van Kooten <public@ic2remove.this.com> - 2013-09-08 14:03 +0200

csiph-web