Re: [SQL] ISNULL FUNCTION

2002-12-09 Thread 2000 Informática
- Original Message - From: "Héctor Iturre" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 09, 2002 11:30 AM Subject: [SQL] ISNULL FUNCTION > HI, >HERE IS AN ALTERNATIVE TO USE THE SQL SERVER > ISNULL() FUNCTION > > > select case when FIELD_NAME isnull then 'EXPRES

[SQL] be or not to be ???

2002-11-17 Thread 2000 Informática
Hi all(s)...     Eu não sou confiável, no entanto, posso confiar no POSTGRES ???           Silvio 2000info      

[SQL] ADO with postgreSQL

2002-10-15 Thread 2000 Informática
Hi,   Thank you for the previous help (INNER BETWEN MORE THAN ONE DATABASES).     In the Visual Basic 6.0:     Dim dbConn as Connection, rs as recordset, strSQL as string, strConn as string       strConn = "Provider=MSDASQL.1;Extended Properties=""DRIVER={PostgreSQL};DATABASE=MyDataBase;SERV

[SQL] SELECT with INNER data bases

2002-10-10 Thread 2000 Informática
Hi,   I have two data bases: db1 and db2. In MS SQL Server I can use 'SELECT T1.ID, T2.NAME FROM db1..table1 T1 INNER JOIN db2..table2 T2 ON T1.ID = T2.ID ...'.   How I do it in the PosgreSQL ?   HELP ME, PLEASE !   Sorry, I'm a Brazilian and I don't speak and write English very well !   Sil