RE: [UV] Very slow SQL query

2004-02-20 Thread Cesar Riba
Cesar, You need to build the index also, try BUILD.INDEX FILNAME ALL In Unidata that is. Björn Eklund -Ursprungligt meddelande- Från: Cesar Riba [mailto:[EMAIL PROTECTED] Skickat: den 19 februari 2004 17:24 Till: 'U2 Users Discussion List' Ämne: RE: [UV] Very slow SQL query -Mensaje

SQL with UniObject

2004-02-23 Thread Cesar Riba
Hello, Can somebody can explain me how to build a soubroutine for executing SQL commands from Visual Basic and return of result in a UniDynArray. I need too insert sentences as like SELECT TO SLIST 0 FROM CUSTOMERS; Thanks, César Riba -- u2-users mailing list [EMAIL

RE: SQL with UniObject

2004-02-23 Thread Cesar Riba
: http://www-306.ibm.com/software/data/u2/pubs/library/ Regards David -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cesar Riba Sent: Tuesday, February 24, 2004 4:52 AM To: 'U2 Users Discussion List' Subject: RE: SQL with UniObject Hello, Your

Consult about SQL

2004-04-01 Thread Cesar Riba
Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks. César -- u2-users mailing list [EMAIL PROTECTED] http://www.oliver.com/mailman/listinfo/u2-users

RE: [UV] Consult about SQL

2004-04-02 Thread Cesar Riba
Message - From: Cesar Riba [EMAIL PROTECTED] Date: Thu, 1 Apr 2004 11:10:18 +0200 To: [EMAIL PROTECTED] Subject: Consult about SQL Hello, I'm a problem when use a SQL query that have one or various INNER JOIN this is very very slow. How I can accelerate this tipus of query. Thanks