Search found 95 matches

by sfxcc
09.11.2010, 01:46
Forum: ZeosLib 7.0 Beta Forum
Topic: Error filtering [myfield]=1
Replies: 5
Views: 493

I have a better parser... i release it out when it is finished , is easier and recursive way without the enum for brackets and other fixed elements. Im developing a object pascal compiler and script engine but it works on any language,hope finish it next year .. i dont have time to do it till end of...
by sfxcc
09.11.2010, 01:13
Forum: ZeosLib 7.0 Beta Forum
Topic: Error filtering [myfield]=1
Replies: 5
Views: 493

Ok zExprParser on line 535 procedure SyntaxAnalyse6. Where is ttLeftBrace and the ttRightBrace like the next if Primitive.TokenType = ttLeftBrace - ( Primitive .TokenType and the Token .TokenType) All ttLeftBrace or ttRightBrace on this procedure should be changed to : if (Primitive.TokenType = ttLe...
by sfxcc
09.11.2010, 01:10
Forum: Firebird
Topic: Filtering Timestamp with zeos and fb URGENT
Replies: 10
Views: 1344

Sorry misundestand again i use

filter := ' (movdate>='+QuotedStr('01-01-2010')+')and(movdate<='+QuotedStr('31-01-2010')+') ';
filtered := true;

and doesnt filter only blank ??
by sfxcc
08.11.2010, 18:20
Forum: Firebird
Topic: Filtering Timestamp with zeos and fb URGENT
Replies: 10
Views: 1344

Sorry for the misundestand and thanks any way it helped me on sql staments. but the prob is when i use local filtering like ztable.filter := ' (movdate>='01-01-2010')and(movdate<='31-01-2010') '; ztable.filtered := true; It filter but blank , parsing error maybe ... I use a lot local filter is faste...
by sfxcc
05.11.2010, 17:24
Forum: Firebird
Topic: Filtering Timestamp with zeos and fb URGENT
Replies: 10
Views: 1344

Filtering Timestamp with zeos and fb URGENT

I have a problme with filtering with filtered property on dataset

i do (movdate>='01-01-2010')and(movdate<='31-01-2010')

and it doesn t work

I can i solve this ?????


Thanks
by sfxcc
02.11.2010, 17:21
Forum: ZeosLib 7.0 Beta Forum
Topic: Error filtering [myfield]=1
Replies: 5
Views: 493

Error filtering [myfield]=1

Can you had the '[' ']' elements to expression filter. Rave reports use this an it says parcing error zexprs... etc. It works with '(MOVID)=19' but not with '[MOVID]=19'. I solved just patching the code on setfilter with stringreplace but is not good. So can you add next verson this. Thanks :idea:
by sfxcc
29.10.2010, 17:00
Forum: 6.6 - stable
Topic: Master Detail field doesnt work without saving master ?
Replies: 0
Views: 499

Master Detail field doesnt work without saving master ?

Does any one know a way to use master detail field without posting master ??? I can use the detail field disconnected and put 0 value on the detail field and when i save the master record just change the detail field into detail records. But this is a bit worky. There is other way to do this ? Thanks
by sfxcc
29.10.2010, 16:53
Forum: Firebird
Topic: Field Title Description URGENT
Replies: 4
Views: 642

Ok this solved tehre is a fb SQL command witch is COMMENT so comment fields
by sfxcc
18.10.2010, 13:43
Forum: 6.6 - stable
Topic: howto manage a memo field
Replies: 1
Views: 513

Use the createblobfield function. var aBlob : TBlobField; begin aBlob := TBlobField.Create(Field,Mode); aBlob.Write(); aBlob.Read(); end; But the best is to create a function to read and other to write and the parameter is (aBlob:TBlobField;var Value:string) : Boolean; This could help you a bit. :)
by sfxcc
18.08.2010, 17:25
Forum: 6.6 - stable
Topic: IndexFieldName,SequenceField,Sort Field
Replies: 4
Views: 6811

I might have to do the in memory table. 1 - Query is slow i need a speed group by - i can doit the slow way(query) but ppl need to wait more... 2 - Im doing a dbtreegrid and need to acess data in many places without to move cursor and is impossible to do this with a normal dataset , so i ll maybe ne...
by sfxcc
18.08.2010, 13:57
Forum: 6.6 - stable
Topic: IndexFieldName,SequenceField,Sort Field
Replies: 4
Views: 6811

Thank you guidoaerts, I have 3 choices, i use in memory data and handle a groupby under component by my self . use a zquery (select * from table group by field), or try to find a dataset componet that does this for me. Do u know any dataset component that does this on lazarus and delphi compatible. ...
by sfxcc
18.08.2010, 00:08
Forum: 6.6 - stable
Topic: IndexFieldName,SequenceField,Sort Field
Replies: 4
Views: 6811

IndexFieldName,SequenceField,Sort Field

I was trying to use indexfield = my fieldname but it seams it doesnt work .

Any idea ???

What does SequenceField, and Sort Field.

Does it work if i change it in real time ???? I tried and didnt work .

I want to to groupby a ztable it is possible ???

Thanks
Sérgio Francisco
by sfxcc
16.08.2010, 18:29
Forum: 6.6 - stable
Topic: Acess a record anywhere
Replies: 3
Views: 548

Ok, I didnt try yet , but a need a real good speed this is when i scroll my dbtreeview window? Does zeos table query always ??? I was reading zeos code it seams it reads as needed and caches what it reads. this is correct??? There is any way to not resync ? (request again all record ) when i go to l...
by sfxcc
15.08.2010, 20:42
Forum: Feature Requests
Topic: Table editing without changing activerecord property
Replies: 1
Views: 1542

What is EHLIB wher can i find it
by sfxcc
15.08.2010, 12:24
Forum: Feature Requests
Topic: Add Multi DataBuffers - URGENT ANSWER
Replies: 2
Views: 1845

TMYDBTreeView - Is Lazarus Compatible

It suppose to work with all zeos datasets or all dataset descendent. I dont think copying the data to a local dataset is good idea becaus e i have it on some part of other softwares and it stays a bit slow (im thinking this could work without slowing at least with 3 million rows). Im doing this beca...