Re: [fpc-pascal] Why TSqlScript has no parameters?

2022-10-10 Thread Luca Olivetti via fpc-pascal
El 10/10/22 a les 19:30, Michael Van Canneyt via fpc-pascal ha escrit: This feature is missing in TSQLScript, because I never needed it, but it should be easy enough to add. No, don't bother, it's just two statements and I can simply use TPQConnection.ExecuteDirect (in fact that's what I'm

Re: [fpc-pascal] Why TSqlScript has no parameters?

2022-10-10 Thread Michael Van Canneyt via fpc-pascal
Hello, I need to execute more than one statement. TSqlQuery it seems to accept multiple statements but then it gives a strange error (posgtresql error "no parameter $2", the parameter it refers to is defined and used in the second statement). Multiple statements are not supported in

[fpc-pascal] Why TSqlScript has no parameters?

2022-10-10 Thread Luca Olivetti via fpc-pascal
Hello, I need to execute more than one statement. TSqlQuery it seems to accept multiple statements but then it gives a strange error (posgtresql error "no parameter $2", the parameter it refers to is defined and used in the second statement). So I tried a TSQlScript but then I could find no