Error on inserting record

[olu]

Hello All,
      I have a app which is runung with a MSSQL backend but when I tired to insert a record following the tagging example I keeping getting this error if I quickly tag about 10 records but if I do it slowing then I don't get any error but when I untag the record, I always get error 33 but it does remove the record in the backend.


Below is the code for the tagging and untagging of the record. And attached is a pic of error message.

Please can anyone help?

Code: [Select]

TagThisRecord       PROCEDURE
CODE
    Tag:MyfileId = Emp:Id
    Tag:SessionId = p_web.SessionId
    if  access:Tagged.Fetch(Tag:TagKey) = 0
        Tag:Tagged = Choose(p_web.GetValue('value') = 1,true,false)
        access:Tagged.DeleteRecord(0)
        p_web._trace('record Deleted')
    else
          
            Tag:SessionId = p_web.SessionId
            Tag:MyfileId = Emp:Id  
            Tag:Tagged = Choose(p_web.GetValue('value') = 1,true,false)
            Access:Tagged.Insert()
            p_web._trace('record inserted')
    end
  
    
[attachment deleted by admin]

[peterH]

Are you setting prop:busyhandling in your program?

Peter

[olu]

Hello Peter,
    No I am not, do I have to? New to all this SQL stuff.

[peterH]

Yes, otherwise you'll get errors like the one you've seen here.

Check out busyhandling in the docs (hint: it should be set to 2).

Peter

[olu]

Thanks peter which docs should I be looking at?

[peterH]

Lookup BUSYHANDLING in the on-line help.

Peter

[Bruce]

see this thread;
http://www.nettalkcentral.com/index.php?option=com_smf&Itemid=36&topic=403.0

[olu]

Hi Bruce,
    I am getting really confuse now how to use the host app to server my dll sites with fm3 running on the dll app.
In this application I have fm3 which I have turned off just to be able to run the app or less I get error 45.

I have put my connection string on webserver handler on the processlink embed and have the glo:owner threaded.

Here comes the confusion on fm3 do I add SQ_Connect procedure and when connection window comes up, do I re-type the connection details in again which I think as been defined already in the processlink embed? or do I leave out SQL_Connect totally?

Please can anybody shell some light on this on how to do it properly.