This topic is locked

Empty fields generates errors on edit and add new

1/30/2005 9:09:06 PM
ASPRunnerPro General questions
R
Robert author

Hi everyone,
Is there a way to bypass this problem? The Update statement generates an error after pressing the SAVE button on Add new or Edit screen..

Thanks,

Robert

Sergey Kornilov admin 1/31/2005

Robert,
post exact error message here.

R
Robert author 1/31/2005

ASP error happened
Technical information

Error number -2147467259

Error description [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

URL /Voyages_edit.asp

SQL query update [Voyages] set [Ship]=2254, [Voyage]='27/03NB', [DtStart]='5/4/2004', [DtClose]=NULL, [Hire]=7000, [BB]=120000, [Dunnage]=0, [ILOHC]=0, [PortCaptain]=0, [CVE]=0, [Insurance]=0, [Straps]=0, [OceanbulkComm]=2,5, [InterchartComm]=1,25, [Despatch]=0, [Overtime]=0, [FreightTax]=0, [Others]=0, [MDOPrice]=270, [IFOPrice]=160, [Obs]='' where [VoyageID]=1 and [Voyage]='27/03XX'
Would 'Overtime' be a reserved name? But it does happens with other tables too. On other simpler tables I mange to save ok....so I don't think its anything to do with permissions...

Later on today I will install 3.1a and have another go...
Another concern: I chose the portugues (brazilian) format as my regional settings. Why are the decimal argumentes as dots and not comma? This is not whats holding the issue above....I'm just curious...

I can't find anymore a screen I'd seen about the language LICS code which could be inserted into global.asa. Could you please send me the urll, please?

Sergey Kornilov admin 1/31/2005

Robert,
this is still permissions issue. Check the very first answer in ASPRunnerPro FAQ for more info.
If this doesn't help zip and send to support@xlinesoft.com the whole content of ASPRunner output folder ( ASP files, include files, database etc.) along with the project file? I'll find what's wrong running it on my test box.
I'm not really what is the LICS code that you asking about.