[RMCA] 501 Fields

24 views
Skip to first unread message

Rick Harper

unread,
Nov 4, 2017, 6:38:03 PM11/4/17
to x12-p...@googlegroups.com

Is there a limit on the number of fields (columns) I can define in the .cfg file. My database table fails to build if I have over 501 columns.

Thanks

Rick

 

 

 

Rick Harper

Applications Analyst

Northeast Alabama Regional Medical Center

400 East 10th Street

Anniston, AL. 36206

256-235-5680

rha...@rmccares.org

 

 

Com1 Software

unread,
Jan 8, 2018, 5:22:59 PM1/8/18
to X12 Parser
Hi Rick,

We ran some tests and have determined that the SDDODBC SQL Database Driver has a limit of 726 fields for both MSSQL and MySQL.

We also did test with MSAccess and found we has a limit of 201 fields with that database.

Attached are the files we used to run the test on MSSQL.

Thanks,

Lynn
basicmssqltest2.dbs
837I.cfg
Reply all
Reply to author
Forward
0 new messages