Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi.hi we contacted couple hosting sites but for now none support both,only Mysql and Sqlserver are supported anyone is using that combination? thanks From: "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" To: firebird-support@yahoogroups.com Sent: Friday, February 17, 2017 9:5

Re: [firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
17.02.2017 20:36, 'Mr. John' mr_joh...@yahoo.com [firebird-support] wrote: > Our clients ask for mobile/web access of our app,in this case we decided to > rewrite app > with Asp Core.What options are for hosting firebird with asp core? VPS or your own server. -- WBR, SD. --

[firebird-support] Firebird web hosting ASP.NET Core

2017-02-17 Thread 'Mr. John' mr_joh...@yahoo.com [firebird-support]
Hi,we use Firebird 2.5 for a windows application build with .NETOur clients ask for mobile/web access of our app,in this case we decided to rewrite app with Asp Core.What options are for hosting firebird with asp core?thanks.

[firebird-support] Re: Firebird 3 execution plan

2017-02-17 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
16.02.2017 21:20, liviuslivius wrote: > > can this plan be selected by Firebird in somehow automatically without > going to left join or +0 solution? In this particular case, I'm afraid you don't have any other choice. But I will think a little bit more, maybe some clever idea will come. Dmitry

[firebird-support] Re: FB3 - max length of varchar fields and slow queries with blobs

2017-02-17 Thread Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]
17.02.2017 15:29, André Litfin a.lit...@xsigns.de wrote: > > I thought FB3 should remove the limitation to max. length of for > varchars (32765 bytes). I tried today to create a longer varchar field > without luck. Is the limitation still active? Yes, there were no plans to remove it. Dmitry

Re: [firebird-support] Cursor not Executing Properly

2017-02-17 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hey Hi SET, le me Have a look. How are You Sir? :) Quite not seen from long time... :) Thanks a Ton again... On Friday, 17 February 2017 4:21 PM, "Svein Erling Tysvær setys...@gmail.com [firebird-support]" wrote:   I don't use cursors myself, but are you sure "open cur_list_of_contrac

[firebird-support] FB3 - max length of varchar fields and slow queries with blobs

2017-02-17 Thread André Litfin a.lit...@xsigns.de [firebird-support]
Hello @all, I thought FB3 should remove the limitation to max. length of for varchars (32765 bytes). I tried today to create a longer varchar field without luck. Is the limitation still active? I don’t use blobs because queries using blobs have been a lot slower than queries without blobs. Is thi

Re: [firebird-support] Cursor not Executing Properly

2017-02-17 Thread Svein Erling Tysvær setys...@gmail.com [firebird-support]
I don't use cursors myself, but are you sure "open cur_list_of_contracts;" is enough to set a value different from 0 for row_count? Maybe you need to do the first fetch earlier, e.g. execute block as declare contractno CHAR(20); declare cur_list_of_contracts cursor for (select CU.CONTRACTNO

Re: [firebird-support] FB3 No permission for usage access to exception

2017-02-17 Thread hamacker sirhamac...@gmail.com [firebird-support]
grant to public and it will be resolved. 2017-02-16 10:59 GMT-02:00 r...@seedsbydesign.com [firebird-support] < firebird-support@yahoogroups.com>: > > > I'm confused about an error when accessing an FB3 database - "No > permission for USAGE access to Exception E_Exception". > > > When I run a pro

[firebird-support] Cursor not Executing Properly

2017-02-17 Thread Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
Hi All,  I have created the below cursor on Firbird DB (version 2.5). The update statement in below cursor is not updating value.   execute block as   declare contractno CHAR(20); declare cur_list_of_contracts cursor for (SelectCU.CONTRACTNO From CLASSIC_UPGRA