Home General
New Blog Posts: Merging Reports - Part 1 and Part 2

SQL Errors using parameters

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 ('parameter'), puts it in inverted commas
double("'parameter")!

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
This discussion has been closed.