Search found 8 matches

by Plavozont
30.04.2012, 06:34
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

That's great! Thank you!!! Why don't you create a sticky post and put it there so that every one could use it :) :?: :!: By the way, what happend to all the other documentations?
by Plavozont
27.04.2012, 08:27
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

Wow, it works like this:
filt:='birth_date like ''*1981''';
by Plavozont
27.04.2012, 08:05
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

OK, that's ZeosDBO 7.0.0 bug, ZeosDBO 6.6.6 filters just fine, it doesn't even complain about "--.--.1981". But asterisks(or percent signs) still give no effect, any manual there?
by Plavozont
27.04.2012, 05:59
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

I figured that when filter looks like this: filt:='birth_date = "--.--.1981"; Zeos says "--.--.1981" - is a bad date. But when it looks like this: filt:='birth_date = "--;--;1981"; Or even like this: filt:='birth_date = "Simon Smith"; It says nothing, but stil...
by Plavozont
26.04.2012, 11:16
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

I would like some manual on ZeosDBO/ZeosLib please. I have found some sort of a way to do what I want, I use ZQuery1.filter. But I have trobles filtering date field. In ZQuery1.SQL I have something like this: SELECT ...( (case birth_d when 1 then '--' else strftime("%d", birth_date) end) |...
by Plavozont
24.04.2012, 08:36
Forum: Documentations
Topic: Locate a record in DBGrid
Replies: 8
Views: 5514

Locate a record in DBGrid

I couldn't find the documentation on ZeosLib anyhere. The links in the topic "New documentation subproject started" are bad. I use ZeosDBO in Delphi. I have DBGrid connected to DataSet connected to ZQuery connected to ZConnection connected to SQLite3. I need to set cursor in DBGrid to spec...
by Plavozont
06.01.2012, 21:13
Forum: 6.6 - stable
Topic: SQLite SQL Errors
Replies: 1
Views: 460

Actually on a second thought it's not always like that, sometimes it gives reasonable explanation of the error, but still not always. For example if i write a name of a function that do not exist, like string_length, it says "SQL Error: SQL logic error or missing database", without any det...
by Plavozont
06.01.2012, 11:31
Forum: 6.6 - stable
Topic: SQLite SQL Errors
Replies: 1
Views: 460

SQLite SQL Errors

I have delphi 7 + ZeozDBO 6.6.6-stable, i use it to connect to SQLite 3 embedded database, everything works, but on any sql syntax or any other error I get the message "SQL Error: SQL logic error or missing database", but I expect to see something like "SQL error: you have a syntax er...