Yes
>
>I used the program below to convert. dbf to mysql
>
>http://www.tek-tips.com/faqs.cfm?fid=4878
>
>It is supposed transforming dbf to slq table.
>
>After executed, it resulted: create table ACESSO_layout (NOME C(50),TEXTO M))
>
>But this command line results error when applyed directly on phpMyadmin.
>
>The problem is because SQL diferente from mysql, or why it does not work ?
>
>*****************************************************************************
>
>layout_to_code(GETFILE('*.dbf'))
>
>PROCEDURE layout_to_code
>LPARAMETERS lcTable
>
>IF ADIR(laTemp,lcTable)=0
> MESSAGEBOX("No Table Selected")
> RETURN
> ENDIF
>
>
>
> lcTable=JUSTSTEM(lcTable)
>
>
> IF USED(lcTable) = .f.
> USE (lcTable) IN 0
>ENDIF
>
>SELECT (lcTable)
>
>lcCmd=""
>FOR lnFieldCnt = 1 TO AFIELDS(laTemp)
> lcCmd=lcCmd+laTemp(lnFieldCnt,1)+" "+laTemp(lnFieldCnt,2)+;
> IIF(laTemp(lnFieldCnt,2)="D","","("+TRANSFORM(laTemp(lnFieldCnt,3))+;
> IIF(laTemp(lnFieldCnt,2)='N',","+TRANSFORM(laTemp(lnFieldCnt,4))+")",")"))+;
> IIF(MOD(lnFieldCnt,4)=0,",;"+CHR(13),",")
>ENDFOR
>
>lcCmd=LEFT(lcCmd,LEN(lcCmd)-4)+")"
>
>STRTOFILE("create table "+lcTable+"_layout ("+lcCmd+")",lcTable+'_layout_prg.prg')
>COMPILE (lcTable+"_layout_prg")
>
>MESSAGEBOX("'"+lcTable+"_layout_prg' sucessfully created")
>
>MODIFY COMMAND (lcTable+"_layout_prg") NOWAIT
>ENDPROC
>
>*********************************************************************************************************************