Recent content by Sergey Smagin

  1. S

    Active Query Builder .NET Edition 1.9 is released

    Active Database Software announces the new version of Active Query Builder .NET Edition, the leading solution for SQL query building, parsing, analysis and modification. Active Query Builder .NET Edition allows your end-users to build complex SQL queries via an intuitive visual interface. It's...
  2. S

    SQL query builder

    Hi, Your requirements are perfectly suit to the Active Query Builder component: it has MS-style visual interface, it can parse SQL queries of any complexity and report about parsing errors (of course). Also it can be used as a parser (without GUI). The only shortcoming is that this component...
  3. S

    SELECT statements with substitution varibables with access via VB .NET 2003

    Hi, I think your query should be written as follows: SELECT CustomerID, CopyID, DateOut, DateDue, DateReturned, 0.5 * (DateReturned - DateDue) AS Fines, FinesPayed FROM LoanRes WHERE CustomerID = :CustomerIDor SELECT CustomerID, CopyID, DateOut, DateDue, DateReturned, 0.5 * (DateReturned...
Top Bottom