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
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
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:
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
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
_
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
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.
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
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
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
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
-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
12 matches
Mail list logo