SQL Errors using parameters
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
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.