Skip site navigation (1) Skip section navigation (2)

Re: MS SQL Migration

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'futrzak'" <futrzak(at)archie(dot)dhs(dot)org>
Cc: "'pgadmin-hackers(at)postgresql(dot)org'" <pgadmin-hackers(at)postgresql(dot)org>
Subject: Re: MS SQL Migration
Date: 2002-01-11 09:51:43
Message-ID: FED2B709E3270E4B903EB0175A49BCB1047406@dogbert.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: futrzak [mailto:futrzak(at)archie(dot)dhs(dot)org] 
> Sent: 11 January 2002 09:22
> To: Dave Page
> Subject: Re: MS SQL Migration
> 

Hi Artur,

Further to my previous email, I've updated the code to:

        ' AM 20020110
        ' driver don't returns correct values - setting to default 18,4
        If szTemp2 = "numeric" Then
          If
catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Type = adNumeric
Then
            szTemp2 = szTemp2 & "(" &
catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).Precision & ","
& catLocal.Tables(lstData.List(X)).Columns(newColumnArray(Y)).NumericScale &
")"
          Else
            szTemp2 = szTemp2 & "(" & "18" & "," & "4" & ")"
          End If
        End If

Does that look good to you?

Regards, Dave.

Responses

pgadmin-hackers by date

Next:From: futrzakDate: 2002-01-11 09:54:34
Subject: Re: MS SQL Migration
Previous:From: Dave PageDate: 2002-01-11 09:44:22
Subject: Re: MS SQL Migration

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group