[ 
https://issues.apache.org/jira/browse/OFBIZ-1941?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12627455#action_12627455
 ] 

Jacques Le Roux commented on OFBIZ-1941:
----------------------------------------

Hi Nattanicha,

As BJ already pointed ou in ML this would be barely usable as you mentionned in 
user ML

{quote}I must modify variables in ModelEntity.java because Foxpro cannot uses 
fields names that are longer than 8 characters.{quote}

and above

{quote}Foxpro need to be put no-auto-stamp="true" for entity because Foxpro 
does not support variable name that is longer than 8 characters.{quote}

This last comment is not clear to me. Do you mean that only field names (DB 
columns) can't be longer than 8 characters or other DB elements (relations 
names, indexes, etc.) are also concerned ?

I don' t close this issue for now in case someone has a solution or ideas. But 
unfortunately I guess this is what will happen because we would need to have a 
complete rewritting of entities definitions. Of course if you provide this 
rewritting we could propose a patch for possibly other/future users but it will 
never be commited in OFBiz and would have to be updated as the data model is 
not freezed...

> fieldtypevisualfoxpro.xml
> -------------------------
>
>                 Key: OFBIZ-1941
>                 URL: https://issues.apache.org/jira/browse/OFBIZ-1941
>             Project: OFBiz
>          Issue Type: New Feature
>          Components: framework
>         Environment: Windows, JDBC-ODBC bridge
>            Reporter: Nattanicha
>            Priority: Minor
>         Attachments: fieldtypevisualfoxpro.xml
>
>   Original Estimate: 336h
>  Remaining Estimate: 336h
>
> Normally, OFBiz provides many field type files in framework\entity\fieldtype 
> that can be used with many types of database. Visual foxpro is also a 
> database type that need to be used to connect with OFBiz. Many legacy systems 
> was developed by using Foxpro and need to be connected to new ERP system.
> By using fieldtypevisualfoxpro.xml, users must use Visual Foxpro ODBC driver 
> (http://msdn.microsoft.com/en-us/vfoxpro/bb190233.aspx) to be a driver to 
> connect with DBF file because I cannot find DBF JDBC driver for free. Anyway, 
> entity creation in entitymodel.xml for Foxpro need to be put  
> no-auto-stamp="true" for entity because Foxpro does not support variable name 
> that is longer than 8 characters. This problem should be fixed later if we 
> need to use foxpro in OFBiz with Locking.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to