[RMCA] 501 Fields

[Rick Harper]

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 10^th Street

Anniston, AL. 36206

256-235-5680

rha...@rmccares.org

 

 

[Com1 Software]

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