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

2017-08-25 Thread paul.mercea
The trigger from you database has nothing to do with your c# code.You can use a stored procedure to insert data and returning latest id (also you can read current sequence value but you can have wrong value if other inserts happening). Sent from my Samsung Galaxy smartphone. Original m

Re: [Firebird-net-provider] Caching is possible?

2006-12-11 Thread paul.mercea
>> Entire system will fire database only when update will apear. >That is an Sql Server 2005 specific feature. It could be implemented using events from database. Probably best way is to use web service for that. Thanks, Paul -- Carlos Guzmán Álvarez Vigo-Spain http://carlosga.wordpress.com -

Re: [Firebird-net-provider] Caching is possible?

2006-12-11 Thread paul.mercea
Hi > How is possible to use some facility like caching data to eliminate > trafic from and to firebird server? Could you please post an example of sql server caching ?? Cache is verry useful for webapp. There are many type of cache (from page cache to sql cache) For page cache responsible is web

[Firebird-net-provider] Caching is possible?

2006-11-30 Thread paul.mercea
Hi In SQL Server is possible to use cache, page cache(on asp) or sql cache. In Interbase and Firebird was posibility to set schema cache dir. How is possible to use some facility like caching data to eliminate trafic from and to firebird server? Thanks, Paul ---

Re: [Firebird-net-provider] CheckBoxField

2006-11-22 Thread paul.mercea
Hi In web app u need to convert field to template and in Item template and Edit template u can drop the label and put checkbox. Regards, Paul _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bert Huijgen Sent: Wednesday, November 22, 2006 2:59 PM To: firebird-net-provi

Re: [Firebird-net-provider] CheckBoxField

2006-11-22 Thread paul.mercea
Hi If u Edit colums for a Grid change ColumnType to DataGridViewCheckBoxColumn, after that u'll have the possibility to specify TrueValu and FalseValue in Data group. Good luck, Paul _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bert Huijgen Sent: Wednesday, Novembe

Re: [Firebird-net-provider] CheckBoxField

2006-11-22 Thread paul.mercea
Hi I get same error with -1 and 1 value. Works ok with Y and N . Set TrueValue and FalseValue to your values. Regards, Paul _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bert Huijgen Sent: Tuesday, November 21, 2006 10:40 PM To: firebird-net-provider@lists.sourcefo

[Firebird-net-provider] Whow can I edit and encrypt conection string in web app?

2006-11-10 Thread paul.mercea
Hi I', using Firebird 2.0 for database in a web app . In web.config I have conection string to database. In that string user password is in plain text. I know is poible to encrypt section from web.config. That's ok. But, this webapp will be deployed on several servers with different database name

[Firebird-net-provider] Generating error on dataset using PLAN

2006-11-06 Thread paul.mercea
Hi I'm using Firebird 2.0 RC5 server and Firebird .net provider 2.0.1 . I have this sql statement in dataset (xsd): select * from sys_mu where visible='Y' PLAN (SYS_MU ORDER SYS_MU_NAME INDEX (SYS_MU_VISIBLE)) order by uni_name When is trying to generate select generate error because PLAN word

Re: [Firebird-net-provider] How to get Generator value

2006-11-05 Thread paul.mercea
Hi   Current generator value is generator_value=GEN_ID(generator,0); You can increment with 1 generator value with Gen_ID(generator,1);   REgards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Pham Huu Le Quoc PhucSent: Monday, November 06, 2006 9:42 AMTo: firebird-

Re: [Firebird-net-provider] Create or update a table

2006-11-05 Thread paul.mercea
database structure too,if I'll update one user's application i have to update his databases structure too. Thanks ! - Original Message From: paul.mercea <[EMAIL PROTECTED]>To: For users and developers of the Firebird .NET providers Sent: Sunday, November 5, 2006 5:32:

Re: [Firebird-net-provider] Create or update a table

2006-11-05 Thread paul.mercea
Hi   Your intention is to have one version database and 'syncronize' this structure to other databases?   Regards, Paul From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ionut IchimSent: Saturday, November 04, 2006 11:47 PMTo: firebird-net-provider@lists.sourceforge.netSubjec

[Firebird-net-provider] Nbackup and Firebird .Net

2006-10-27 Thread paul.mercea
Hi I don't know if nbackup have service support in firebird, but if does, it will be supported in provider? Thanks, Paul - Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly wi

Re: [Firebird-net-provider] slow connection

2006-10-13 Thread paul.mercea
First off allyou don't need 1 mill records...try to get olny 100-1000 records. Users don't need 1 mil records to view!   Regards From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rick RoenSent: Friday, October 13, 2006 5:04 PMTo: firebird-net-provider@lists.sourceforge.ne

Re: [Firebird-net-provider] deadlock

2006-10-03 Thread paul.mercea
Try to make a back-up - restore, an see after that if error occures again. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Smith Sent: Tuesday, October 03, 2006 11:05 PM To: For users and developers of the Firebird .NET providers Subject: Re: [Firebi