Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Collate in Table


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 1 - Last Post: Jul 18, 2014 9:54 AM Last Post By: quinn wildman Threads: [ Previous | Next ]
Łukasz Pszenny

Posts: 3
Registered: 10/10/09
Collate in Table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 18, 2014 8:14 AM
Hello,
I use Interbase 2009 and Delphi 2009.
I have problem with collation WIN-1250 PXW_PLK
Create Table:

CREATE TABLE "OBIEKTY"
(
"ID_OBI" INTEGER,
"NAZWA_OB" CHAR(20) CHARACTER SET WIN1250 COLLATE PXW_PLK
);
I use indexes for sorting but when start program shows up error: Division by zero.
I have components :IBTable,IBDatabase,SourceData,IBTransaction, DBGrid

In IBDatabase Params have lc_ctype=WIN-1250,all table and database have too WIN-1250

Please help cause i cant sort my data( where first char is Ł,Ą,Ę,Ż,Ź,Ó)
quinn wildman

Posts: 856
Registered: 12/2/99
Re: Collate in Table  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Jul 18, 2014 9:54 AM   in response to: Łukasz Pszenny in response to: Łukasz Pszenny
Łukasz Pszenny wrote:
I use indexes for sorting but when start program shows up error: Division by zero.

It's unlikely you are really using an index for sorting, but that's not
a problem. Almost certainly you are ordering, not sorting. For ordering,
you specify a field, not an index. TIBTable does let you select an
index, but what it is really doing is picking an order by based on the
fields of the index. InterBase then looks at your SQL statement and it
decides to use the index to save time. However, this is all semantics.

Again, while not your problem here, I do recommend you use a TIBQuery or
TIBDataSet instead of a TIBTable. It's more efficient.

Now, as to your problem, there is insufficient data so far. I recommend
you use the debugger to determine what line in your code is causing the
divide by zero error. I also recommend you make active be false for your
IBDatabase and your TIBQuery in the IDE. Set active to true (or call
open) in the onCreate method of the form that are in. This will allow
you to use the debugger and see if opening there objects is the problem
or something else.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02