--- In firebird-support@yahoogroups.com, jwcane2003 jwcane@... wrote:
The following insert command is an example of what I would like to use to
enter dummy data into my database for testing:
INSERT INTO residents (First, Last, Bldg, Unit, cbRelease, Email, lbOwnRent)
Hi,
Looking for a safe and reliable import process from csv data to firebird
db. Any pointers or other info appreciated.
If this is a one-time thing, you could try Database Workbench - see
www.upscene.com
If you need to automate this, you can take a look at FBExport:
Roy Damman wrote:
Third query:
select TESTID, NAME from test
union select TESTID, NAME from test order by upper(2)
Answer (Unexpected):
An error message: ISC ERROR CODE:335544569 ISC ERROR MESSAGE:
Dynamic SQL Error
SQL error code = -104
Invalid command
invalid ORDER BY clause
Hello Set,
This puzzles me, although I'm uncertain whether I'm puzzled by upper(2) not
working with UNION or puzzled by upper(2) working without UNION.
Having a closer look, it appears that the resultset of the non-union query is
not properly sorted.
Here, I first wrote that it
Hi Philip,
thanks for the link - a very useful article!
Right now the biggest table I have contains 146 fields:
21 blob fields (= 84 bytes? as only BLIB_ID is being stored)
6 decimal (5,2) fields (= max. 48 bytes)
29 double precision fields (= max. 232 bytes)
8 integer fields (= 32 bytes)
8
On 6/28/12 1:14 AM, jwcane2003 wrote:
Looking for a safe and reliable import process from csv data to firebird db.
Any pointers or other info appreciated.
Database Workbench does a good job. I use the CSV import all the time.
Also check out www.cvsexpress.com
Also IBexpert - ibexpert.com. Very fully featured tool.
Alan J Davies
Aldis
On 28/06/2012 11:14, Doug Chamberlin wrote:
On 6/28/12 1:14 AM, jwcane2003 wrote:
Looking for a safe and reliable import process from csv data to
firebird db. Any pointers or other info appreciated.
I did the conversion in flamerobin.
Selected the table on the tables tree, opened the form and changed the
attribute types.
I expected some trouble as i didn't know if there was some data in the columns,
but no hassle then .
I later solved this by dropping both columns and recreating
select * from (select TESTID, NAME from test
union select TESTID, NAME from test) t order by upper(2)
Best Regards
=
|| ISMAEL ||
=
- Original Message -
From: roydamman
To: firebird-support@yahoogroups.com
Sent: Wednesday, June 27, 2012 12:22 PM
Subject:
On 28-6-2012 9:21, Svein Erling Tysvær wrote:
Maybe I am wrong but I always thought the order by is applied on the
results of the two selects in both the second and third union query.
And the order by clause does work in the second query (also an union
query) order by 2 and does not work in
pablosanchezuy wrote:
I did the conversion in flamerobin.
Selected the table on the tables tree, opened the form and changed the
attribute types.
I expected some trouble as i didn't know if there was some data in the
columns, but no hassle then .
When you do that in FlameRobin, it
Hello,
what tool do you use to visually make a graph of a database ?
Actually i use Visio, but it's slow, and most of all it's not possible to see
diff between 2 visio files
thanks !
On 28-6-2012 16:44, nathanelrick wrote:
Hello,
what tool do you use to visually make a graph of a database ?
Actually i use Visio, but it's slow, and most of all it's not possible to see
diff between 2 visio files
thanks !
You could look at DB Designer Fork
If you want the easy way, then change the field type to a text blob, and
output it as is. Works perfectly.
The hard way is the way you have it now. To get the data you ideally
create a select stored procedure and you then need to :
find each instance of a hard return (ascii32 ?)
say HR1
copy
On 28-6-2012 18:42, Mags Phangisa wrote:
I have a field that takes 1000 characters. When the data is captured it is
in paragraphs but when it is displayed in a report it comes up as a single
(big) paragraph.
Is there a way to pick up the return key so that I can display the data in
the same
Hi Alan,
I have changed the field to a text blob but the hard return is still not
being recognised. I use ibase_blob_echo($rec-FLDNM) to display the data.
What could I be doing wrong?
Mags
On Thu, Jun 28, 2012 at 8:04 PM, Alan J Davies
alan.dav...@aldis-systems.co.uk wrote:
If you want the
On 28-6-2012 20:04, Alan J Davies wrote:
If you want the easy way, then change the field type to a text blob, and
output it as is. Works perfectly.
VARCHAR and CHAR fields can also contain linebreaks. There is no need to
use blobs.
Mark
--
Mark Rotteveel
When capturing I have no problem Mark the problem is when I retrieve and
display the data. I would love get a way to display the data without having
to loop thru the data.
Mags
On Thu, Jun 28, 2012 at 9:28 PM, Mark Rotteveel m...@lawinegevaar.nlwrote:
On 28-6-2012 20:04, Alan J Davies wrote:
On 29 Jun 2012 01:02, Mark Rotteveel m...@lawinegevaar.nl wrote:
On 28-6-2012 16:44, nathanelrick wrote:
Hello,
what tool do you use to visually make a graph of a database ?
Actually i use Visio, but it's slow, and most of all it's not possible
to see diff between 2 visio files
Hello Ismael!
select * from (select TESTID, NAME from test
union select TESTID, NAME from test) t order by upper(2)
The query is indeed accepted by Firebird, but the sorting result is wrong as
for a single select (as found out later).
20 matches
Mail list logo
