Excuse me, I got problems when converting excel table to interbase database. I use access to convert excel table to paradox db file, but got "network or disk...
30
Silvano Lago
silvano.lago@...
Aug 3, 2000 2:52 pm
didn't you need to create a ODBC alias to convert table from excel to parador and the access ??? And, did you try open excel file in database desktop, or...
31
Evandro Luquini
evandro.luquini@...
Aug 3, 2000 2:54 pm
Por favor, use o telefone para coisas urgentes, e o email iname para informativos pessoais. Valeu, mano velho!!! ... From: Silvano Lago...
32
Francisco Hernandez
xy0xy0@...
Aug 5, 2000 7:56 pm
hi, im a new Interbase user.. I would like to convert PostGreSQL code to Interbase.. if i find that Interbase is more powerful, but im having a bit of a...
33
Helen Borrie
helebor@...
Aug 6, 2000 1:03 am
... This is a bug in the IBConsole program. Until it is fixed, you can get an older version (.308) from the inprise.com/interbase download page. It has other...
34
Claudio Valderrama C.
cvalde@...
Aug 6, 2000 4:23 am
I suggest that you access the newsgroup mers.interbase.list or its mirror email list at www.mers.com, because this is not a conversion problem. You will find a...
35
Claudio Valderrama C.
cvalde@...
Aug 6, 2000 4:34 am
A safer way could be to save your data in a fixed format, then define an external table in Interbase and copy from that table to a typical (internal) table of...
36
Helen Borrie
helebor@...
Aug 6, 2000 4:42 am
... I had this problem on an Excel conversion, due to insufficient temp disk space. Have you tried cleaning out old, outdated files from your \temp or \tmp...
37
Moni Kriesmann
monikriesmann@...
Aug 6, 2000 6:25 am
hi, im a new Interbase user.. I would like to know where i can get some examples for ibx using the special issues from TIBDataset and TIBSQL and the new admin...
38
Helen Borrie
helebor@...
Aug 6, 2000 6:33 am
... Download the Interbase 6 beta documentation from www.interbase.com. The Developer's Guide has several sections on the IBX controls. Helen ...
39
Danny Lewis
lewisd@...
Aug 10, 2000 6:12 pm
Is there a way to see past questions and answers to this group without reasking all the same questions? I'm mainly looking at ways to convert (if possible)...
40
Helen Borrie
helebor@...
Aug 10, 2000 6:25 pm
... You can go to http://www.egroups.com/messages/ib-conversions or go to http://www.egroups.com/group/ib-conversions and click the Messages button. The...
41
Claudio Valderrama C.
cvalde@...
Aug 11, 2000 2:33 am
Please, post in plain text. To be able to follow the link Helen gave you, probably you need to signup or subscribe with egroups, but you'll lose nothing,...
42
Bruno Mattarollo
bruno@...
Aug 16, 2000 3:07 pm
Hello, I have a datamodel designed for Oracle 8i and I am migrating it to Interbase 6 (running on LinuX/OS -based on RedHat 6.0) ... I have a table, for...
43
Helen Borrie
helebor@...
Aug 16, 2000 3:51 pm
Since Interbase always creates indexes for keys, the limit isn't (pedantically speaking) on the size of the key but on the size of the index. The maximum index...
44
Claudio Valderrama C.
cvalde@...
Aug 17, 2000 2:55 am
... [...] ... [...] ... Certainly there's a limit. I hope I succeded in introducing that information in the final IB6 docs that Inprise still doesn't release....
45
Bruno Mattarollo
bruno@...
Aug 17, 2000 7:40 am
Hello Thanks to Claudio and Helen for their reply ... Hmmm ... I don't like very much to have a limit of 255 bytes on the length of my keys ... What am I...
46
Nando Dessena
nandod@...
Aug 17, 2000 7:54 am
Bruno, ... FWIW, I believe that the design is screwed up enough by itself if you need primary keys that large; I agree that the limitation should be removed,...
47
Helen Borrie
helebor@...
Aug 17, 2000 8:00 am
... Actually, as Claudio correctly pointed out, the limit is 252 bytes. I think it is possibly a bit too short for 3 or 4-byte character keys. I have a...
48
Andreas Tille
tillea@...
Aug 17, 2000 9:29 am
Hello, I'm in the process of migrating a database from MS SQL to a free database. I just managed to convert the Tables and data to PostgreSQL, but not the...
49
Helen Borrie
helebor@...
Aug 17, 2000 9:54 am
... True: they are reserved words (also in Delphi, if you were thinking of using your database with that, which means also Kylix). However, in IB 6 you can use...
50
Andreas Tille
tillea@...
Aug 17, 2000 10:22 am
... I think it would be best to change the names because I don't want to use quotes in the future. ... I do have some longer texts which I thought I have to...
51
Andreas Tille
tillea@...
Aug 17, 2000 10:38 am
Hello, I've shortened my problem as much as possible to show the effect. I have to tables created as CREATE TABLE Menu ( IdMenu int NOT NULL , PRIMARY KEY...
52
Helen Borrie
helebor@...
Aug 17, 2000 10:59 am
... It is implemented as blob sub_type 1, although it's not a big deal as, to InterBase, a blob is just a blob. You could do best by finding a utility which...
53
Nikolaus Wagner
Nik@...
Aug 17, 2000 11:04 am
Helen Borrie wrote: I've done M$SQL and Access conversions via both the BDE and the external methods - I've tended to use the BDE for blobs because it's...
54
Helen Borrie
helebor@...
Aug 17, 2000 11:06 am
... So leave out CONSTRAINT - it's not syntax. NOT NULL is a recognised column constraint. I'm darned if I know what it was trying to do there! Now you know...
55
Helen Borrie
helebor@...
Aug 17, 2000 11:27 am
... Nice GUI, no. Horrible GUI, yes, somewhere, I'll see if I can find it and I'll zip it up and put it into the Files area of this list. You'd need to work...
56
Andreas Tille
tillea@...
Aug 17, 2000 12:36 pm
... Thanks, this works. ... May be he reads this on the list? ... Thanks, I've found it. I really would love it if there would be an SQL-output like pg_dump ...
57
Andreas Tille
tillea@...
Aug 17, 2000 12:39 pm
... Just for the sake of interest - I'm a very beginner: What are gdbs. And what is BDE? Kind regards Andreas....
58
Helen Borrie
helebor@...
Aug 17, 2000 1:39 pm
... Oh - you want an SQL dump? (Sorry, I don't know anything about the PG tools, haven't gone near PostGresql yet). On Linux, use the isql program. The...
