I have a problem using SQLCommandMBS setting a parameter on the command string,
for which the Informix DB server return a syntax error.
I set a parameter for the table name and the fill it with the right string.
The only reason the DB server could return a syntax error is that the parameter
was enclosed with quotes (like 'myTable')
Here it's a stripped version of the code:
dim selectCmd as string = "SELECT * FROM :table"
// create a new SQLCommandMBS
dim cmd as new SQLCommandMBS(DBConnection, selectCmd)
// set parameter
cmd.Param("table").setAsString(new SQLStringMBS("myTable"))
// execute the command
cmd.Execute
Manually setting the table, of course it works.
I tried also setting the string asBytes but with the same result.
Any help?
Massimo Valle
SACO Software and Consulting GmbH, Mühlgasse 5, D-97840 Hafenlohr
Tel.: ++49 9391 90890-0, Fax: ++49 9391 90890-99, E-Mail: [email protected]
Amtsgericht Würzburg HRB 5410, Geschäftsführer: Peter Schubert,
Dipl.-Wirt.ing.(FH) Thorsten Beck
_______________________________________________
Mbsplugins_monkeybreadsoftware.info mailing list
[email protected]
https://ml01.ispgateway.de/mailman/listinfo/mbsplugins_monkeybreadsoftware.info
