Zeoslib Portal

Hi, I have a DataModule with a Connection, Source (srcOne) and Table (tblOne). I wanted a duplicate set of Source and Table with slightly different names so I used an SQLite Manager to make a copy of tblOne for the new Table (tblOneB) in the database. I then went back to the DataModule copied the sr...

Hi, I put the database in dm.thisTable.Edit mode and then when I dm.thisTable.Post I get this message. I was using 7.1-stable so tried 7.2 still same error.

How do I fix this?

OK, found the problem. It is using two Fields in the IndexFieldNames. If I have tbl.IndexFieldNames:='Sequence;Account'; It deletes one time then after that subsequent Deletes (immediately following) will cause the crash in the OP. If I just have tbl.IndexFieldNames:='Account'; Deleting is normal an...

Hi, Ubuntu-14.04, SQlite3, Zeos 7.1, Lazarus 1.6.2

I am getting this error when I try to Delete from a zTable. I can do everything else OK, Insert, Edit, Cancel, Post, but not Delete.
What am I doing wrong?

miab3 wrote:select rowid,* from table

Thanks, but I am converting some Delphi stuff over and it was all written using Dataware and almost no real SQL stuff. I'd have to rewrite tons of stuff.

Doing it free for a friend so do not wan to spend a several days on it.

Hi,

For a variety of reasons I cannot use an AutoInc field so want to use the inbuilt RowID of SQLite as I need a unique Record-identifier.

I tried using tblLocate('RowID',aRowID,[]); but it returns an error and crashes.

How can I use that RowID?

What do you think? Hi Jan, Hmmm, not sure, but I am using this with Ubuntu 14.04 if that makes any difference. But - this didn't happen when I used this almost exact same code in Windows. I have changed over to Ubuntu and Lazarus and re-compiling everything, but that section of code is predominantl...

Thanks Jan, I am currently doing kinda that. I have set " Zee" as "1 Zee" and that is forcing it to the top. I had thought about using the Sequence Column, but I have Sorting in a DBGrid TitleClick and it gets messy with the bangfauzan-Sort Options. That's why I'd like to be able...

just don't use the IndexFieldsProperty at all then. Thanks, but unless I use the IndexFieldNames, how do I get them Alpha-sorted in order? I have no way of knowing the order they are going to be entered in. ' Zee' <-- I want "Zee" to always be the first item 'Chuck' 'Jan' :) 'Billy' 'Harr...

Hi, I have just found that the Sort for my SQLite database ignores leading non-alpha characters. I tried setting "SortType" to "stIgnored" but it is not Ignored. Is there some way to totally disable the Sort interference? Or am I missing an option somewhere? The SortType seems to...

Arrrggghgh -- STOP!!

It was someone working on the project. They had done... "// tblEmails.Filtered:=False;"

Sorry for the bother. Appreciate the time taken to look into it.

Oh and I am the only one working on the project!

Is there a chance for you to provide a small example where the problem occurs? I don't have a small copy of the database, but I changed the process to create a Hash of the data and save that. The hash is not working either. Here's some details. The Unique Hashes are being saved and recalled OK, jus...

Is there a chance for you to provide a small example where the problem occurs? I don't have a small copy of the database, but I changed the process to create a Hash of the data and save that. The hash is not working either. Here's some details. The Unique Hashes are being saved and recalled OK, jus...

marsupilami wrote:In some regions a and á are the same when sorting strings.Jan

Thanks for the follow up, but all the text is Normal old US-English, not umlaut in sight.

Hi, is there a max length for the String in Locate? I am using Sqlite-3, and a combination of String-items to give me a unique ID for some data. When I use Locate to find specific records, it sometimes doesn't work correctly, returning things not even close. I am using Date + Time + DataStr The Data...