Zeoslib Portal

yes, your right.

-Brad

I had caught that, I copied the SQL from the original project, and created the new demo project and when I made the tables for the demo project I types keywords instead of keyword for the field name. In the demo its not a syntax problem (I believe I fixed it) Where would I place this code? It works ...

Here's a demo of what I'm doing: http://uploading.com/files/cb34a4a3/filterprj.zip/

It's using Firebird 2.1.

-Brad

I have changed the SQL to the following which works in IB Expert, but how do I get it to work with Zeos. Select * From KeywordList As K Left Join NegativeKeywords As NK On NK.keyword = K.Keyword Left Join RequiredKeywords As RK On RK.Keyword = K.Keyword Where NK.Keyword Is Null And ( Not Exists ( Se...

can you go into more detail on what you did.. I'm not familiar with setting aliases, and this just might be the solution to my problem.

Thanks for the info

-Brad

I have three tables. keywordlist -keyword requiredkeyword -keyword negativekeyword -keyword I need to filter the data in the keywordlist not to show words that are in the negativekeyword table, and only show words that show in the requiredkeyword table. If either table is empty then don't worry abou...

After looking at the demo. 1. I need to have a ZUpdateSQL component 2. I need to setup the params. (Not 100% sure on how these params work, but I think i've got it.) 3. Setup the SQL for the insert/update/delete/refresh using the params The one thing the demo doesn't do is update the dataset after t...

Thank you for taking the time to do this demo.

-Brad

Any chance on some demo code on how I would do that, or a tutorial suggestion? I've got very little experience on how to do this.

Thanks

-Brad

How would I check for duplicates before posting data? I've been given this via stackoverflow but not sure how to implement it. update or insert into KEYWORDLIST (KEYWORD) values(:KEYWORD) matching(KEYWORD) I was guessing I would do this onNewRecord or BeforePost... Thank you -Brad Using: D2K9, Zeos ...

Hi, I'm new to zeos, firebird, and database applications in delphi. How do I create an autoinc field.

Thanks

B