Home› General
ReportBuilder 22.06 now available including Delphi 12.2 support!
New Blog Posts: Merging Reports - Part 1 and Part 2

SQL Errors using parameters

rbuserrbuser
edited July 2007 in General
Hello, i is Juan from Argentina and i have a problem whit ReportBuilder
version 7.04

The problem is that i want do a report whit a filter parameter of string
type but the reportBulder thows errors sql.

When I put in ?file -> data settings? -> SQL type? that uses LocalSQL
throws the following error to me:
[URL=http://www.idivimage.com/viewer.php?file=mzgyjexmzwtzltezzmwd.jpg][IMG]http://www.idivimage.com/thumbs/mzgyjexmzwtzltezzmwd.jpg[/IMG][/URL]
The problem is that it arms the SQL bad, instead of putting the parameter
in inverted commas simple, puts it in inverted commas double!

If I put in settings that uses SQL1 or SQL2 throws this other error to me:
[URL=http://www.idivimage.com/viewer.php?file=jumzzzj4t4qyn0dizmmi.jpg][IMG]http://www.idivimage.com/thumbs/jumzzzj4t4qyn0dizmmi.jpg[/IMG][/URL]
The problem is that it puts the user (SYSDBA) before the name of the
tables in SQL!

How I can use parameters whitout this errors?

Very Tnks and best regards



--- posted by geoForum on http://delphi.newswhat.com

Comments

  • nardmoseleynardmoseley
    edited July 2007

    Please specify more about the environment. Delphi version, Windows version
    database product, data access component set, etc.

    What database product are you using? (SQL Server, MS Access, Oracle,
    Interbase, ...)

    What data access components are you using? (ADO, DOA, IB Express, ..)

    The Designer.DataSettings.SessionType is used to specify the DADE plug-in,
    which corresponds to the data access component set.

    The Designer.DataSettings.SQLType and DatabaseType influence the SQL syntax
    that is generated.



    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
  • rbuserrbuser
    edited July 2007
    we use Delphi 7, SQL direct 4.9 and windows XP.


    Database Firebird and MSSQL Server.


    very tnks



    --- posted by geoForum on http://delphi.newswhat.com
  • nardmoseleynardmoseley
    edited July 2007

    - Have not heard of SQL Direct. Do you have a DADE plug-in for that product?

    - We have a list of commonly used DADE plug-ins on the Download | DADE
    plug-ins section of our web site. We also have some examples installed to
    RBuilder\Demos\EndUser Databases.

    - The Designer.DataSettings.SessionType is used to specify which DADE
    plug-in to use.

    - The Designer.DataSettings.SQLType and DatabaseType properties influence
    the SQL syntax that is generated. For SQL Server use SQL2 and MSSQLServer,
    for Firebird use SQL2 and Interbase

    - The Designer.DataSettings used at the time you create a query dataview are
    assigned to the dataview and saved as part of its definition.


    --
    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com

    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
This discussion has been closed.