[firebird-support] Invalid argument in EXECUTE STATEMENT - cannot convert to string

2014-06-25 Thread Tim Ward t...@telensa.com [firebird-support]
Anyone know what this error message actually means? Yes I am trying to run an EXECUTE STATEMENT, but it's not clear to me what an argument means in this context, or what it is that something is trying to convert to a string, or why it's trying to do so, or why it can't be done.

[firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread kokok_ko...@yahoo.es [firebird-support]
I have a web server suing Firebird. I installed it using Classic mode because it seems more robust. Usually, databases have between 1 to 3 users concurrently as maximum. However, there are 50 databases and eventually many users could be using their database. When I open the database, it works

RE: [firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread 'Edward Mendez' emendez...@nc.rr.com [firebird-support]
Could that Database be in single user mode? When you try to connect are you using SYSDBA, but your client is using another login. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Wednesday, June 25, 2014 10:56 AM To: firebird-support@yahoogroups.com

RE: [firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread kokok_ko...@yahoo.es [firebird-support]
The connection is via network, TCP, not single user mode.

Re: [firebird-support] Invalid argument in EXECUTE STATEMENT - cannot convert to string

2014-06-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-6-2014 16:08, Tim Ward t...@telensa.com [firebird-support] wrote: Anyone know what this error message actually means? May I suggest that you also include the error in the message body, when reading e-mail on a mobile device, long subject lines have a tendency to get truncated. (The

Re: [firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-6-2014 16:55, kokok_ko...@yahoo.es [firebird-support] wrote: I have a web server suing Firebird. I installed it using Classic mode because it seems more robust. Usually, databases have between 1 to 3 users concurrently as maximum. However, there are 50 databases and eventually many

Re: [firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 25-6-2014 17:48, kokok_ko...@yahoo.es [firebird-support] wrote: The connection is via network, TCP, not single user mode. Connecting through TCP does not preclude single user mode. Mark -- Mark Rotteveel

Re: [firebird-support] Cannot Insert Filepath into database

2014-06-25 Thread adu...@yahoo.com [firebird-support]
Hey Helen, Thanks for your help, after two days of work i finally found the error. The error message was just wrong, though it says: column count does not match value count, it broke because there was one field which was marked as readonly. I have no idea why the field is marked readonly, the

Re: [firebird-support] Error 335544528 in classic mode and multiple users

2014-06-25 Thread kokok_ko...@yahoo.es [firebird-support]
That was the reason. I thought that single mode was only defined in the connection, not in the database. Thank you, you saved my day!

[firebird-support] CrossTab Select

2014-06-25 Thread sremula...@bol.com.br [firebird-support]
Partners'm racking my brain on a SQL code, does anyone could give a force I made the following SP CREATE PROCEDURE PRODS( PAC INTEGER) RETURNS( HOR TYPE OF HORA, SEG TYPE OF DESCRICAO, TER TYPE OF DESCRICAO, QUA TYPE OF DESCRICAO, QUI TYPE OF DESCRICAO, SEX TYPE OF DESCRICAO, SAB TYPE