[firebird-support] Re: How to return only a few rows from select sql statement

Hi Walter, Thanks for your reply. Could you give me an example how to use clauses FIRST, SKIP or ROW TO? Thanks and regards, Sugiarto --- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: Of course, you can to use clauses FIRST, SKIP or ROW TO Additionally, you

[firebird-support] Re: How to return only a few rows from select sql statement

Hi Walter, Thanks for your answer. Best regards, Sugiarto --- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: Of course, you can to use clauses FIRST, SKIP or ROW TO Additionally, you can use a WHERE clause. Greetings. Walter. On Thu, Jan 19, 2012

Re: [firebird-support] Re: How to return only a few rows from select sql statement

Thanks for your reply. Could you give me an example how to use clauses FIRST, SKIP or ROW TO? Thanks to the efforts of Paul Vinkenoog et al., this is well documented. ;-) FIRST / SKIP:

RE: [firebird-support] MS Access ODBC to Firebird

Michael, I know the odbcfb.dll is installed. I can pick firebird /interbase driver from the odbc setup. I cannot get a result on the Test Connection. I have tried every syntax for the db name, with no change. Path isP:\AdminBase\Database\ADMINBASE32.GDB I tried

RE: [firebird-support] MS Access ODBC to Firebird

Thank you also. I have made a connection directly through teh access db, using machine data source. It appears to connec the table and opens repreatedly after ms Access is restrtaed. It gives error 902 or 904 if I try to use a file data source. So, progress, but uncertain! Peter _

Re: [Bulk] [firebird-support] Is Update or Insert more slower than an single Update (or insert)

Vander Clock Stephane wrote: Thanks to my paranoia, i was thinking like everyone that Update or insert OR Insert Well, it is called UPDATE OR INSERT, and not INSERT OR UPDATE. As you can see, update comes first. -- Milan Babuskov == The easiest way to

Re: [firebird-support] Migrating from MySQL to Firebird

Go Green wrote: I have never used firebird and therefore wanted to know how it fits when compared to MySQL in terms of: If you use MyISAM, then the answers are: ANSI SQL compliance Firebird is much better. Triggers Firebird is much better. Foreign Keys Firebird is much better.

Re: [firebird-support] Tools to migrate from MySQL to Firebird

Rohit wrote: I want a free tool to migrate an existing MySQL database to Firebird. Is there any tool? I wrote a quickdirty PHP script that works on SQL structure dump from PHPMyAdmin: https://github.com/mariuz/mysql2firebird It's still rough and does not support all MySQL datatypes, but

Re: [firebird-support] How to return only a few rows from select sql statement

trskopo wrote: Suppose I have a sql statement : select * from table Is that possible to return only a few rows from that statement (not the whole result), just like MySQL? http://www.firebirdfaq.org/faq111 HTH -- Milan Babuskov == The easiest way to

Re: [firebird-support] Database owner question

Hello Thomas, Il 19/01/2012 18.49, Thomas Steinmaurer ha scritto: I am developing an accounting program and some recent posts made me seriously think about security. ... If you are on Windows, you could also investigate Firebird's Windows authentication capabilities, which has been added in

RES: [firebird-support] How to return only a few rows from select sql statement

Try: select first 5 * from table De: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Em nome de Milan Babuskov Enviada em: sexta-feira, 20 de janeiro de 2012 09:40 Para: firebird-support@yahoogroups.com Assunto: Re: [firebird-support] How to return only a few rows

RE: [firebird-support] Sizing conversion project - Email found in subject

-Original Message- From: firebird-support@yahoogroups.com [mailto:firebird- supp...@yahoogroups.com] On Behalf Of Doug Chamberlin Sent: Friday, January 20, 2012 6:26 PM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] Sizing conversion project - Email found in