Zeoslib Portal

Yeah...
Thanks very much, best regards
p.s Ehhhhhhhhhhhh, I forgot to enable controls ....

Probably I do something wrong(but I dont know what). I tried a simple test(new project) and it works... I'm sorry for disturbs..

I tried in ObjectInspector: DataSource -> current query(or table) for edit/insert DataField -> Field (integer); then ListSource -> an other source who have needed for list of some names and id = id of the first(listfield->names and keyfield id) but dblCmb is empty. both data sets are active and not ...

I use zeos r3986 + PostgreSQL 9.5 but
DBLookupComboBox doesn't work. Any idea?
Thanks

I have a few ideas, but I do not have much time(this month). I will write a few options, soon(as possible).
Thanks for your interest, and for great ZeosLib.
ExDatis

Hi mdaems,
did you min rewrite usual ZQuery SQL editor?

Hi all,
if you want:
http://sourceforge.net/projects/exdatis ... les/ver01/
quite simple, light, query builder for PostgreSQL ver.8.*
May be useful for Pascal programmers. Autocomplete(not usual, merge tbl+.+field).
Written quickly, sorry...
p.s. there is a setup.exe

Clasic, or super? You have two different compon. Try second comp. in list.

I am sorry, messageDlg function is the problem, not postgre-DataSet.

Just in DBnavigator property confirmDelete=True. Also, after confirmDelete=False and DataSet event:
before delete:
if messageDialog(....)=mrOK then ...


-any time: stop and disable any object on form

I have a problem with confirm msg, before delete, on XP SP2, pg8.3. Work
well on linux(openSuSe 11.2 32bit. pg8.4. FPC 2.4 , Lazarus 9.28.
Break of any process.

If you want LIMIT(mysql, postgresql), then:
SELECT FIRST 20 SKIP 40 FIELD_ONE,FIELD_TWO from TABLE1
also, for all :
SELECT FIRST 100 * FROM TABLE_NAME.

Provider from non visible to visible, quite simple! If you want just var(query_fileds.value), you do not need DataSource compon.

DataSource is access provider (Db object, TDBgrid...).
Db with 150 tbls and over 3 mil. rec. size-> about 200MB.
work well on PC 256MB RAM and AMD2800+.
Enough?
PC AMD3000+ and 512MB RAM, select(like with two arg), on 300000 rec. tbl.
gave res < 1sec.

You can add new field in TZtable(add fields dialog) calculated, then
onCalcFields event:
//procedure...
if table_field.value='Y' then
calc_field.value=True
else
calc_field.value=False;

//set table_field visible false, and calc_field visible true