Zeoslib Portal

Sorry I was busy for a bit...I will try and get you the code.

Thanks for the reply Egon, I am doing what you say to do and I'm still getting the same error on the post. I don't understand, I've gone over your example 1000 times. I don't see any difference to my code yet I get the error on the post? I'm also puzzled why the INSERT works with the code below and ...

Actually I didn't have cacheupdates set to TRUE. I'm still getting the error but it's on the applyupdates and not on the post.

According to this example, I believe I'm doing the same thing? : With DataSet do Begin bEverythingOK := True; CachedUpdates := True; DataSet.First; While (not DataSet.EOF) and (bEverythingOK) do Begin DataSet.Edit; : // process record : DataSet.Post; DataSet.Next; : bEverythingOK := AFunctionForVali...

The problem is that I'm getting the error on the POST?

I don't even make it to the applyupdates or commitupdates.

Should I not be posting????

Sorry my mistake. You are absolutely right...I misread your reply.

However I did as you say and still get the same problem.

http://www.tiikoni.com/tis/view/?id=2c9139c
http://www.tiikoni.com/tis/view/?id=34dd27b

Thank you once again Egon. I appreciate the help.

So I created a Primary Index on the 'Company' field.

What do you mean by 'User primary key constraint'?

Can you give me an example?

I should mention that if I delete the record (so that it inserts) it works fine.

I have a table with only ONE record in it. When I try to edit it, I get the error message stated in the subject. ....EZSQLException with mesage '0 record(s) updated. Only one record should have been updated." Here is my code: if MainDM.adoRegistration.RecordCount = 0 then MainDM.adoRegistration...

I think I know what the problem is....I used a program to convert a database from MSSQL to SQLITE. It seem to have converted properly. When I used sqliteexpert to view the data it shows the pics but as I mentioned when I tried to view them using my delphi app, I would get an unknown picture format. ...

The url stream points to a jpeg image file. I know this works because if I change the components to SIVAK sqlite3 it works fine to some extent. I believe I have another problem with concurrency but I'll look into that a bit more. In the mean time if I use zeos, it doesn't seem to store the image pro...

Here it is...forgive me if bad code...I'm a beginner. if (xmlLUD > MainDM.adoAgents.FieldByName('lastupdated').AsDateTime) and (result = true) then begin writeToLog(3, 'Update agents record'); MainDM.adoAgents.edit; end else if result = false then MainDM.adoAgents.Insert; if MainDM.adoAgents.State i...

Do you have an example of how I should import the pictures....I'm finding that if I create a loop such as below, the imported data gets all mixed up. Meaning the fields gets imported into the wrong fields. I know this has nothing to do with blob fields but I'm thinking that the way I'm importing the...

I am using zeosib 7.0.3 with Delphi 2010. I have a sqlite3 database which contains a picture blob field. When I try to attach a dbaware picture vcl (Picshow http://delphiarea.com) it reports back an error "unknown picture format". This does work with the sivak3 sqlite3 dbase vcl tools. Wha...

Anyone?

Please.