search

knop-project / knop

Web application framework for Lasso 8 and 9
18 stars 46 forks source link

knop_database oncreate -keyfield's column cannot be numeric #114

Open stevepiercy opened 9 years ago

stevepiercy commented 9 years ago

This code will fail.

var(db) = knop_database(
    -database='database',
    -table='table',
    -maxrecords=$maxrecords,
    -keyfield='id',
    )
An unhandled failure during a web request
Error Code: 21
Error Msg: Is a directory
Error Stack: 
169:20 file.lasso

Use a varchar for -keyfield.

maxwellk2 commented 8 years ago

If the datasource is FileMaker (tested with FMSv13) -keyfield can remain "numeric" without generating this error.