Zeoslib Portal

Hello, I log data into a sqlite DB. If the DB has a size of 5MB I start a new one. I do this for reasons for performance and data corruption reasons. Now I do queries on the DB, like give me the data from time x to time y. When in this timespan there Database has changed, I have to do the queries on...

I have a simple TZQuery connected to a sqlite3 db. The query is "SELECT * FROM page" Now I want to save the data from a RichEdit into the db: zqPage.Edit; zqPage.FieldByName('page_text').AsString:=frmrichedit1.RTFText; zqPage.Post; When I execute this I get a EZSQLException. I think its be...

I use my application with a Database on the Internet, thats why I have to reduce the amount of data transfered between application and database. By now I found out that if I set Filtered:=true only the needed records are fetched, which is quite good and exactly what I want. But there are some proble...

I am using a TDBGrid to Browser a TZQuery. The TZQuery.Filtered property is set to TRUE so, that not all Rows are fetched as one. This works perfekt, excep the scrollbar of the DBGrid, which only has 3 position (first, somewhere in the middle, last). As far as I understand this is because it does no...

Hallo, I have a DBGrid with 2 Lookup fields in it. I now want to limit the selectable entrys in the second one depending on the value in the first one. For better understanding parts of my db: Master Table: CREATE TABLE seminare ( seminar_id serial NOT NULL, kurs_id int2, kurs_teile_id int4, ) Looku...

Before open polling table, commit and start a new transaction. Regards. This worked! Thank You! It is a bit a hack, because i use AutoCommit:=true I now do the following ZConnection.AutoCommit:=false; ZConnection.Commit; ZConnection.StartTransaction; do my query ZConnection.Commit; ZConnection.Auto...

Do your users really touch other's TO-DO's? Ask yourself if the complex mechanism for licking is really needed, because how many chances are that two users edit the same record on the same time. If there's quite some chance, then go on, otherwise keep it simple and just use POST. But this is just a...

I have written a multiuser adressbook, with todo list. I use TransactIsolationLevel tiSerializable so that one user can not overwrite changed someone made on the same Record while he was editing it. This works all fine. Now I want, that each user gets a notification, when he gets a new todo. For thi...

I have seen no posibility to use a Lookup Field with a N to N connection where a 3rd table connects to other Table together.
This could be displayed with a multiselect listbox.

Is something planed to create such a feature or am I missing something?