Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-29 Thread Mr. John via Firebird-net-provider
On Tue, Aug 29, 2017, at 08:44, Mr. John via Firebird-net-provider wrote: > Hi.I'm using Db first and as I found that is about code firstIf I'm wrong > please someone give me some tips about using thatthanks. > > From: Jiří Činčura <j...@cincura.net>To: > "firebird-net

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-29 Thread Mr. John via Firebird-net-provider
Hi.I'm using Db first and as I found that is about code firstIf I'm wrong please someone give me some tips about using thatthanks. From: Jiří Činčura To: "firebird-net-provider@lists.sourceforge.net" Sent: Monday, August 28, 2017,

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-26 Thread Mr. John via Firebird-net-provider
ourceforge.net>Sent: Saturday, August 26, 2017, 4:37:44 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 Hi, At August 26, 2017, 1:38 AM, Mr. John via Firebird-net-provider wrote: | | Hi. Thanks Paul for your answer For my first code I've followed this: https://stack

Re: [Firebird-net-provider] EF - last inserted ID is 0

2017-08-25 Thread Mr. John via Firebird-net-provider
viders <firebird-net-provider@lists.sourceforge.net>Cc: Mr. John <mr_joh...@yahoo.com>Sent: Friday, August 25, 2017, 11:35:11 PM GMT+3Subject: Re: [Firebird-net-provider] EF - last inserted ID is 0 The trigger from you database has nothing to do with your c# code.You can use a sto

[Firebird-net-provider] EF - last inserted ID is 0

2017-08-25 Thread Mr. John via Firebird-net-provider
HiI'm using FB 2.5,EF Firebird 5.9.1,Asp MVC 5 with VS 2017  on a table I have a trigger to generate ID:    CREATE OR ALTER TRIGGER TRIG_MYTABLE_BI FOR MYTABLE                      ACTIVE BEFORE INSERT POSITION 0                      AS                      BEGIN                        IF

Re: [Firebird-net-provider] Stored procedures not added to model

2015-11-03 Thread Mr. John
edures not added to model On Mon, Nov 2, 2015, at 19:16, Mr. John wrote: > and use for stored procedures classic ADO.NET Why? You can still configure the SP in model manually. It's already there. -- Mgr. Jiří Činčura Independent IT S

Re: [Firebird-net-provider] Stored procedures not added to model

2015-11-02 Thread Mr. John
and use for stored procedures classic ADO.NET From: Jiří Činčura <j...@cincura.net> To: firebird-net-provider@lists.sourceforge.net Sent: Monday, November 2, 2015 4:10 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model On Mon, Nov 2, 2015, at 13:51, Mr

Re: [Firebird-net-provider] Stored procedures not added to model

2015-11-02 Thread Mr. John
Stored procedures not added to model On Wed, Oct 28, 2015, at 12:56, Mr. John wrote: > Hi > > this is the simplest SP I have: > > CREATE OR ALTER PROCEDURE PR_GETCFNAME(id bigint)returns ( NAME > varchar(100))asbegin select first 1 NAME  from cf where id=:id into > :NAME; suspen

Re: [Firebird-net-provider] Stored procedures not added to model

2015-10-29 Thread Mr. John
:13 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model What's the signature of that SP? -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Oct 28, 2015, at 09:53, Mr. John wrote: > HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 >

Re: [Firebird-net-provider] Stored procedures not added to model

2015-10-28 Thread Mr. John
ge.net Sent: Wednesday, October 28, 2015 1:13 PM Subject: Re: [Firebird-net-provider] Stored procedures not added to model What's the signature of that SP? -- Mgr. Jiří Činčura Independent IT Specialist On Wed, Oct 28, 2015, at 09:53, Mr. John wrote: > HiI'm using FB2.5,VS 2013,Fireb

[Firebird-net-provider] Stored procedures not added to model

2015-10-28 Thread Mr. John
HiI'm using FB2.5,VS 2013,FirebirdClient 4.8.1.0,DDEXProvider 3.0.2.0 When I try to add a stored procedure to model from database using Update model from database.,I select/check the sp name in the list,but no procedure is added to model,also in Model Browser nothing added,in function import no

[Firebird-net-provider] Problem using embedded version:IDE is waiting to terminate a process up to 7 seconds

2015-08-14 Thread Mr. John
Hi,I use FB embedded version for a little local db,Firebird-2.5.4.26856-0_Win32_embed on W 8.1 x86 with Visual Basic 2012FirebirdClient 4.7 I run this simple code and when I close it,application closes but IDE still show WindowsApplication1 Running  for up to 7 seconds,I think is waiting for

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-16 Thread Mr. John
paul.mer...@almexa.ro wrote: On 12/16/2013 08:34 AM, Mr. John wrote: That I also do, but I only apply  database update scripts on server machine,also some users using default app installer installed also FB server on 'client' side. I also want to warn about that. thanks Increment

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-16 Thread Mr. John
, 2013 11:05 AM, Mercea Paul paul.mer...@almexa.ro wrote: On 12/16/2013 10:15 AM, Mr. John wrote: Hi, but how to detect app is running on server side or on local,I used to search for firebird process but I found as I said, fb was installed also on client side,so the trusted point to get

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-15 Thread Mr. John
:33, Mr. John wrote: Hi ! I'm using VB.NET 2008 with FB SS 2.5 and FirebirdClient 2.7.7.0 I need to detect if current FB connection is local or over a network. Could you provide some detail on why you need to know this? Mark -- Mark Rotteveel

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-15 Thread Mr. John
/15/2013 12:21 PM, Mr. John wrote: Hi When using my application over a network,only when it is update on the server machine,client applications must download also the update so I need to detect server or client state thanks Hi If you separate the client and the server, even if you

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-14 Thread Mr. John
, 2013 3:10 PM, Jiri Cincura disk...@cincura.net wrote: Depends on what you think local (your original question) is. On Fri, Dec 13, 2013 at 12:40 PM, Mr. John mr_joh...@yahoo.com wrote: solution is to search in connecton string  for  'localhost' or '127.0.0.1' ? On Friday, December 13

[Firebird-net-provider] Detect current connection is local or network

2013-12-13 Thread Mr. John
Hi ! I'm using VB.NET 2008 with FB SS 2.5 and FirebirdClient 2.7.7.0 I need to detect if current FB connection is local or over a network. Thanks.-- Rapidly troubleshoot problems before they affect your business. Most IT

Re: [Firebird-net-provider] Detect current connection is local or network

2013-12-13 Thread Mr. John
Hi ! local  = database is on the same machine as application is thanks. On Friday, December 13, 2013 3:10 PM, Jiri Cincura disk...@cincura.net wrote: Depends on what you think local (your original question) is. On Fri, Dec 13, 2013 at 12:40 PM, Mr. John mr_joh...@yahoo.com wrote: solution

Re: [Firebird-net-provider] Help with retrieving/binding image from database

2012-11-03 Thread Mr. John
:    bSource_.EndEdit() Thanks ! From: Gerdus van Zyl gerdusvan...@gmail.com To: Mr. John mr_joh...@yahoo.com; For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Friday, November 2, 2012 3:55 PM Subject: Re

Re: [Firebird-net-provider] Help with retrieving/binding image from database

2012-11-03 Thread Mr. John
Thanks ! indeed,to avoid this I'm setting default values for every field in datatable,for numeric 0, for strings but for blob ??? From: Jiri Cincura disk...@cincura.net To: Mr. John mr_joh...@yahoo.com; For users and developers of the Firebird .NET providers

[Firebird-net-provider] Help with retrieving/binding image from database

2012-11-02 Thread Mr. John
Hi !  I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0   I want  to save and retrieve/bind image from/to picture box control image database field :   F_IMAG      BLOB SUB_TYPE 1 SEGMENT SIZE 4096 saving to database :          Dim IMG As New Bitmap(PictureBox1.Image)            

[Firebird-net-provider] Help with retrieving/binding image from database

2012-11-02 Thread Mr. John
Because yahoo put this email in Spam folder  I've moved code into pastebin.com  links  and resend it : Hi !  I'm using VB.2008 with FB 2.5/,Net provider version 2.7.7.0   I want  to save and retrieve/bind image from/to picture box control image database field :   F_IMAG      BLOB SUB_TYPE 1

Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used

2012-07-27 Thread Mr. John
From: Jiri Cincura disk...@cincura.net To: Mr. John mr_joh...@yahoo.com; For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Saturday, July 28, 2012 8:03 AM Subject: Re: [Firebird-net-provider] Upgrade provider from 2.5 to 2.7

Re: [Firebird-net-provider] Switching to C# 5 compiler

2012-07-26 Thread Mr. John
Hi,just one question:  our applications targets to  framework 3.5,this way are using Firebird-net-provider 2.5.2.0 (date build: 14/02/2010) that is the last version with target to  framework  3.5, up to this is target to  framework  4. This way we can't update our provider as long we don't

[Firebird-net-provider] Upgrade provider from 2.5 to 2.7 - show VS immediate windows all command used

2012-07-26 Thread Mr. John
Hi ! I just updated provider from version 2.5 to 2.7 but in Visual Basic immediate window I see all SQL command that provierder is working with during application run,I can see there lots of statements scrolling,that was not in previous version,can this be turned off ?  here is a screenshot :

Re: [Firebird-net-provider] Elegant way to detect Generator for Column

2008-09-12 Thread Mr. John
Hi ,I think this question should be asked in firebird-support list. As I know,generators are independent objects,stored in database.You better have to look for BEFORE INSERT triggers that use generators. - Original Message From: Michael Möhle [EMAIL PROTECTED] To:

Re: [Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-08 Thread Mr. John
, 2007 9:22:28 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager On 10/6/07, Mr. John [EMAIL PROTECTED] wrote: Thanks for answer.I don't know how to make it work.Report manager came with these 2 files : C:\Program Files\Report Manager\net

Re: [Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-08 Thread Mr. John
Thanks Carlos. With your suggestion I used gacutil.exe and now It works fine.Thanks a lot. - Original Message From: Carlos [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent: Monday, October 8, 2007 6:00:44 PM

Re: [Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-08 Thread Mr. John
6:29:22 PM Subject: Re: [Firebird-net-provider] Problem with connection strig using Report Manager On 10/8/07, Mr. John [EMAIL PROTECTED] wrote: section name=firebirdsql.data.firebirdclient type=System.Data.Common.DbProviderConfigurationHandler, System.Data, Version

Re: [Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-08 Thread Mr. John
I have I silly question : do I have to make this configuration on every computer that I install my application ? Thanks. - Original Message From: Mr. John [EMAIL PROTECTED] To: For users and developers of the Firebird .NET providers firebird-net-provider@lists.sourceforge.net Sent

[Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-06 Thread Mr. John
Hi ! I've discovered Report Manager (http://reportman.sourceforge.net/ ),free reporting solution and I've tried to connect using firebird and VB .Net 2005 Express.Connection manually works,but not using code.Has anyone used it?Thanks. I've got this error,on last line : An OLE DB Provider

Re: [Firebird-net-provider] Problem with connection strig using Report Manager

2007-10-06 Thread Mr. John
Thanks for answer.I don't know how to make it work.Report manager came with these 2 files : C:\Program Files\Report Manager\net\FirebirdSql.Data.Firebird.dll C:\Program Files\Report Manager\net\fbembed.dll - Original Message From: Carlos Guzmán Álvarez [EMAIL PROTECTED] To: For users